June 30, 2002 at 11:37 am
Hi there.
Here is my problem: I'm trying to copy a few tables from an ODBC database located on a PC on my LAN to a SQL Server on a remote server.
To do this I have created a DTS package on the SQL Server which runs smoothly, copying the data as it should, but only as long as it copies the data from the ODBC database on my own computer where I have Enterprise Manager installed. The moment I try to copy data from another PC in the network where Enterprise Manager is not used to execute the DTS package the task fails to run.
I'm quite at a loss here and would very much appreciate a notch in the right direction. Perhabs some source or book which I may read to solve the problem.
/Bakkegaard
July 1, 2002 at 6:50 am
If you are creating the DTS package from your machine then it references the ODBC data sources on your machine for the connection to the local database. When attempting to connect on the other PC they must have a like named ODBC datasource available else the package will fail.
My recommendation would be to create the ODBC DSN on the server, create the package from the server and use the previously created ODBC DSN and you should be good to go.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 1, 2002 at 12:20 pm
That should work...
July 2, 2002 at 2:26 am
Thank you very much for the reply. I'll try that right away.
/Bakkegaard
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply