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.




Show quoteHide quote

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.

Show quoteHide quote

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 (Ptr***@yahoo.com.au) writes:
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.

In SQL Server Management Studio, connect to the SQL 2005 database then click
the drop-down arrow next to the word "Connect" just above the object explorer
and select "Integration Services". The Integration Services object will now
appear in the object browser on the same level as the database engine. Click
the + next to "Stored Packages" and then click "MSDB". You should see your
migrated package in the Summary window on the right.

I've tried to use Business Intelligence Studio to re-create our DTS packages
with disappointing results. We have a DTS that copies data between sql server
and mysql. I got it to work inside Business Intelligence Studio but when I
scheduled it as a job I got errors when it tried to connect to MySQL. We are
using 64-bit sql, which seemed to be the source of the problem (mysql drivers
are 32-bit). It was frustrating to be able to get it working in Business
Intelligence Studio but not as a scheduled job.

Another DTS moves data from one sql 2005 database to another on the same
machine -- I was getting truncation errors moving data from a "float" column
in the source table to a "float" column in the destination table. Eventually
I changed the sql that gets the data from "select MyCol" to "select
cast(MyCol as float) as MyCol" and the problem went away. Also, the Business
Intelligence Studio has given me a lot of nasty error messages and has
completely crashed several times.

Rich Wood

Show quoteHide quote

Error with Logins into SQL 2K
timeout trouble in SQL Server 2005 (reposted)
SQL Database Backup on Network drive gives error
Grant Read only access to ALL databases
System Proces issues "RESOURCE MONITOR" command and blocks a proce
Turn off logging for JDBC insert statements
Rebuild SQL 2000 indexes on-line
changing servers dynamically via TSQL
can connect using sql query analyzer but not osql or isql
SQL Mail Outlook Hangs