Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Posts
    10

    Question Unanswered: SQL DTS Job Fails where Execute of package works?

    I have a SQL DTS package that imports a text file as one wide column into a two column SQL table, one is an identity seed. So essentially I import then parse the data using the index key as it is 3 seperate lines of data. All works fine by running the DTS package using execute. When I schedule this as a job it fails. It indicates that I have additional white space after a column. Any thoughts on why this can ocurr?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You know that when it's scheduled it runs under the context of the sql server service account...

    AND it's see the server mappings...not yours....

    could that be your problem?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Posts
    10

    Same user account as Services was used.

    As this is an automated task, that runs 7 times a day, I debug it using the same account as the services and logged into the SQL server.

  4. #4
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    check the file path...

  5. #5
    Join Date
    Jun 2003
    Posts
    10

    Thumbs up Thanks rohitkumar

    In testing I navigated to the text file, which is on a share on our ftp site server. I did not change the naming convention back to the server name share name syntax. Once done all went well.
    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •