Hi All ,

I want to execute SSIS pakage through a web apllication.
Please give me some pointers and idea , how to achieve this

Regards
Shagun

Hello Shagun,

How about you call a job which calls the SSIS package?

You could also of course install SSIS locally and call the package programmatically
or through DTExec

Allan

Hi Allan,

Can you please explain it more like how to execute SSIS package from a job

Thanks in advance

Shagun

"Allan Mitchell" wrote:

Hello Shagun,


Create a job that executes a DTS package (job step) It will do this by calling
DTExec.


Have a look in BOL Here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/c5fecc23-6f04-4fb2-9a29-01492ea41404.htm


Allan

Allan,

Hello. I posted a similar request..that is, how to call a SQL 2005 package
thru either an ASP or ASP.NET web page. I understand your post that you can
also call the package via a job. However, the BOL article you refer to NEVER
mentions doing this from a web page. It only mentions generically calling a
job which in effect calls the package. We need to call the job (or package)
from a web page. This was fairly simply in SQL 2000, but code I've used
below no longer works for SQL 2005.

<%

Dim oPkg

Set oPkg = Server.CreateObject("DTS.Package")
oPkg.LoadFromSQLServer
"HQ-SQLSERVER-01","PACKAGE_RUNNER","MYPASSWORD",DTSSQLStgFlag_De fault,"","","","LOAD_EAGLS_05"


oPkg.Execute()


%>





"Allan Mitchell" wrote:

Hello Roz,

Have you tried

CREATEOBJECT("SSIS.Package")


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

That looks like ASP code, not ASP.Net, you require the latter which is
different again.

Add a reference to the ManagedDTS library. Create an Application object and
use that to load the package. Then calll Execute.

--
Darren
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com

"Roz" <Roz (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,

i am also facing same type of problem that how to execute SSIS package in ASP.NET 2.0. I allready created a package using SQL server Business intelligence development studio.

how i can run the package in a web page and how to list errors (if encounterd) and status of SSIS Package to a text file??

I read u r replies to previous queries and i tried to look in BOL but i dont understand what actually BOL is??

pls give me some ideas.........

Thanks in advance,
Siva.