SQL server 2000 - 2005 DTS

  • Hi ,

    We migrated a server from SQL server 2000 - 2005 , along with DTS packages but one DTS package did not work, tried solutions provided in http://support.microsoft.com/kb/917406 , but everything failed . Does anyone have other solutions leaving this behind . Your valuable comments appreciable

  • I am unable to change the protection level in DTS package which is migrated from SQL server 2000 and save it

  • Can you tell us which of the error messages you got? If you got the one referring to DTS Designer components, did you install them?

    Greg

  • Yes , I installed the DTS components , i was able to open the package but failing to change Protection level to "Reply server on ........." option

  • I'm not familiar with Protection Level as it relates to DTS packages. I've only used it with SSIS packages.

    Greg

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply