Results 1 to 4 of 4

Thread: DTS issue

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: DTS issue

    In Microsoft SQL DTS I'm trying to run a package that convert output to a excel spreadsheet. Following error appears:
    Error source: Microsoft Jet Database Engine
    Error Description: Failure Creating File. What has added to my frustrations is, once I go to the server and open up the DTS package and click on destination it allows me to create new table, but that is only temporary. If I run a schedule job at a later time it fails again with the above message.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well if you're doing a CREATE, have you added the DROP?
    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
    Mar 2004
    Posts
    2

    DTS

    Brett, thanks for your reponse. It's only creating a dynamic table through DTS. When I take a look at the tables list it does not exist.

  4. #4
    Join Date
    Feb 2004
    Location
    Hamburg, Germany
    Posts
    22
    Take a look at this post -> should answer your question.

    http://www.dbforums.com/showthread.php?threadid=981661

    kbk

Posting Permissions

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