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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Any other way for this ???

Author  Topic 

karuna
Aged Yak Warrior

582 Posts

Posted - 2002-10-23 : 01:50:08
This is with reference to the post

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=20292

Is there any other way to improve on this solution???....

Karunakaran

Don't wait for things to happen,Make them to happen...

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-10-23 : 07:06:49
Why start a new thread?

Why not use the IDENTITY as nr suggested? On your transformations tab, just don't assign a transform to you IDENTITY column. Why are your transactions ActiveX ... since you aren't actually doing anything to the data other than straight pumping it in, the copy column type transformation will be much faster.

Jay White
{0}
Go to Top of Page
   

- Advertisement -