DTS Packages in 2005? 1

[Yerdon]

Hi Everyone,

I imported a SQL2000 DTS job into SQL2005 (it is located in "Management -> Legacy -> Data Transformation Services". I can run it manually, but I want to schedule it, so I migrated it to SQL 2005 (through the right-click menu option) and now I can't find it!

Where is it located?

Thanks!

Joseph

 

[mrdenny]

SQL 2005 doesn't have DTS. It uses SSIS instead.

Create a new job, add a step and tell is the type is SQL Integration Package.

The package will be stored in the SQL Server. You should be able to then browse to the package.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Yerdon]

Thanks! That helps.

How do I edit these SSIS packages?

I can browse to it like you said, but it fails and I need to go into the actual job and check it out.

Thanks!

Joseph

 

[mrdenny]

Once an SSIS package is deployed to the enviroment you have to export the package then edit the package, then you can reimport the package.

You'll need to connect to the Integration Service to access the packages. You can connect to it in the SQL Server Managment Studio.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com