MS SQL Server DTS - Execute SSIS package though ASP.Net 2.0 application

Author

Execute SSIS package though ASP.Net 2.0 application

Shagun

2006-01-17, 7:23 am

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

Allan Mitchell

2006-01-17, 8:23 pm

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 All ,
>
> I want to execute SSIS pakage through a web apllication. Please give
> me some pointers and idea , how to achieve this
>
> Regards
> Shagun

Shagun

2006-01-18, 3:23 am

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

Allan Mitchell

2006-01-18, 8:24 pm

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

[color=darkred]
> Hi Allan,
>
> Can you please explain it more like how to execute SSIS package from a
> job
>
> Thanks in advance
>
> Shagun
>
> "Allan Mitchell" wrote:
>

Roz

2006-03-13, 9:24 am

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_Defau
lt,"","","","LOAD_EAGLS_05"

oPkg.Execute()

%>

"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 Mitchell

2006-03-13, 8:24 pm

Hello Roz,

Have you tried

CREATEOBJECT("SSIS.Package")

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com
[color=darkred]
> 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_Defau
lt,
> "","","","LOAD_EAGLS_05"
> oPkg.Execute()
>
> %>
>
> "Allan Mitchell" wrote:
>

Darren Green

2006-03-14, 3:23 am

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@discussions.microsoft.com> wrote in message
news:4AE68A34-4A61-4414-A099- 0896B242F729@microso
ft.com...[color=darkred]
> 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_Defau
lt,"","","","LOAD_EAGLS_05"
>
>
> oPkg.Execute()
>
>
> %>
>
>
>
>
>
> "Allan Mitchell" wrote:
>

siva

2006-04-03, 1:30 pm

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.

--
siva
------------------------------------------------------------------------
siva's Profile: http://www.dbtalk.net/m105
View this thread: http://www.dbtalk.net/t165207

Sponsored Links