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.
| Author |
Topic |
|
Natec728
Starting Member
1 Post |
 Posted - 2005-02-17 : 20:46:42
|
| Hey everyone, I have a DTS package that I am calling in a VB.NET application that copies about 6 tables from an Access mdb to a SQL server 2000 database. It works fine on my development machine, but when I run the program on a client it breaks when i set the dts package. I assume this is because sql server is not installed on this machine. But I have copied all necessary DLL's and it still breaks. Breaks at line:opkg = new dts.packageAny suggestions? |
|
|
jcragle
Starting Member
2 Posts |
Posted - 2005-02-18 : 10:44:18
|
| Does your DTS package have a connection to the SQL server stating LOCAL... if so make the connection with the server name or IP Enterprise manager does this on editing DTS packages from remote clients.. |
 |
|
|
|
|
|
DTS package fails on non local machine