can NOT find Control Flow Items

Question

can NOT find Control Flow Items

Beginner2012

SSC-Addicted

Points: 427
More actions
June 8, 2012 at 9:00 am

#275644

Hello,
I'm new to SSIS. I'm going throug a MSDN toturial
http://msdn.microsoft.com/en-us/library/ms170425(v=sql.105)
How ever, I'm getting stock at this step:
2.In the Toolbox, expand Control Flow Items, and drag a Data Flow Task onto the design surfaceof the Control Flow tab.
I can NOT find Control Flow Items in the tool box.
Help Please ?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 1

You need to switch to the control flow view. Chances are you are in the data flow view which is one level below control flow (control can call and control multiple data flows).

Right below the package tab, you should have a toolbar that says something like

Control Flow | Data Flow | Event Handlers | Package Explorer

Click on that first option

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

Did you do step 1:

1.Click the Control Flow tab.

Otherwise, you won't see the control flow items as Matt already suggested.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

robert.wu SSC Enthusiast Points: 111 More actions · Answer 3

Hi!

I'm having the same problem when using SQL Server 2008. (Sorry, I'm still looking for prior threads on this topic in the 2008 forum.)

I'm trying to create a new package and up to the part where I have clicked on the Control Flow tab. In my Toolbox, I only see Maintenance Plan Tasks and General. There is nothing under General. When I right-click and Show All, many other menus appear, all with options shaded and unavailable, but the control flow tasks do not appear.

When I right-click in there and select Choose Items, I do see the SSIS Control Flow Items tab. They are all unchecked. When I check them all and click Ok, they now all appear in the Toolbox under General.

Why doesn't my Control Flow menu appear in the Toolbox?

Thanks,

Rob