DTS Packages in SQL 2005 - what are they now, etc

OK - so it looks like DTS Packages are "legacy". I installed the component to be able to edit and run them from SQL 2005 Management console and that seems to work fine. (I haven't acually run my packages yet, but at least I can open and edit the dang things). And I also migrated the existing ones from the networked server on which they lived (which is still running SQL 2000) to my local server (which is the one on 2005).

So assuming I want to do the new methodology - what IS the new methodology?

Where are the migrated packages? I looked at all of the links in the SQL Management Console for anything that references these newly migrate packages, and I don't see them - or anything that looks like them - anywhere.

What do I run them in - from what, how, etc? This really isn't clear at all.OK - so I think I have this figured out. You have to connect to Integration Services for a specific server. If you do that, they are then in the Stored Packages. So I'll post back if I have any problems when I actually get up the courage to try and run these puppies...|||That's correct. If you used the destination as a server, you have to connect to Integration Services and then see the packages under MSDB in stored packages. Alternatively, you can choose "DTSX File" as the destination for your migrated packages, and then save your packages as .dtsx files in your chosen folder. You can then add these packages to an SSIS Project and view/edit them in BI Studio.|||Hi.
Yeah, they are unregular XML-files, I guess. Not to be edited.

Try to enable and start the "DTS Server" service, then run
cmd
dtexec.exe /?

They can also be scheduled from within managment studio and run from bi studio.

DTS packages in SQL 2005

I see them show up under a node called Legacy in Management Studio. What is
the plan for migration of DTS packages from 2000 to 2005? We have lots of
these that we'll need to migrate that are in use with various SQL jobs.
Thanks,
Johnthere is a migration wizard to help you.
but you'll have a lot of manual job to do to really convert DTS to SSIS. (to
make sure that the upgrade is correct and to use the new features)
but you can continue to execute your DTS packages in 2005.
"John Holmes" <johnsh@.co.skagit.wa.us> wrote in message
news:efrhJH5IGHA.140@.TK2MSFTNGP12.phx.gbl...
>I see them show up under a node called Legacy in Management Studio. What is
>the plan for migration of DTS packages from 2000 to 2005? We have lots of
>these that we'll need to migrate that are in use with various SQL jobs.
> Thanks,
> John
>|||Have you found any documentation about what kind of code or task need manual
job to be migrated? Or should I learn it on the field, one by one'
"Jéjé" wrote:

> there is a migration wizard to help you.
> but you'll have a lot of manual job to do to really convert DTS to SSIS. (
to
> make sure that the upgrade is correct and to use the new features)
> but you can continue to execute your DTS packages in 2005.
> "John Holmes" <johnsh@.co.skagit.wa.us> wrote in message
> news:efrhJH5IGHA.140@.TK2MSFTNGP12.phx.gbl...
>
>

DTS packages in SQL 2005

I see them show up under a node called Legacy in Management Studio. What is
the plan for migration of DTS packages from 2000 to 2005? We have lots of
these that we'll need to migrate that are in use with various SQL jobs.
Thanks,
John
there is a migration wizard to help you.
but you'll have a lot of manual job to do to really convert DTS to SSIS. (to
make sure that the upgrade is correct and to use the new features)
but you can continue to execute your DTS packages in 2005.
"John Holmes" <johnsh@.co.skagit.wa.us> wrote in message
news:efrhJH5IGHA.140@.TK2MSFTNGP12.phx.gbl...
>I see them show up under a node called Legacy in Management Studio. What is
>the plan for migration of DTS packages from 2000 to 2005? We have lots of
>these that we'll need to migrate that are in use with various SQL jobs.
> Thanks,
> John
>
|||Have you found any documentation about what kind of code or task need manual
job to be migrated? Or should I learn it on the field, one by one?
"Jéjé" wrote:

> there is a migration wizard to help you.
> but you'll have a lot of manual job to do to really convert DTS to SSIS. (to
> make sure that the upgrade is correct and to use the new features)
> but you can continue to execute your DTS packages in 2005.
> "John Holmes" <johnsh@.co.skagit.wa.us> wrote in message
> news:efrhJH5IGHA.140@.TK2MSFTNGP12.phx.gbl...
>
>

DTS packages in SQL 2005

I see them show up under a node called Legacy in Management Studio. What is
the plan for migration of DTS packages from 2000 to 2005? We have lots of
these that we'll need to migrate that are in use with various SQL jobs.
Thanks,
Johnthere is a migration wizard to help you.
but you'll have a lot of manual job to do to really convert DTS to SSIS. (to
make sure that the upgrade is correct and to use the new features)
but you can continue to execute your DTS packages in 2005.
"John Holmes" <johnsh@.co.skagit.wa.us> wrote in message
news:efrhJH5IGHA.140@.TK2MSFTNGP12.phx.gbl...
>I see them show up under a node called Legacy in Management Studio. What is
>the plan for migration of DTS packages from 2000 to 2005? We have lots of
>these that we'll need to migrate that are in use with various SQL jobs.
> Thanks,
> John
>|||Have you found any documentation about what kind of code or task need manual
job to be migrated? Or should I learn it on the field, one by one'
"Jéjé" wrote:
> there is a migration wizard to help you.
> but you'll have a lot of manual job to do to really convert DTS to SSIS. (to
> make sure that the upgrade is correct and to use the new features)
> but you can continue to execute your DTS packages in 2005.
> "John Holmes" <johnsh@.co.skagit.wa.us> wrote in message
> news:efrhJH5IGHA.140@.TK2MSFTNGP12.phx.gbl...
> >I see them show up under a node called Legacy in Management Studio. What is
> >the plan for migration of DTS packages from 2000 to 2005? We have lots of
> >these that we'll need to migrate that are in use with various SQL jobs.
> >
> > Thanks,
> >
> > John
> >
>
>

DTS only copies first row

Hi,

I'm trying to copy results from a view on one table to another table in a different db using DTS in SQL Server Management Studio

Both source and destination db's are version 8.0.194

Everything reports as working, but when I check the results, only one row has copied - DTS reports that 1167 rows were copied.

This happens to different sources and destinations so I doubt it's my query.

When I perfrom the same DTS task using the old enterprise manager DTS in SQL Server 2000, everything copies fine.

Obviously one answer is "Use SQL Server 2000 Enterprise Manager then. " but I'd rather upgrade to 2005 and Management Studio permanently.

Any ideas?

I don't know what the problem may be but you need to identify exactly where the problem is occurring. My first avenue of investigation would be to put a data viewer immediately prior to your destiantion to see how many rows are flowing into it. Check that the number displayed in teh GUI is correct.

-Jamie

DTS migration wizard, where does it put migrated version?

From SQL Server Management Studio I right click on Management/Legacy/DTS and select Migration Wizard and enter a SQL Server Source and Destination. A list of DTS packages from the source server is displayed and I select one of the DTS packages and give the destination a unique name. The wizard runs and says it's successful. I can't find the new SSIS version of the DTS package with the new name that I've given it, however. Where does it put the new migrated copy of the DTS package.

Thanks,

John

In Sql Management Studio, under the Object Explorer window in the Connect drop down choose Integration Services, and it will show you all stored packages on that instance.|||Thanks, this helps. Now I'd like to find out how to edit the migrated version. How to I get to it from BI Dev Studio?|||

All of the stored packages will usually be in ~\Program Files\Microsoft SQL Server\90\DTS\Packages

DTS in SQL 2005 Standard

I'm using SQL 2005 Standard Edition with the Management Studio Console CTP but I can't seem access DTS functions. Is DTS available in this edition of SQL?

I just got through the same issue. I upgraded from 2000 to 2005 and could no longer find DTS. It is now SSIS in 2005. I can point you in the right direction but thats it. I am still figuring it out in the new edition.

-M

|||

here was my thread

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=349970&SiteID=1