DTS not running from other machine | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS not running from other machine

I have DTS in one sys…. Eben though the destination folder is shared…. when do dts from SQL Query Analyzer I get the following error… but it runs through Enterprise manager…..<br /><br /> EXEC master.dbo.xp_cmdshell ‘dtsrun /SLOCSERVERLOCSRVRFS2 /Usa /Psa /NTest'<br /><br />Pls can anbody help me out<br /><br />thanks<br />Rashmi[<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />!][B)]
What is the error when running from QA? Try to use UNC path names instead of shared drives in the dts package. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I am getting this error DTSRun: Loading…
DTSRun: Executing…
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0 Error Detail Records:
What is the authentication mode used to connect the SQL server?
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
SQL Login….. is the authentication…. Should i Make it windows login??????
sometimes it doesnot show any error it shows completed successfully but…. I am creating a dbf file from sql table … which will not be created
Use Mixed authentication to connect to SQL server and enable DTS package logging as follows: To enable package logging Open the Data Transformation Services (DTS) package for which you want to create a log.
On the Package menu, click Properties to display the DTS Package Properties dialog box.
Do one of the following:
Save package logs to Microsoft® SQL Server™ by clicking the Logging tab, selecting the Log package execution to SQLServer check box, and then clicking an available server on which to save the package logs.
Security Note When possible, use Windows Authentication. Save package logs to SQL Server 2000 Meta Data Services by clicking the Advanced tab, and then selecting the Show lineage variables as source columns and Write lineage to repository check boxes. On the Package menu, click Save As, and then in the Save DTS Package dialog box, in the Location list, select Meta Data Services.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>