473,320 Members | 1,857 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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).

Mar 28 '06 #1
5 3076
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
4
by: Bon | last post by:
Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to...
2
by: lcifers | last post by:
First off, sorry if my cross posting offends anyone. I'm posting this in Access and SQL Server groups - not sure which one is appropriate. I have a relatively simple ASP.NET/VB.NET application...
11
by: Rob R. Ainscough | last post by:
Trying to get more info on this, anyone?? http://msdn.microsoft.com/vstudio/support/servicing/sp1_vs05/default.aspx Has anyone seen "a more detailed schedule of external interim...
5
by: herman404 | last post by:
Hi everyone, I have some code that we need to migrate to SQL Server 2005 from 2000, and I have a webpage that upon viewing, fires a query to the SQL server using ISS and ISAPI. The result set is...
1
by: bob.ward | last post by:
I attempted to upgrade to SQL Server 2000 from SQL Server 6.5 using the SQL Server Upgrade Wizard and I immediately received the following error message: An unknown error occurred while trying...
1
by: bob66k88 | last post by:
What is the easiest way to move SQL Server 2005 databases from one old server to a new server?
4
by: dsdevonsomer | last post by:
Hello, I have one simple query joining two tables with left outer join on 3 fields and using MIN on two fields. These two tables have lot of data about 3 mil in total. I am trying to migrate db...
0
by: cathy25 | last post by:
Hi, we are planning on migrating our sql from version 2000 to 2005 (I know SQL 2005 is in market from a while). As a part of testing, i have installed sql server 2005 on my development box and able...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.