SQL Server Performance

DTS not running from other machine

Discussion in 'SQL Server DTS-Related Questions' started by Rashmi_Shankar, Jun 30, 2004.

  1. Rashmi_Shankar New Member

    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)]
  2. satya Moderator

    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.
  3. Rashmi_Shankar New Member

    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:
  4. satya Moderator

    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.
  5. Rashmi_Shankar New Member

    SQL Login..... is the authentication....

    Should i Make it windows login??????
  6. Rashmi_Shankar New Member

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

    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.

Share This Page