how to generate a new auto-increment primary key in Data Transformation Service

(#1)

winnie Offline

Registered User

Posts: 1

Join Date: Oct 2007

how to generate a new auto-increment primary key in Data Transformation Service - 17-10-2007, 03:32 AM

I transfer the data from microsoft access to sql server through Data Transformation Service.

>>>1st, I need to generate a new auto-increment primary key for the new table by using DTS.

>>>Can i insert distinct data into sql server through DTS?
eg. I have data of customerA with 2 diffrent IC no and 2 customer no from original database, how to select distinct data of customerA?

Actually, I am new to DTS.
Therefore, may i know how to write the script to generate it???

Thanks alot...^.^

winnie

Tags

autoincrement, data, generate, key, primary, service, transformation

« Hosted Server 7 Is Down | Language of Emails Resolved - small howto »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Teamwork - Data Transformation Service for 3rd Party Database	webcast_guy	Wont Implement / Already Implemented	1	09-08-2007 07:57 PM