Run DTS Package from ASP Page

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 ..

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 ..

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

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 ...

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 ...
>

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 ...

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
>

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