Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Run SSIS package from VB.Net Or ASP.NET

Status
Not open for further replies.

Skittle

ISP
Sep 10, 2002
1,528
US
I am thinking of writing a dtsx package that takes data from an SQL Server and writes it to an Iseries.
There are plenty of code examples out there that indicate using Microsoft.SqlServer.Dts.Runtime will do this.
There is quite a bit of data transformation involved in my requirements so I think doing it in a dtsx is faster than doing it in VB.Net.

However when executing a SQL Server .dtsx package from VB.Net or ASP.Net what permissions need to be available to run it?
On the assumption the SSIS package contains connection strings with valid usernames and passwords hard coded and VB.Net can see the package on the hard drive as a .dtsx package; are there any SQL server permissions needed to run the package from VB.Net or asp.net?


Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top