DTS Problem - Copy SQL Server Objects Task

Question

DTS Problem - Copy SQL Server Objects Task

suresh_yaram

SSC Veteran

Points: 267
More actions
June 26, 2006 at 11:01 am

#103190

Hi All

WE have a DTS package containing multiple 'Execute Package Task' objevts executes various DTS packages serially. While exectuing the underlying package, SQL Sevrer creates varius files under ...\Program Files\Microsoft SQL Server\80\Tools folder with extensions PRC, ID1, ID2, DR1, DR2 etc....

Now the problem is, we get following error.

Step 'DTSStep_DTSTransferObjectsTask_10' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The system cannot find the file specified.
(Microsoft Data Transformation Services (DTS) Package (80070002): The system cannot find the file specified.
) (Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on '<Server>.<db>.DR2'. The system cannot find the file specified.

Please let me know if you have any clue on this issue.

Thanks in advance,
Suresh

Viewing 3 posts - 1 through 2 (of 2 total)

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

lucky-80472 SSCertifiable Points: 7793 More actions · Answer 1

Hello Suresh,

If you can take a look in the DTS package for the step "DTSStep_DTSTransferObjectsTask_10", you will find that the particular step is looking for the file to be tranfered or copied over to another location. So this file is not present at the source path.

Hope this helps you in finding the root cause.

Thanks and have a great afternoon!!!

Lucky

suresh_yaram SSC Veteran Points: 267 More actions · Answer 2

Hi Lucky,

Thanks for your reply..

Here is Source is a SQL sevrer database. We use 'Copy SQL Server Objects Task' to copy the SQL Server Database from one server to another server. WHile doing so, SQL Server creates some files in Tools folder as I mentioned in my original post. I receive error while creating a file with DR2 extension.

I would like know the reason.

This task will be successfull if it is executed manually.

Any idea??

Thanks

Suresh