I made data transformation changes to a series of DTS packages, saved them, now I am getting an Invalid Class String error when trying to call it from an SP using xp_cmdshell 'DTSrun xxxxx' or right from the command line DTSrun from a DOS window. Here is the text:

Error: -2147221005 (800401F3); Provider Error: 0 (0)
   Error string: Invalid class string

   Error source: Microsoft Data Transformation Services (DTS) Package
   Help file: sqldts.hlp
   Help context: 713


I don't know if the changes I made contributed to the problem, just sharing that tidbit to see if they might be related. Earlier today, everything fired off OK. Anybody know what would have all of a sudden caused this error? What's it related to? Could the registry have corrupted CLSIDs?

TIA,

Steve

Yes, the problem was the datetime transformation to short date format. Anybody know why that would happen?