Opening DTS in SQL 2005: Invalid Class String
We have a series of dts packages sitting on SQL 2005 box. They were working fine for a long time but all of a sudden stopped working. When we try to troubleshoot it (open it via management studios), it's throwing an "invalid class string" error. Searching the web return some old articles and have failed to provide us with a solution. Is anyone else having this issue? Please help.~ DogTog ~
November 23rd, 2010 3:54pm

do you mean SSIS package or DTS packages. DTS was a SQL Server 2000 thing. Anything from 2005 onwards is SSIS package. Lets assume you have SSIS packages (they have .dtsx extensions) the only way to open it is using Visual Studio 2005 with BIDS(Business Intelligence development Studio ). SSIS packages dont open by SQL management studio. If you are talking about DTS packages built using data transformation services shipped with SQL 2000 then go here http://www.databasejournal.com/article.php/1503191 and scroll down to SQL Server 2000 DTSAshwani Roy Blog Twitter Please click the Mark as Answer button if a post solves your problem!
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 4:07pm

do you mean SSIS package or DTS packages. DTS was a SQL Server 2000 thing. Anything from 2005 onwards is SSIS package. Lets assume you have SSIS packages (they have .dtsx extensions) the only way to open it is using Visual Studio 2005 with BIDS(Business Intelligence development Studio ). SSIS packages dont open by SQL management studio. If you are talking about DTS packages built using data transformation services shipped with SQL 2000 then go here http://www.databasejournal.com/article.php/1503191 and scroll down to SQL Server 2000 DTS Ashwani Roy Blog Twitter Please click the Mark as Answer button if a post solves your problem! Thanks for your reply. But you can use SQL 2000 dts on SQL 2005 box. Have you seen that error before... our search netted some results that were completely unrelated SQL server. Looks like it's some generic error MS uses. ~ DogTog ~
November 23rd, 2010 4:18pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics