"Ollie Riches" wrote:

> 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.
>
>