Tools resources for Integration Services?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

thejamie - 30 Jul 2007 14:38 GMT

DTS packages on 2000 need to be migrated to 2005. Looking for an easy
migration. What are some of the resources and tools available? We have
about 30 packages so the $25 per package is not an option. More interested
in a simple tutuorial - something along these lines.

Saw this one already

https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=75227

and it presents possibilities, but eLearning does not generally provide
practical examples, only theory, so it would be nice to see a sample
migration package with pictures, etc.

Signature

Regards,
Jamie

Reply to this Message

Russell Fields - 30 Jul 2007 15:49 GMT

Jamie,

Do you realize that the easiest migration is to continute running your DTS
packages just as they are? Install the Backward Compatibility Package and
the DTS Package Designer and you can continue to run the 2000 DTS packages
until you get the time to migrate them youself as the need arises.

RLF

> DTS packages on 2000 need to be migrated to 2005. Looking for an easy
> migration. What are some of the resources and tools available? We have
[quoted text clipped - 9 lines]
> practical examples, only theory, so it would be nice to see a sample
> migration package with pictures, etc.

Reply to this Message

thejamie - 30 Jul 2007 18:58 GMT

Russell,

Thanks for replying. I am confused by your message. From what you write, I
am assuming that these two items are add-ins for SQL Server 2005 - Backward
Compatibility Package and the DTS Package Designer?

What we have done so far is to export the DTS packages to a SQL Server 2005
test server running integration services so that we can open them with the
SSIS tool in Visual Studio. If I make it out right, you are saying that the
DTS will continue to run as it. Is there a resource for how to using the
Backup Compatibility Package?

Signature

Regards,
Jamie

> Jamie,
>
[quoted text clipped - 18 lines]
> > practical examples, only theory, so it would be nice to see a sample
> > migration package with pictures, etc.

Reply to this Message

Russell Fields - 30 Jul 2007 20:03 GMT

Jamie,

Yes, you can read a brief description at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91
-9e8b9d835cdc&displaylang=en

These are Microsoft add-ins for SQL Server 2005. Basically, they distribute
the SQL Server 2000 bits that allow the DTS functions to continue to work
for you.

Download "Microsoft SQL Server 2000 DTS Designer Components" for designing
DTS packages (editing existing packages, but not creating new ones.) Then,
to run the DTS packages you also need to download "Microsoft SQL Server 2005
Backward Compatibility Components".

I am not trying to discourage you from migrating to SSIS, but this allows
you to continue running existing DTS packages under SQL Server 2005. If you
continue to run your existing DTS packages, you can can then choose to
upgrade them one at a time, without any artificial time pressure.

RLF

> Russell,
>
[quoted text clipped - 38 lines]
>> > practical examples, only theory, so it would be nice to see a sample
>> > migration package with pictures, etc.

Reply to this Message

Uri Dimant - 31 Jul 2007 07:37 GMT

Hi
http://www.jumpstarttv.com/Media.aspx?vid=47

Reply to this Message

thejamie - 31 Jul 2007 14:14 GMT

This video does not show on the network here. Is there a registration? Or
do we just have it blocked here? I can't tell from my vantage point.

Signature

Regards,
Jamie

> Hi
> http://www.jumpstarttv.com/Media.aspx?vid=47
[quoted text clipped - 12 lines]
> > practical examples, only theory, so it would be nice to see a sample
> > migration package with pictures, etc.

Reply to this Message

Russell Fields - 31 Jul 2007 16:54 GMT

Jamie,

I can get to it.

RLF

> This video does not show on the network here. Is there a registration?
> Or
[quoted text clipped - 17 lines]
>> > practical examples, only theory, so it would be nice to see a sample
>> > migration package with pictures, etc.

Reply to this Message