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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-19 : 11:19:54
|
Sagar writes "Hi!
I am executing a DTS Package using a .DLL file created in Visual Basic 6.0 which uses the DTS Object Library..
The code I have written is as below..in a VB.exe
Dim opkg As New DTS.Package
opkg.LoadFromSQLServer "servername1", "sa", "", DTSSQLStgFlag_UseTrustedConnection, "", "{F1610C5F-F1F0-11D4-905C-009027C12618}", "{67FF9824-E52F-11D4-905D-009027C12618}", "packgename"
opkg.Execute
Problem:
This code works fine if the application and package are at the server(servername1)..If I try to access another server(servername2) where the same package is there from the application at servername1 ..It doen't execute the package at servername2(Even if I change the servername1 to servername2).
(In one word the application is working fine when the datbase and the application are on the same server.Its not executing the package if the database and application are on two different servers)
Thanks in advance.
Sagar M K V" |
|
|
|
|
|
DTS