Post reply

DTS Package running in a job

  • May 11, 2006 at 6:58 am

    #68220

    I created a DTS package.  It was a simple one - transfer data from a table to a text file.  I exected the package and it ran fine.

    But when I put it in a job to run, it seemed to run fine but did not create the text file.  I just don't understand why?

    In the job

    EXEC master..xp_cmdshell 'DTSRun /S"Server" /U"user" /P"password" /N"DTSPackage" /W "0"'

    Can anyone help me?

    Thanks.

  • May 11, 2006 at 8:18 am

    #637267

    Is this a remote server?  When you "executed the package" did you do so from your machine or from the server?

    Also, check the file path.

  • May 11, 2006 at 8:48 am

    #637282

    The package will execute in the security context of the login designated for SQL Server Agent.  Make sure that login has permission to create the text file.

    Greg

    Greg

  • May 12, 2006 at 1:24 pm

    #637682

    Check the location of the text file.  If you used drive letters in the file name, the file was created from the server's perspective of where the drive letter is mapped, rather than your local machine's perspective.

    One way to troubleshoot this issue is to log onto the server either directly or remotely and attempt to execute the package.

    Good Luck!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply