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 2008 Forums
 SSIS and Import/Export (2008)
 SSIS INCREMENTAL LOAD

Author  Topic 

Sonu619
Posting Yak Master

202 Posts

Posted - 2010-10-15 : 01:15:08
Hi,

Can anyone help me? I have created a table and with a primary key called "ID".
However, I want the "ID" be auto increment as well.

Here is my question, how can I do in the following format:

"PIC0001", "PIC0002", "PIC0003", ............ etc.

Anyone can help me HOW I CAN DO THIS THROUGH SSIS.
Thanks.
   

- Advertisement -