July 3, 2003 at 7:32 am
I created package that does data transformation (load data from Table1 from Server1 to Table2 that located on the Server2). If I run this package from Enterprise Manager or change it to transform data on one Server, it does not have any problems. If I am trying to run this package from Query Analyzer using two Servers, then I am getting Error:
________________________________________________________________________
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Error source: Microsoft OLE DB Provider for SQL Server
to run DTS package from Query Analyzer I am using:
exec xp_cmdshell 'DTSRun /S"ServerName" /E /N "PackageName"'.
I am using Windows authentication for both Servers.
How to run DTS package for data transformation between two Servers from Query Analyzer?
July 3, 2003 at 9:18 am
Did you tried running with the standard login? If not I would start with this
Shas3
July 3, 2003 at 10:18 am
quote:
What does it mean the standard login? Should I use SQL Server authentication?
July 3, 2003 at 10:35 am
Yes
Shas3
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply