Controls disappear

Is it not possible to execute one package and then design another package? I am executing one package and trying to design another package and just have a grey window in the control tool box that says:

"there are no usable controls in this group. Drag an item onto this text to add it to the toolbar"

Can I only get my controls by dragging when another package is executing? Where do I drag them from?

Thanks,

Kayda

You seem quite new to this and some things are very odd about SSIS.

The controls are dragged from the Toolbox window. Get this by clicking on the "spanner and hammer" icon at the top. Or Crtl+Alt+X or via the menu View->Toolbox.

You have to be on the Control Flow or Data Flow panels. You get different tools for the 2 different contexts.

Also, you need to check you are executing the correct package. In the Solution Explorer, under the SSIS Packages folder right click on your xxxxxx.dtsx file and select "Set as StartUp Object" for the package you want to execute ... or just select "Execute Package" to run the one you want. You have to stop debugging the previous package before you design or run the next one.

Since you have already done one package, I may have misunderstood your questions.

Hope this helps

|||

Hi Kayda,

The Visual Studio Integrated Development Environment (IDE) changes modes when the debugger starts. It disables most editing functionality until it exits debug mode. It also hides controls in the toolboxes. This is by design.

Although the package execution is complete, the IDE remains in debug mode until stopped (Shift-F5 or the VCR-style Stop button will do it).

This is different from DTS and a normal source of confusion for folks making the transition.

Hope this helps,
Andy

|||Perhaps you could open a second session of BIDS; or use DTExec or DTExecUI to execute the packages while still developing other packages