Tuesday, February 14, 2012

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!

No comments:

Post a Comment