DTS from .NET (C#)?

I have a C# app that loads and runs a DTS package. It works great on my dev system but when I move it to the production system (which has SQL Server 2000 installed) it doesn't work. As soon as my app runs, it throws the exception:

"File or assembly name Interop.DTS, or one of its dependencies, was not found."

I've manually done: "regsvr32 dtspkg.dll" which succeeds but doesn't fix the problem.

Any ideas?Nevermind, I figured it out. DTS is a COM object and .NET generates a glue DLL: "Interop.DTS.dll".

I just needed to copy this DLL as well as my .exe

cool...|||Yeah!

DTS

Can you script a DTS package?
Or is there another way to copy a DTS package from one server to another (i.e. from testing to production)?
Please let me know ideas.
Thanks!
Yes. When you click Save As, change the location from SQL Server to either
of the other two options... Then you can save it as a file and copy it
wherever you want. To open the file, right-click on Data Transformation
Services in EM and click Open Package...
"Ysandre" <ysandre@.hotmail.com> wrote in message
news:C4B4662C-C87E-409B-85D3-20732A0ADB85@.microsoft.com...
> Can you script a DTS package?
> Or is there another way to copy a DTS package from one server to another
(i.e. from testing to production)?
> Please let me know ideas.
> Thanks!
|||On Fri, 14 May 2004 09:46:01 -0700, Ysandre wrote:

> Can you script a DTS package?
> Or is there another way to copy a DTS package from one server to another (i.e. from testing to production)?
> Please let me know ideas.
Just save it as a file and then import it to the production server.
Morten Isaksen
http://www.aub.dk/~misak/
|||Thanks! That's exactly what I was looking for.
I figured out the save as structured file part, but couldn't find the instructions on what to do with it after that!
Thanks again!
Have a great weekend.

DTS

Can you script a DTS package
Or is there another way to copy a DTS package from one server to another (i.e. from testing to production)
Please let me know ideas
Thanks!Yes. When you click Save As, change the location from SQL Server to either
of the other two options... Then you can save it as a file and copy it
wherever you want. To open the file, right-click on Data Transformation
Services in EM and click Open Package...
"Ysandre" <ysandre@.hotmail.com> wrote in message
news:C4B4662C-C87E-409B-85D3-20732A0ADB85@.microsoft.com...
> Can you script a DTS package?
> Or is there another way to copy a DTS package from one server to another
(i.e. from testing to production)?
> Please let me know ideas.
> Thanks!|||On Fri, 14 May 2004 09:46:01 -0700, Ysandre wrote:
> Can you script a DTS package?
> Or is there another way to copy a DTS package from one server to another (i.e. from testing to production)?
> Please let me know ideas.
Just save it as a file and then import it to the production server.
--
Morten Isaksen
http://www.aub.dk/~misak/|||Thanks! That's exactly what I was looking for
I figured out the save as structured file part, but couldn't find the instructions on what to do with it after that
Thanks again
Have a great weekend.

DTS

I am transfering data from a production server to a test
sever. I started a transfer with the DTS wizard then I
realized that I had the name spelled wrong in the to part
so I removed that db from the drop down list. Now when I
try to do another transfer I get the following error
message.
Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
it alredy exists.
When I check the test server this file does exist.
What do I need to do to get my transfer to go?
Can I just delete the above mentioned file?
What is the purpose of the data folder?What are you talking about?
I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
Whats the to part?
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
Then dont try to re-create it.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
Of course you can. But keep in mind this is a db file. It
sounds though as you just created it so it's probably
empty. Drop the db from Enterprise Manager.
Why are you exporting to a file anyways?
>--Original Message--
>I am transfering data from a production server to a test
>sever. I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
>so I removed that db from the drop down list. Now when I
>try to do another transfer I get the following error
>message.
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
>.
>|||The to part that I was refering to is on the Chose Destination page of the DTS wizard in the database drop down list. In that list it has a new option. After selecting that I typed in the name of the database that I want to create with the data transfer. I am not trying to create the file that gives me the error I assume that this is something that is created by the DTS.

DTS

Can you script a DTS package?
Or is there another way to copy a DTS package from one server to another (i.
e. from testing to production)?
Please let me know ideas.
Thanks!Yes. When you click Save As, change the location from SQL Server to either
of the other two options... Then you can save it as a file and copy it
wherever you want. To open the file, right-click on Data Transformation
Services in EM and click Open Package...
"Ysandre" <ysandre@.hotmail.com> wrote in message
news:C4B4662C-C87E-409B-85D3-20732A0ADB85@.microsoft.com...
> Can you script a DTS package?
> Or is there another way to copy a DTS package from one server to another
(i.e. from testing to production)?
> Please let me know ideas.
> Thanks!|||On Fri, 14 May 2004 09:46:01 -0700, Ysandre wrote:

> Can you script a DTS package?
> Or is there another way to copy a DTS package from one server to another (
i.e. from testing to production)?
> Please let me know ideas.
Just save it as a file and then import it to the production server.
Morten Isaksen
http://www.aub.dk/~misak/|||Thanks! That's exactly what I was looking for.
I figured out the save as structured file part, but couldn't find the instru
ctions on what to do with it after that!
Thanks again!
Have a great weekend.