What is the tool then if i'm upgrading straight to SSIS 2008 if its not the compatibility pack for 2005. Also i'm not sure we even have a computer here that has 2005 installed to use the compatibility pack

From DTS (SQL Server 2000) you need to use BIDS 2008 to create a new SQL Services Integration project then right-click on the SSIS Packages node in Solution Explorer, and select Migrate DTS 2000 Package. See or even more links if you ever get stuck (which is possible): http://www.infosys.com/microsoft/resource-center/DTS-SSIS-2008-migration.pdf http://weblogs.sqlteam.com/derekc/archive/2008/02/19/60518.aspx http://wiki.sqlis.com/default.aspx/SQLISWiki/MigrationWizardSteps.html Video link for "how to migrate SQL Server 2000 DTS packages to SQL Server 2008" http://www.msdev.com/Directory/Description.aspx?eventId=493Arthur My Blog

Thanks so much Arthur, now i've got a new problem! haha Apparently i didn't realize someone had already ran this migration wizard on the dts package so i now have a dtsx file. within this package in the controll flow (in SSIS) i see two Execute SQL Task nodes and an Execute DTS 2000 Package Task. what can i do to see what is inside of that? or am i somewhat out of luck on this one? Below is the picture.

Ha after some research i figured it out. I downloaded the SQL Server 2000 DTS Designer Components, hit edit package and it all works! perfect

Been trying to find my answer on the forums and either i can't find the right answer or everything was about 4 years ago and not useful. I have a 2000 DTS package that i basically need to see whats going on inside of it. Within SSIS 2008 R2, all i see is an Execute DTS 2000 Package Task. This runs fine but we are wanting to create a new package that impliments multicast and a new destination. I want to be able to open up this package to make sure i'm rebuilding it correctly (even if this is just a straight pull from the destination) What i'm seeing, if i'm correct, is that in order for me to edit the package to be able to see the components, i need the backwards compatability tool, but this only takes it to 2005? then i will need to do another conversion from 2005 to 2008? Is there a tool out there that i'm not finding that can take this 2000 DTS package and convert it directly so i can edit it and see the internals in 2008 R2

Two variants here: 1) Upgrade the package. You may upgrade it to SSIS 2008 staright, so this is enough to make you see what 's inside. Or 2) Once you get the compatibility pack insatlled in 2005 you will be able to see what's inside, too. But if your goal is to convert #1 is a way to go.Arthur My Blog

also you can view your package in SSMS to view what is going on : http://msdn.microsoft.com/en-us/library/cc645945(v=sql.105).aspx and then create your SSIS version based on thathttp://www.rad.pasfu.com

also you can view your package in SSMS to view what is going on : http://msdn.microsoft.com/en-us/library/cc645945(v=sql.105).aspx and then create your SSIS version based on that http://www.rad.pasfu.com Does that show the actual package? When reading the MSDN page it just seems it shows a list of the DTS packages present on the server. Just as you see the SSIS packages in the SSIS service.MCTS, MCITP - Please mark posts as answered where appropriate.