sql server dts: DTS Newbie: How to run the DTS package in production -- sql server dts

DTS Newbie: How to run the DTS package in production

Jerry J
10/11/2006 3:13:01 PM

sql server dts:

I created a working DTS package. It imports data from an Access mdb to a SQL
Server database. The package runs perfectly in the developer studio. What I
would like to know is how I use it in a production environment? Do I call it
from a .net application perhaps? I can't seem to find any information on
this.

Can someone point me in the right direction?

--

RE: DTS Newbie: How to run the DTS package in production

Jerry J
10/11/2006 4:42:01 PM

I know, I can use .net 2005 with C#. I guess I know now.

--
Jerry J

[quoted text, click to view]

Re: DTS Newbie: How to run the DTS package in production

Jay
10/12/2006 3:04:23 PM

Are you using sql server 2000 or 2005? It's not necessary to use an
external application to run packages. It sounds like your using sql
2005 in which case you're referring to an SSIS package?

My first experience with this I had the same question. In the object
explorer of the developer studio click on connect then select
Integration Services. Type in the server name and you can import your
ssis projects from there. I think this is what you were asking, but no
entirely sure.

Jay

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.