SQL Server 2005: Migrate DTS to Where?

I have right clicked on my DTS package and selected Migrate... I
assumed this is a good idea for future upgradeability (?)  The process
worked without error but I have no idea where the resulting migrated
package can be found.  The DTS package itself (apparently) remains
unchanged.

If your answer is that an SSIS package has been created, please tell me
exactly where I can find it.

I've looked at SQL Server Business Intelligence Studio (where do they
get these names from?) and have not been able to find SSIS (or anything
else useful, actually).

Hi
I personally have not palyed with it yet but I think it should be under
Legacy folder in SSMS.




"Peter Nurse" <PtrNrs@yahoo.com.au> wrote in message
news:1143530551.757760.132510@i39g2000cwa.googlegroups.com...
>I have right clicked on my DTS package and selected Migrate... I
> assumed this is a good idea for future upgradeability (?)  The process
> worked without error but I have no idea where the resulting migrated
> package can be found.  The DTS package itself (apparently) remains
> unchanged.
>
> If your answer is that an SSIS package has been created, please tell me
> exactly where I can find it.
>
> I've looked at SQL Server Business Intelligence Studio (where do they
> get these names from?) and have not been able to find SSIS (or anything
> else useful, actually).
>

SSMS? Another acronym I need to learn.  The DTS package was already in
the  Management\Legacy\Da
ta Transformation Services folder of SQL Server
Management Studio (I take it this is SSMS).

No, I'm sure it hasn't ended up there.

DTS package migrated to 2005 Integration Services package can be found:
Integration Services/Stored Packages/MSDB.
To open it with Business Intelligence Development Studio, create IS project
and add SSIS package from the SQL server.

"Peter Nurse" <PtrNrs@yahoo.com.au> wrote in message
news:1143530551.757760.132510@i39g2000cwa.googlegroups.com...
>I have right clicked on my DTS package and selected Migrate... I
> assumed this is a good idea for future upgradeability (?)  The process
> worked without error but I have no idea where the resulting migrated
> package can be found.  The DTS package itself (apparently) remains
> unchanged.
>
> If your answer is that an SSIS package has been created, please tell me
> exactly where I can find it.
>
> I've looked at SQL Server Business Intelligence Studio (where do they
> get these names from?) and have not been able to find SSIS (or anything
> else useful, actually).
>

Thanks for that.  I never would have found it on my own!

Now why would I want to use SSIS rather than DTS?

Peter Nurse (PtrNrs@yahoo.com.au)  writes:
> Now why would I want to use SSIS rather than DTS?

Because SQL 2005 is new, better, faster more beautiful and all that?

To wit, the component that in SQL 2000 was known as DTS, has change
names in SQL 2005, and is now known as SQL Server Integration Services.
As I understand, it there are huge differences, as it it is a redesign
from bottom up. I would not be able to tell the difference myself,
because I've worked with neither.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx