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)
 connection

Author  Topic 

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2005-08-16 : 11:13:36
Hi,
I would like to transfer the tables from an Access database into a sql server databse.
I can do this individually using a Trasformation Task for each table.
but If I have several Tasks going from one Access file to one Sql server using one connection, then there will be an error something like "connection busy for trasnfering another data..."

Does this mean I have to have one separate connection for each transformation Task?
Thanks
   

- Advertisement -