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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-24 : 10:45:18
|
| Greg writes "I wrote a DTS package in SQL 2000 and when I try to open it in SQL 7.0 I get the error message "Invalid Class String". I have researched this on the interent and believe that I am getting this error because I am using tasks that were not available in release 7, namely a Dynamic Properties Task. I have found a fair amount of info on this problem but no solution. We have one server that is 7.0, the rest are 2000. All of the client machines are 2000. I can run this DTS on my machine OK (2000) but need to schedule it to run on the server (7.0). Any thoughts?thanks in advance,greg" |
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2002-04-24 : 11:01:27
|
| Greg!Yeah, your problems are related to the differences in DTS versions as well as the new "tasks" you are using. I have been successful in creating packages on SQL 2000 and moved them to SQL 7 but only when they don't use anything new that was introduced in SQL 2000. There are caveats to this though as the file formats are different between SQL7 and SQL2000.You can save a DTS package created on SQL 2000 to a server with SQL 7 and work on it through Enterprise Manager 2000 as long as you either have Service Pack 3 for SQL 7 installed or you assign passwords to the package when moving it to SQL 7. This apparently uses the same file format.I think I've rambled, but hopefully I've aided you somewhat. Good luck.Kyle HeonPixelMEDIA, Inc.Programmer L2kheon@pixelmedia.com |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-24 : 16:03:56
|
| It is very tough to get a SQL 2000 DTS package to open in SQL7. Lots of things have changed and the file formats are very different. It may be easier to just recreate the package from scratch on the SQL7 box using the SQL7 tools.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
DTS