Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to execute a DTS script

 
   Database Forums (Home) -> DTS RSS
Next:  migrate server to another machine  
Author Message
bnhcomputing

External


Since: Oct 01, 2004
Posts: 6



(Msg. 1) Posted: Mon Oct 03, 2005 9:06 pm
Post subject: How to execute a DTS script
Archived from groups: microsoft>public>sqlserver>dts (more info?)

I have a completed DTS package in my SQL server.

The examples talk about creating and executing a DTS from VB, but no
connection information is ever provided. I just want to execute the
already existing package, not create another.

I would REALLY like to execute the package, that’s already in my SQL
server, from an ASP. Does anyone have an example / documentation on
how to simply execute an already existing DTS from VB or an ASP?


--
bnhcomputing

 >> Stay informed about: How to execute a DTS script 
Back to top
Login to vote
Dave172

External


Since: Aug 26, 2004
Posts: 22



(Msg. 2) Posted: Wed Oct 05, 2005 7:16 am
Post subject: RE: How to execute a DTS script [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

If you are using asp/iis.

Assuming you are using anonymous access, you already have these two accounts
set up: IWAM_<machine name>, IUSR_<machine name>

These two accounts need to have permission to your SQL server database.

David

"bnhcomputing" wrote:

> I have a completed DTS package in my SQL server.
>
> The examples talk about creating and executing a DTS from VB, but no
> connection information is ever provided. I just want to execute the
> already existing package, not create another.
>
> I would REALLY like to execute the package, that’s already in my SQL
> server, from an ASP. Does anyone have an example / documentation on
> how to simply execute an already existing DTS from VB or an ASP?
>
>
> --
> bnhcomputing

 >> Stay informed about: How to execute a DTS script 
Back to top
Login to vote
bnhcomputing

External


Since: Oct 01, 2004
Posts: 6



(Msg. 3) Posted: Wed Oct 05, 2005 3:05 pm
Post subject: RE: How to execute a DTS script [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I changed my methodology. I am using a stored procedure. Activate the
stored procedure from ASP. Stored Procedure activates DTS. Seems to get
around security issues.

--
bnhcomputing


"Dave" wrote:

> If you are using asp/iis.
>
> Assuming you are using anonymous access, you already have these two accounts
> set up: IWAM_<machine name>, IUSR_<machine name>
>
> These two accounts need to have permission to your SQL server database.
>
> David
>
> "bnhcomputing" wrote:
>
> > I have a completed DTS package in my SQL server.
> >
> > The examples talk about creating and executing a DTS from VB, but no
> > connection information is ever provided. I just want to execute the
> > already existing package, not create another.
> >
> > I would REALLY like to execute the package, that’s already in my SQL
> > server, from an ASP. Does anyone have an example / documentation on
> > how to simply execute an already existing DTS from VB or an ASP?
> >
> >
> > --
> > bnhcomputing
 >> Stay informed about: How to execute a DTS script 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
execute package of a number of execute package tasks - In a project I have created 6 dtsx packages, all doing about the same thing: sql task defines highest date in database and store in variable script task to create an oracle sql statement based on the above date dataflow task to 1.select from oracle...

Execute DTS package in SP - How would I execute DTS package in the SP? Thank you.

DTS "Execute SQL Task" - I have a Execute SQL Task that copy/transfer a big SQL table by executing: insert into .... select ... from .... Is there any benefit to run the sql in DTS (batch/lock handling)? Or it's the same to run it use Job schedule or just isqlw?

How to execute a DTS package from within Access 2000 - I want to know how to execute an existing SQL Server DTS package from within Microsoft Access 2000. Let's say I have an Access form with one control on it, a command button, and I want to execute the package when the button is clicked. Let's call my..

DTS Parameter on Execute SQL Task - First I am trying to use DTS for purging data. The first thing I want to do is export the data to be purged to a csv file. I am using parameters to hold variables such as dates. The export routines work using transform data task using the following....
   Database Forums (Home) -> DTS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]