Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Undefined Task exception in DTS

Author  Topic 

karthikshanth
Starting Member

1 Post

Posted - 2006-09-07 : 02:11:20
We found an error while uploading a excel file using the DTS. The error which asked us to give some permission the sp's in master DB which start with the name sp_X . also we found the dtspkg.dll wasnt installed in programfiles.

we copied the dll's to the program files in the server and gave the permissions to some of the sp_x. then it worked fine.

Rishi Maini SQL2K5 Admin
Yak Posting Veteran

80 Posts

Posted - 2006-09-07 : 02:27:52
???? Do u have any question/query to be answered by Forum ????

Thanks
Rishi Maini
Go to Top of Page
   

- Advertisement -