Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 ssis

Author  Topic 

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-04-19 : 08:47:01
Hi,

can any one tel me when to use control flow and data flow in ssis.

i am not getting when to use and when not use and also i am not getting differences between these two.

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-04-19 : 09:15:52
data flow when you have data you want to transform/move.
control flow when you want to control the order of processing.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-04-19 : 09:27:14
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/72492/

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page
   

- Advertisement -