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 |
|
shearn
Starting Member
2 Posts |
 Posted - 2004-05-04 : 09:42:58
|
| Hi, im trying to look at a misbehaving DTS package in Enterprise Manager. However when I try to go to Design Package I get the following Error:Error Source: Microsoft Data Transformation Services (DTS) PackageError Description: The system cannot find the file specifiedIm not to hot with DTS and really need to get this problem sorted, any ideas.Cheers,Simon |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-05-04 : 09:47:13
|
| Probably you service pack level on your client machine...Try applying sp3 and it should work... |
 |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2004-05-04 : 16:42:07
|
| I have a package I can't open either ......... But mine says "Invalid Class String" never seen it before.... Never had a problem with DTS before either. SQL 2K SP3 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-04 : 16:57:36
|
| Is it service pack 3/3a on the database server or on your client machine? Service packs can be applied to the client machines. In fact, in SQL 7.0 it was almost required in order to design packages. It's not as important now with SQL 2000, but you should consider installing sp3/3a on your client machine.Tara |
|
|
|
shearn
Starting Member
2 Posts |
Posted - 2004-05-05 : 09:24:17
|
| yeah i think it must be a service pack thing, the service pack level is "release to manufacturing" whatever that means, probably no service packs.ThanksSimon. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-05 : 12:39:16
|
| @@VERSION won't help you with checking the version of your SQL Client tools though unless you've also got the database server installed there too.Tara |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-05-05 : 12:48:44
|
| Whoops, didn't think about that...Although Help.. About on QA will tell you... |
|
|
|
|
|
|
cannot view dts package design