August 31, 2016 at 6:28 pm
Hi Guys,
I am not sure it is possible or not. Never done it before so not sure. Need guidance....
1) The first step Here is my Table Looks like in SQL
Table Name = ETL_Execution
ID,PackageName,PackagePath,Status
1,UniqueName,C:\temp\UniqueName.dtsx,Active
2,UniqueName1,C:\temp\UniqueName1.dtsx,Active
3,UniqueName2,C:\temp\UniqueName2.dtsx,InActive
4,UniqueName3,C:\temp\UniqueName3.dtsx,Active
2) Second Step:-
I want to create a .Net Page in my application
Where I have Two tab
First Tab = Package Name
Second Tab = Execute
What I want, User will Pick the package from the drop down and Hit EXECUTE to EXECUTE THAT SSIS Package.
Please advise from where I can start. Any advice would be great appreciated.
Note:- FYI User doesn't have VS (Visual Studio) installed on the machine. However on Server VS Installed.
Thank You.
September 1, 2016 at 7:54 am
It's doable but can take a bit to work out the permissions issues and how you want to handle that in your environment. You'll need to know where you are loading the package from - file, msdb or package store.
To get started, the methods to execute a package are exposed through Microsoft.SqlServer.ManagedDTS. Add that reference to the project and then import Microsoft.SqlServer.ManagedDTS. You essentially just load the package and execute it from there. Not much to do the basics with it. Microsoft documentation has examples. Refer to:
https://msdn.microsoft.com/en-us/library/ms136090.aspx
Sue
September 1, 2016 at 5:33 pm
As said you can do it with C#. - but execute it on the SQL Server server machine, not locally on the users machine.
see https://msdn.microsoft.com/en-us/library/ms403355.aspx for ways to execute a package
but... you need to execute the package on a machine with a fully licensed copy of SQL Server. You can't execute the package on an individuals PC except from within Visual Studio itself. Having a SQL Developer license is not considered a valid license even if it allows you to execute ssis packages outside visual studio.
So do take this in consideration when designing your application.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply