Run DTS Package from ASP Page

Report · Apr 19, 2006

I need a way to run a DTS Package saved on SQL Server ... the package is working fine on the server ... i got the code to do it but i'm getting a failure status when i run the code from the ASP Page .. server name + package name + username + password are all right .. but the package still giving me failed ... is there anyone did it before can help me please ..

Mohnd

Report · Apr 19, 2006

I've never done this, but a quick Yahoo search revealed several options:

http://search.yahoo.com/search?ei=utf-8&fr=slv1-&p=run%20dts%20package%20from%20ASP%20page

Best regards,
Chris

Report · Apr 19, 2006

Have a look at
http://www.sqldts.com/
They definately have articles on executing DTS Packages from ASP.

Pat.

"Mohnd" <webforumsuser@macromedia.com> wrote in message
news:e25utu$cl0$1@forums.macromedia.com...
>I need a way to run a DTS Package saved on SQL Server ... the package is
> working fine on the server ... i got the code to do it but i'm getting a
> failure status when i run the code from the ASP Page .. server name +
> package
> name + username + password are all right .. but the package still giving
> me
> failed ... is there anyone did it before can help me please ..
>
> Mohnd
>

Report · Apr 20, 2006

well they have it, but it's not working, or i should say it's giving me failed status ... there should be something missing .. but thanks for the help anyway ..

Mohnd

Report · Apr 20, 2006

I can honestly say that I have never had cause to execute a DTS from ASP
before but I am currently working on a project that I may have to. If you
get this working would you post back to let me (and others) know where the
problem is and what your fix is please?

Many thanks,

Pat.

"Mohnd" <webforumsuser@macromedia.com> wrote in message
news:e283db$5qr$1@forums.macromedia.com...
> well they have it, but it's not working, or i should say it's giving me
> failed status ... there should be something missing .. but thanks for the
> help anyway ..
>
> Mohnd

Report · Apr 20, 2006

alright guys .. let me make it clear .. i have a sql server and web server .. the package is on sql server and it will take an excel file and load it into the database ... i have an ASP page will let the user upload the file and after the file uploaded the package should run ... and load the file to the database ... now .. eveything is working fine with me but the package .. i can run the package from the sql server .. it's working fine but i need a way to run it from the ASP page ... i tried many ways for that .. but still not working ... now i'm working on creating a .bat file to run the package and run the .bat file from the web page .. but i don't know if this gonna work .. please if there is anyone know a way to do it .. please help me ...

Report · Apr 21, 2006

Where exactly is it failing?

"Mohnd" <webforumsuser@macromedia.com> wrote in message
news:e28ppl$5ts$1@forums.macromedia.com...
> alright guys .. let me make it clear .. i have a sql server and web server
> ..
> the package is on sql server and it will take an excel file and load it
> into
> the database ... i have an ASP page will let the user upload the file and
> after
> the file uploaded the package should run ... and load the file to the
> database
> ... now .. eveything is working fine with me but the package .. i can run
> the
> package from the sql server .. it's working fine but i need a way to run
> it
> from the ASP page ... i tried many ways for that .. but still not working
> ...
> now i'm working on creating a .bat file to run the package and run the
> .bat
> file from the web page .. but i don't know if this gonna work .. please if
> there is anyone know a way to do it .. please help me ...
>

Report · Apr 21, 2006

here is the exact msg after runing the page (mean run the package from the ASP Page)

Step [DTSStep_DTSDataPumpTask_1] failed
Task "Transform Data Task: Data"

Step [DTSStep_DTSExecuteSQLTask_1] failed
Task "Execute SQL Task: Clean"

Package [PlanFileDumpUpdate] failed

Done

then when check the table there is nothing changed ofcourse ...

Report · Apr 21, 2006

Your package is running. Focus on the package rather than the ASP page. Is
it expecting a file in a certain location? Is that file there? Does it
have the proper name? Is the file still being written when the package
tries to read it?

"Mohnd" <webforumsuser@macromedia.com> wrote in message
news:e2asl4$rd7$1@forums.macromedia.com...
> Step failed
> Task "Transform Data Task: Data"
>
> Step failed
> Task "Execute SQL Task: Clean"
>
> Package failed
>
> Done

Report · Apr 24, 2006

well everything is fine .. and it's not running .. it's failing .. please guys if u really know what i'm talking about reply to this post ..
thanks for all who replied and trying to help ..

Report · Apr 25, 2006

The package can't fail if it doesn't run. That's the whole point you're
missing. The package is being triggered, it is running, and it is failing.
Something is not the way you think it is. My guess is that you're trying to
process a file that doesn't exist.

"Mohnd" <webforumsuser@macromedia.com> wrote in message
news:e2jfgi$ii0$1@forums.macromedia.com...
> well everything is fine .. and it's not running .. it's failing .. please
> guys if u really know what i'm talking about reply to this post ..
> thanks for all who replied and trying to help ..