How do I run a DTS package in VS 2005

22 Feb 2007 4:40 PM

Gordon

Hi;

I am trying to convert a program written in VS 2003 which runs a DTS package.

VS 2005 won't let me compile the program it doesn't recognize the DTS object.

Is there a way to run the package under 2005 ?

Thanks,

Gordon

22 Feb 2007 5:34 PM

Jerry H.

You can look into this:

http://www.sqldev.net/dts/DotNETCookBook.htm

Describes exactly what you need....

On Feb 22, 11:40 am, Gordon <Gor***@discussions.microsoft.com> wrote:
Show quote

> Hi;
>
> I am trying to convert a program written in VS 2003 which runs a DTS package.
>
> VS 2005 won't let me compile the program it doesn't recognize the DTS object.
>
> Is there a way to run the package under 2005 ?
>
> Thanks,
>
> Gordon

23 Feb 2007 12:38 AM

Cowboy (Gregory A. Beamer)

Rewrite the DTS package as an Integration Services package or move the
package out of the app and call form the 1.x app through a service endpoint
(web services or Remoting?)

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************

Show quote

"Gordon" <Gor***@discussions.microsoft.com> wrote in message
news:3D6E1C58-B17E-46AA-BEC6-9AC624B77519@microsoft.com...
> Hi;
>
> I am trying to convert a program written in VS 2003 which runs a DTS
> package.
>
> VS 2005 won't let me compile the program it doesn't recognize the DTS
> object.
>
> Is there a way to run the package under 2005 ?
>
> Thanks,
>
> Gordon