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

SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.

Kayako develops robust helpdesk software, live chat and real-time visitor monitoring software.

Kayako is trusted by more than 30,000 organizations, including a number of Fortune 500 companies and government institutions.

(#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, 02: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 Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Teamwork - Data Transformation Service for 3rd Party Database	webcast_guy	Archive	1	09-08-2007 06:57 PM