SQL DTS Package

[Jim Heavey]

I am wanting to execute a SQL DTS package from a C# program. I found an
article which tells you how to do this
(http://www.sqldev.net/dts/ExecutePac...sual%20Csharp).

One of the first thing it tells you is to create a reference to
"dtspkg.dll". This DLL is on the server where SQL Server is located. It
does not appear to be loaded on my local machine when I load SQL Express. I
have no direct connectivity to that drive, so I logged on to the server,
found the dll and made a copy of it an placed it on my local machine. But
when I attempt to create a reference to the dll, I get and error message box
telling me that it can not create a reference (not a valid com component).

So apparently I can not just move the dll to someplace where I can get to it
and create the reference. So how do I create a reference to this dll?

[kevin]

That link is referring to SQL 2K and no you can't simply copy a dll and
reference it. COM components were registered. You could try registering it
with, but I would suspect that it is looking for other dlls that are located
in the original folder.

You will only need the sql client tools on your machine.
--
kevin...
"Jim Heavey" wrote:

I am wanting to execute a SQL DTS package from a C# program. I found an
article which tells you how to do this
(http://www.sqldev.net/dts/ExecutePac...sual%20Csharp).

One of the first thing it tells you is to create a reference to
"dtspkg.dll". This DLL is on the server where SQL Server is located. It
does not appear to be loaded on my local machine when I load SQL Express. I
have no direct connectivity to that drive, so I logged on to the server,
found the dll and made a copy of it an placed it on my local machine. But
when I attempt to create a reference to the dll, I get and error message box
telling me that it can not create a reference (not a valid com component).

So apparently I can not just move the dll to someplace where I can get to it
and create the reference. So how do I create a reference to this dll?