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