set up schedule for legacy DTS created in SQL2005 but running on a SQL2000 server
Hi
I've got an issue with a DTS that has been edited in SQL Server Mgt Studio 9 (2005) where I can no longer set up a job either in SQL 2005 or SQL 2000
The option to set up a job in 2005 is not there (guess it would now be SSIS?) but I thought I should still be able to revert to the SQL 2000 database where the DTS and tables actually reside to schedue the job
If I open SQL Server Enterprise Manager and right click on the DTS there to create a job I just get a box pop up : Package Error : Unspecified Error
Any ideas or tips would be great as I dont want to manually run the DTS each day!
Thanks
Neil
I've got an issue with a DTS that has been edited in SQL Server Mgt Studio 9 (2005) where I can no longer set up a job either in SQL 2005 or SQL 2000
The option to set up a job in 2005 is not there (guess it would now be SSIS?) but I thought I should still be able to revert to the SQL 2000 database where the DTS and tables actually reside to schedue the job
If I open SQL Server Enterprise Manager and right click on the DTS there to create a job I just get a box pop up : Package Error : Unspecified Error
Any ideas or tips would be great as I dont want to manually run the DTS each day!
Thanks
Neil
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
do you have "stardds.dll"?
ASKER
where should i look for that please ?
as I posted: maybe you'll have to copy stardds.dll to C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn
ASKER
That is already there
Even using dtexecui from the command line I get this after selecting the DTS
TITLE: SSIS Execution Properties
--------------------------
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.
--------------------------
ADDITIONAL INFORMATION:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.
Even using dtexecui from the command line I get this after selecting the DTS
TITLE: SSIS Execution Properties
--------------------------
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.
--------------------------
ADDITIONAL INFORMATION:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.
Sorry, I don't know this error. Do you have Problems with only one dts?
ASKER
yes, although it works fine if you run it manually from the DTS designer itself, you simply just cant schedule it.
ASKER
-Install SQL Server Management Studio 2005
-Install the appropriate SQLServer2005_BC*.msi from here
-Install SQLServer2005_DTS.msi (same location)
I also copied the dlls as I had not done that but its made no difference unfortunately.