Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    14

    Unanswered: DTS Jobs Troubles

    I'm trying to run DTS packages (import AS400 information) on a job and it fails, but when I program a DTS package job that imports from SQL Server to SQL Server it does not fail.

    What can I do?

    I hope your answer

    Thanks

    Cristopher Serrato

  2. #2
    Join Date
    Feb 2004
    Location
    Los Angeles
    Posts
    14

    Re: DTS Jobs Troubles

    Check your connectin string to AS400.
    is it a DB2 server ?
    Do you have DB2 Connectivity kit installed ?



    Originally posted by cjserrato
    I'm trying to run DTS packages (import AS400 information) on a job and it fails, but when I program a DTS package job that imports from SQL Server to SQL Server it does not fail.

    What can I do?

    I hope your answer

    Thanks

    Cristopher Serrato

  3. #3
    Join Date
    Mar 2004
    Posts
    14

    Re: DTS Jobs Troubles

    Originally posted by Ben Mansouri
    Check your connectin string to AS400.
    is it a DB2 server ?
    Do you have DB2 Connectivity kit installed ?
    I CHECKED MY CONECTION AND IT'S GOOD, EVEN IF I PLAY THE DTS PACKAGE, IT WORKS BUT WHEN I PUT IT INTO A JOB IT FAILS.

    I DOWNLOADED THE SERVICE PACK 3A, BUT IT DOES NOT WORK YET.

    WHAT COULD IT BE SO?

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Take help from this KBA to schedule a DTS package.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Feb 2004
    Location
    Los Angeles
    Posts
    14
    Is there any transformation envolved on DTS ?


    Originally posted by Satya
    Take help from this KBA to schedule a DTS package.

  6. #6
    Join Date
    Mar 2004
    Posts
    14
    Originally posted by Ben Mansouri
    Is there any transformation envolved on DTS ?
    No, the only one that I got is

    AS400 -> SQL SERVER 2000

Posting Permissions

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