migration from dts 2000to ssis 2005 package: which package migrate instead of creating in ssis - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » migration from dts 2000to ssis 2005 package: which package migrate instead of creating in ssis

migration from dts 2000to ssis 2005 package: which package migrate instead of creating in ssis

Options

Previous Topic · Next Topic

dibyant

Posted: Friday, January 25, 2008 5:12:51 PM

Rank: Newbie

Joined: 1/21/2008
Posts: 9
Points: -73
Location: usa

dear sir Scott,
i would like yo know answer of this question " i want to migrate the DTS Package 2000 to SSIS 2005"
i know the how to do migration what to do what kind of problems might occurs.
i have already videos and i have seen all of them.
But the question that is very crucial and considerable "how we will know which package is better to migrate.
which package is better to create in the SSIS 2005 instead of migrating from dts 2000"
Is there any way any clue any key by which we can understand and implement ?
Please,let me know because wherever you have lots of dts packages how you will know which package is
better to create in ssis 2005 than migrate from dts 2000.
Is there any concept with the various tasks which are available in dts 2000 but not in ssis 2005?
where we should create the package instead of migrating from the dts 2000.

please let me know a better way to deal with this.
Because i am facing the same kind of problem its urgent please let me know ASAP

thank you Sir(Scott)

dibyant upadhyay

Scott Whigham

Posted: Monday, January 28, 2008 11:41:06 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

hi dibyant -

There is one and only one way to know for sure - try it, see if it works, learn what works and what doesn't, and then do whatever you have to do. I don't know of anything else I can expound on; DTS to SSIS mapping is tough and, the more you know about what doesn't work, the better position you are in to gauge what will work. Nothing can teach you "what works/fails" better than try/fail/succeed IMO.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.