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
 SSIS and Import/Export (2005)
 How to add sequence number in SSIS

Author  Topic 

goodsolution
Starting Member

38 Posts

Posted - 2009-08-28 : 12:43:24
I have a table having 2 columns (Col1, Col2) and i need to insert sequence number in Col1 and some values in Col2 using ssis2008, but Identity insert dont support in my destination db. so i need to populate the sequence number for it in SSIS 2008 and populate that value into the target db.



-Thanks

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-28 : 15:12:39
These may help:
http://weblogs.sqlteam.com/jamesn/archive/2008/02/13/60509.aspx
http://www.sqlis.com/post/Row-Number-Transformation.aspx

What do you mean by "but Identity insert dont support in my destination db"?
Go to Top of Page
   

- Advertisement -