twcadmin
asked on
Run SSIS/DTS Package From C# Page With SQL Installed
I'm trying to run a DTS/SSIS package from my web page but I don't have SQL installed on the web server. I've seen references to include using Microsoft.SqlServer.Dts.Ru ntime; but that SQL must be installed.
How can I run a package from my web server without installing SQL Server on it?
How can I run a package from my web server without installing SQL Server on it?
Unlike DTS, in order to execute SSIS you need a license for MS SQL Server.
Obviously you don't need to install SQL Server on your Web server
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the feedback!
Here are some options depending which SQL version you are running:
http://technet.microsoft.com/en-us/library/ms143755.aspx
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a636dd43-daf3-489a-9696-848d1f72304c