Test Error

Question

Post reply

Test Error

JM-92548

Ten Centuries

Points: 1108
More actions
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.

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

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

jfb SSCrazy Points: 2469 More actions · Answer 1

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

jfb SSCrazy Points: 2469 More actions · Answer 2

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

Rgds

JFB

JM-92548 Ten Centuries Points: 1108 More actions · Answer 3

The text file is always there it never gets deleted.

Thanks

jfb SSCrazy Points: 2469 More actions · Answer 4

But for some reason the path is changing some where.

Please send me you pkg or descrive it more.

Tks

JFB

JM-92548 Ten Centuries Points: 1108 More actions · Answer 5

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.

jfb SSCrazy Points: 2469 More actions · Answer 6

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

JM-92548 Ten Centuries Points: 1108 More actions · Answer 7

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

MillerTime SSC Veteran Points: 234 More actions · Answer 8

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.

JM-92548 Ten Centuries Points: 1108 More actions · Answer 9

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?

jfb SSCrazy Points: 2469 More actions · Answer 10

Are u using any map drive?

Is the text file over the network?

JFB