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.Runtime; but that SQL must be installed.

How can I run a package from my web server without installing SQL Server on it?
LVL 5
twcadminAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Anthony PerkinsConnect With a Mentor Commented:
>>Obviously you don't need to install SQL Server on your Web server <<
I agree, unfortunately in order for them to execute an SSIS package in a production environment anywhere it requires a license for MS SQL Server. So either they re-think their plan or they will have to get a licensed copy of MS SQL Server installed on the web server.
0
 
lcohanDatabase AnalystCommented:
As far as I know all you need is DTEXEC and the package.

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
0
 
Anthony PerkinsCommented:
Unlike DTS, in order to execute SSIS you need a license for MS SQL Server.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
lcohanDatabase AnalystCommented:
Obviously you don't need to install SQL Server on your Web server
0
 
Anthony PerkinsConnect With a Mentor Commented:
>>How can I run a package from my web server without installing SQL Server on it? <<
One approach is to execute SSIS remotely on a server that has a licensed version of SQL Server using something like Control-M or PSExec.
0
 
twcadminAuthor Commented:
Thanks for the feedback!
0
All Courses

From novice to tech pro — start learning today.