migrating DTS TO SSIS

Hi ,

Getting error even remove Text (Source) task in DTS.

Pl. help me .

Thanks,

Raja

Error:

LogID=23
#Time=11:32 AM
#Level=DTSMW_LOGLEVEL_ERR
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Failed to save package file "C:\PONE_SSIS_PACKAGES\PONE_SSIS_SELLTHRU\PONE_DTS_SELLTHRU_TEST.dtsx" with error 0x80004005 "Unspecified error".
> System.Runtime.InteropServices.COMException (0xC001100E): Failed to save package file "C:\PONE_SSIS_PACKAGES\PONE_SSIS_SELLTHRU\PONE_DTS_SELLTHRU_TEST.dtsx" with error 0x80004005 "Unspecified error".

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToXML(String FileName, IDTSPersist90 pPersistObj, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
End of inner exception stack trace
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
at Microsoft.SqlServer.Dts.MigrationWizard.DTS9HelperUtility.DTS9Helper.SaveToXML(Package pkg, String sFileLocation)
at Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework.StartMigration(PackageInfo pInfo)

Hello Raja,

I cannot help you with your specific issue but I recomend that you do not use the DTS SSIS migration wizard. I have tried it several times but it ended with creating new SSIS packages from scratch...

/Erik
|||

Here are some other resources taht talk about DTS-SSIS migration:

http://www.google.com/search?hl=en&q=dts+to+ssis+migration

http://forums.microsoft.com/MSDN/Search/Search.aspx?words=DTS+migration&localechoice=9&SiteID=1&searchscope=forumscope&ForumID=80

|||

Hi Raja,

Did you get it fixed ? I have the similar issue scratching my head arround for several hrs.

Regards,

Rahim.

|||

Hi Rahim,

I started new SSIS and copy and paste to create second SSIS. It is easy way to start than DTS to SSIS migration. I don't find any DTS to SSIS conversion with out error.

Regards,

Raja

|||

we found that embedding legacy DTS packages in SSIS worked fine. Just create a new package and add an "Execute DTS 2000 Package Task". You can then load the old package in and embed it permenantly. We've had no problems running our old packages in this way Going forward we will rewrite as and when required.

Good luck.

|||

Hi Jez,

Thanks a lot for your response. I did as you suggested and it worked.

Regards,

Rahim

|||

Hi Raja,

Greetings!
Thank you for your response. Since we have many packages and some of them are big we couldn't copy and paste it.

Instead we created new SSIS package and then added the problem packages as DTS 2000 tasks.

Regards,

Rahim.