Debugging DataFlow components

I'm trying to do design time debugging of a dataflow component that I developed. I'm clearly doing something wrong, but I can't figure out what so I'm looking for suggestions if anyone has had a similar issue.

The reason I think I doing the steps correctly is that I can debug other components. However, that set seems to be limited to those developed in C#. My component is developed in VB. Shouldn't matter, I wouldn't think.

As a test I tried to debug other VB components from the SQL Server Samples and I have the same problem with them. Last one I tried was ChangeCaseVB. Though I just tried ChangeCaseVS and it didn't stop for me either...

The problem I have is when I drop the controls onto the design surface in the second instance of VS, the first instance of VS, which has the code for the component, does not hit any of the breakpoints, such as ProvideComponentProperties, which I know should be hit, and are hit when I debug a C# component.

To recap, I have an instance of VS open with the code for the component, developed in VB.

I compile the component.

I copy the component to C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents

I gacutil the component and then it shows in C:\WINDOWS\assembly

I add the component to the toolbox in my second instance of VS where I am designing the SSIS package which will host the component

I attach my first VS instance to my second VS instance

I drop the component on the designer in the second VS instance.

At this point I expect the first VS instance to hit a breakpoint, it does not.

I have also tried the method of setting the external program and command line arguements in the component's VS for running dtexec.exe directly.

Any suggestions?

Debugging VB or C# is exactly the same, no issues there. I cannot see anything wrong with what you describe, so some general pointers.

Make sure the component has been compiled, GAC'd and copied to the PipelineCOmponenst folder, before you open the second instance of VS that hosts the SSIS project. This will ensure you use the correct version of the assembly, when loaded by the SSIS project, that matches the code instance of VS.

Make sure your code project is set to a Debug build, rather than Release.

Be aware that some properties are design-time, so attach to VS as you have, but others are run-time, in which case, the extrenal program and dtexec is the best way. The design-time hosts (VS) and runtime host (ideally DTEXEC) are different so to debug different methods you need to be attached to the correct host. There is VS run-time host as well, more on that here-

Building, Deploying, and Debugging Custom Objects
(http://msdn2.microsoft.com/en-us/library/b03685bc-5398-4c3f-901a-1219c1098fbe.aspx)

|||

Thank you for the response and "reality check". I have been able to get debugging working now. I'd like to report that I had only one issue, but as I was testing with a variety projects trying to figure this out, they all seeminlgly had different problems, causing myself some extra grief. I still see the same issue from time to time, but overall it's going much better. Thanks for the help.

Debug is greyed out?

I know there's a trick to this, that I can't figure out.

Have an SSIS package that I developed and deployed/saved(?) to a file on the SSIS server. Now I need to change the data flows. Did that, no issues, lets me resave the file, but I can't debug or execute the package so I can test what I did is right? Why is the debug drop down box greyed out? There's gotta be something I'm missing here.

THanks,

Lezza

It needs to be part of a Visual Studio solution in order to debug it. I'm guessing that you just right-clicked on the package and selected 'Edit' right? ou can only make changes to it when you do that - not debug it

-Jamie

|||Thank you! Now, how do I get it to be a part of a Visual Studio Solution again? Is that what the Build function is for? I'm sorry, I'm an old-hand at DTS, but just starting on SSIS, and I've never used the VS gui before so the interface isn't as easy for me as for an experienced developer. I'm a pure DBA.|||

Reason I ask, is when I try to Build the solution, I get an error saying it can't find the path specified, and I get an error line at the bottom Error 1 Cannot create the output file "C:\SSIS Projects\\bin\PromoImport.dtsx": Could not find a part of the path 'W:\SSISPackages\PromoImport.dtsx'.. 0 0

I understand the path's, but I don't understand how I can change these paths? or what I'm supposed to have IN these paths to make it work.

Lezza

|||

With much digging, I finally found all the code behind the gui and muttled through. Thank you!

|||

Was there a published resolution to this?

I'm now encountering a similar situation. Right clicking in the Data Dlow design space used to popup a menu with 'Execute Task' (or something). I can't remember exactly what it was as the damn thing doesn't appear any more...?

I've been working on this package for a couple of weeks no problems until now. I've just entered a boatload of expressions in the Derive Column transformation, and I'm keen to see them in action.

Also the green debug arrow on the menu bar is greyed out.

I've done the decent thing, logged out & restarted etc. to no avail.

Any ideas?

|||

Are you editing it as aprt of a project? The previous guy on this thread wasn't and that was the problem.

|||

Ahhh. Yes I was going straight into the 'recent' file instead of into the project.

I have now unravelled the twisted knickers & my project & packages are once again showing me the love

Debug is greyed out?

I know there's a trick to this, that I can't figure out.

Have an SSIS package that I developed and deployed/saved(?) to a file on the SSIS server. Now I need to change the data flows. Did that, no issues, lets me resave the file, but I can't debug or execute the package so I can test what I did is right? Why is the debug drop down box greyed out? There's gotta be something I'm missing here.

THanks,

Lezza

It needs to be part of a Visual Studio solution in order to debug it. I'm guessing that you just right-clicked on the package and selected 'Edit' right? ou can only make changes to it when you do that - not debug it

-Jamie

|||Thank you! Now, how do I get it to be a part of a Visual Studio Solution again? Is that what the Build function is for? I'm sorry, I'm an old-hand at DTS, but just starting on SSIS, and I've never used the VS gui before so the interface isn't as easy for me as for an experienced developer. I'm a pure DBA.|||

Reason I ask, is when I try to Build the solution, I get an error saying it can't find the path specified, and I get an error line at the bottom Error 1 Cannot create the output file "C:\SSIS Projects\\bin\PromoImport.dtsx": Could not find a part of the path 'W:\SSISPackages\PromoImport.dtsx'.. 0 0

I understand the path's, but I don't understand how I can change these paths? or what I'm supposed to have IN these paths to make it work.

Lezza

|||

With much digging, I finally found all the code behind the gui and muttled through. Thank you!

Debug is greyed out?

I know there's a trick to this, that I can't figure out.

Have an SSIS package that I developed and deployed/saved(?) to a file on the SSIS server. Now I need to change the data flows. Did that, no issues, lets me resave the file, but I can't debug or execute the package so I can test what I did is right? Why is the debug drop down box greyed out? There's gotta be something I'm missing here.

THanks,

Lezza

It needs to be part of a Visual Studio solution in order to debug it. I'm guessing that you just right-clicked on the package and selected 'Edit' right? ou can only make changes to it when you do that - not debug it

-Jamie

|||Thank you! Now, how do I get it to be a part of a Visual Studio Solution again? Is that what the Build function is for? I'm sorry, I'm an old-hand at DTS, but just starting on SSIS, and I've never used the VS gui before so the interface isn't as easy for me as for an experienced developer. I'm a pure DBA.|||

Reason I ask, is when I try to Build the solution, I get an error saying it can't find the path specified, and I get an error line at the bottom Error 1 Cannot create the output file "C:\SSIS Projects\\bin\PromoImport.dtsx": Could not find a part of the path 'W:\SSISPackages\PromoImport.dtsx'.. 0 0

I understand the path's, but I don't understand how I can change these paths? or what I'm supposed to have IN these paths to make it work.

Lezza

|||

With much digging, I finally found all the code behind the gui and muttled through. Thank you!

|||

Was there a published resolution to this?

I'm now encountering a similar situation. Right clicking in the Data Dlow design space used to popup a menu with 'Execute Task' (or something). I can't remember exactly what it was as the damn thing doesn't appear any more...?

I've been working on this package for a couple of weeks no problems until now. I've just entered a boatload of expressions in the Derive Column transformation, and I'm keen to see them in action.

Also the green debug arrow on the menu bar is greyed out.

I've done the decent thing, logged out & restarted etc. to no avail.

Any ideas?

|||

Are you editing it as aprt of a project? The previous guy on this thread wasn't and that was the problem.

|||

Ahhh. Yes I was going straight into the 'recent' file instead of into the project.

I have now unravelled the twisted knickers & my project & packages are once again showing me the love