DTS to SSIS migartion - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

DTS to SSIS migartion

Author

Topic

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2009-02-02 : 05:42:16

Hi All,
I tried doing migarting DTS package to SSIS.

I am unable to view my package .

In process i followed following steps...

Selected my required DTS package from 2000 server packaging list
Clicekd on MIgrate ---> Selected my source sevever name as one of my 2005 server name.

And i found no exceptions or errors while migartion..

After doing all my steps i tried finding out my Migrated Package..i uanble to get this..

Did i missed some steps in my process..

Please help me...

Thanks,
ServerTeam

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-02 : 08:53:21

connect to integration services in your server from sql mgmnt studio. go to stored packages->MSDB and check if your package is listed there.