|
Home > Archive > Microsoft SQL Server forum > March 2006 > SQL Server 2005: Migrate DTS to Where?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2005: Migrate DTS to Where?
|
|
| Peter Nurse 2006-03-28, 3:27 am |
| 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).
| |
| Uri Dimant 2006-03-28, 3:27 am |
| 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).
>
| |
| Peter Nurse 2006-03-28, 3:27 am |
| 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.
| |
| Otarius 2006-03-28, 9:29 am |
| 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).
>
| |
| Peter Nurse 2006-03-28, 8:26 pm |
| Thanks for that. I never would have found it on my own!
Now why would I want to use SSIS rather than DTS?
| |
| Erland Sommarskog 2006-03-28, 8:26 pm |
| 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
|
|
|
|
|