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?


--
Jerry J

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

--
Jerry J


"Jerry J" wrote:

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


Jerry J wrote: