Home > Archive > MS SQL Server DTS > October 2005 > SQL 2005









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQL 2005
Michael Tissington

2005-10-28, 8:23 pm

What has replaced DTS in SQL 2005 and how do I create a new DTS package (or
the equivalent) ?

--

Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com



Allan Mitchell

2005-10-29, 7:23 am

Hello Michael,

The new version of DTS is called Integration Services and the graphial way
to create a package is done through Business Intelligence Developer Studio
(BIDS)

Have a look here

www.SQLIS.com

or

http://blogs.conchango.com/jamiethomson/default.aspx


Allan


> What has replaced DTS in SQL 2005 and how do I create a new DTS
> package (or the equivalent) ?
>



Michael Tissington

2005-10-29, 1:25 pm

Thanks,

Can I use it to copy database objects from SQL 2000 to SQL 2005?

--

Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com


"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:d4c9a652173e28c
7aa8b5d6ce43c@msnews
.microsoft.com...
> Hello Michael,
>
> The new version of DTS is called Integration Services and the graphial way
> to create a package is done through Business Intelligence Developer Studio
> (BIDS)
>
> Have a look here
>
> www.SQLIS.com
>
> or
>
> http://blogs.conchango.com/jamiethomson/default.aspx
>
>
> Allan
>
>
>
>



Allan Mitchell

2005-10-29, 8:23 pm

Hello Michael,

Yep there is a "Transfer SQL Server Objects" task in the Workflow

Allan

[color=darkred]
> Thanks,
>
> Can I use it to copy database objects from SQL 2000 to SQL 2005?
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:d4c9a652173e28c
7aa8b5d6ce43c@msnews
.microsoft.com...
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com