sql server dts: Hi,

I'm transfering data from a MySQL to MSSQL 2005 server. all working but
it takes forever ... its like its making some odd loops or so ...
700.000 rows transfered ... and thats all there is ... but it just keeps
loading ...

Using a ODBC connection to get the data from source, and sql for
destination ...

Are there anything I can change to speed it up or any other things I can
change ...

Its all local so its a mistory for me, why its takes such long time ...

I have not worked with MySQL and DTS. Here are a couple possible reasons for
delays.

The file is growing. Every time the SQL Server database file grows, your
DTS package will have to wait. As soon as the file has finished growing,
processing continues.

The following is theory: I haven't figured out how to verify this, but I
suspect that when the counter is advancing while executing, the changes have
not been committed in the database. Finally, at the end, the counter waits
for the transaction to be committed.

--
Russel Loski, MCSD.Net