By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

SQL Server 2005: Migrate DTS to Where?

P: n/a
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).

Mar 28 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Hi
I personally have not palyed with it yet but I think it should be under
Legacy folder in SSMS.


"Peter Nurse" <Pt****@yahoo.com.au> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.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).

Mar 28 '06 #2

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

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

Mar 28 '06 #3

P: n/a
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" <Pt****@yahoo.com.au> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.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).

Mar 28 '06 #4

P: n/a
Thanks for that. I never would have found it on my own!

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

Mar 28 '06 #5

P: n/a
Peter Nurse (Pt****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 28 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.