Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Run SSIS/DTS Package From C# Page With SQL Installed

Posted on 2011-03-04
6
808 Views
Last Modified: 2013-11-30
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?
0
Comment
Question by:twcadmin
  • 3
  • 2
6 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 35039219
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35224875
Unlike DTS, in order to execute SSIS you need a license for MS SQL Server.
0
 
LVL 39

Expert Comment

by:lcohan
ID: 35234012
Obviously you don't need to install SQL Server on your Web server
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 35237160
>>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
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 500 total points
ID: 35237166
>>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
 
LVL 5

Author Closing Comment

by:twcadmin
ID: 35314323
Thanks for the feedback!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question