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