Post reply

Test Error

  • May 10, 2005 at 2:00 pm

    #60838

    I have a Transformation Data Task that copies a text file into a table.

    When I go into the properties /Transformations tab and click on Test I get an error message:

    Error Source: Micosoft OLE DB Service Components

    Error Description: The system cannot find the path specified

    The path cound not be found.

    BUT...

    If I run the package it works like a charm.

    If I recreate the package from scratch the Test works fine.

     

  • May 10, 2005 at 2:43 pm

    #557895

    After you create the package... are you deleting the txt file?

    If you want to do any transformation the text file has to be there in the same place.

    Rgds

    JFB

     

  • May 10, 2005 at 2:46 pm

    #557897

    yes you can... from enterprise manager, mouse right click -->all task -->generate sql scripts.

    Rgds

    JFB

  • May 10, 2005 at 2:47 pm

    #557898

    The text file is always there it never gets deleted.

    Thanks

     

  • May 10, 2005 at 3:00 pm

    #557901

    But for some reason the path is changing some where.

    Please send me you pkg or descrive it more.

    Tks

    JFB

  • May 10, 2005 at 3:06 pm

    #557903

    its very simple.

     

    I have:

    1 text file source, 1 udl and a transformation task between the text file and the UDL.

    Then I map the column from the text file to the table in the database.

    The weird thing is that If I run it online it works fine.

     

     

     

     

  • May 10, 2005 at 3:21 pm

    #557906

    Sometimes is tricky to work with UDL connections. What type on connection is in the UDL?

    If you change anything on the UDL you have to do it on the file itself before continue designing the pkg.

    JFB

  • May 11, 2005 at 7:11 am

    #558055

    I have not changed anything on the UDL. Its type Sql Server.

     

     

  • May 11, 2005 at 8:27 am

    #558101

    I get the same error with my DTS.  I am simply taking a text file and importing it into SQL 2000.  It works fine from my laptop (I am using enterprise mgr to connect to the test server), but it fails if I execute it from anywhere else, including the test server itself.

  • May 11, 2005 at 8:30 am

    #558103

    Mine is a diffrent error. Everything works fine...but when I go into the transformation properties and click the test button I get an error.

     

    For your case are you pointing to the correct text file on the test server?

     

     

  • May 11, 2005 at 9:54 am

    #558140

    Are u using any map drive?

    Is the text file over the network?

    JFB

Viewing 11 posts - 1 through 10 (of 10 total)

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