I am trying to start a remote DTS package from code and I am getting the
following error:
Description='[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not
found.'
Error=-2147467259'
Source='Microsoft OLE DB Provider for SQL Server'
When I run the code from the local machine it works perfectly fine. Anyone
got any ideas?
The code (C# .Net) is shown below:
object obj = new object();
int intCookie;
cpPoint.Advise(PES, out intCookie);
pkg.LoadFromSQLServer(DtsSettingsSection.Server,
DtsSettingsSection.Username,
DtsSettingsSection.Password,
DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,
"",
"",
"",
DtsSettingsSection.Package,
ref obj);
// The real work is done here...
pkg.Execute();
pkg.UnInitialize();
--
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.