SQL Server Integration Services - QA from the 1st BI class

Q1 How to trigger SSIS/SSRS jobs manually/on-demand without using the SQL Agent. How can I let end users trigger dtsx packages. Are there API hooks that I could run from a VBScript form (ideally) or perhaps .NET
Q2 I would like to know how you loop through different directory and upload files from various directories using SSIS. It will be great if you can give some demo.

Q
>>How to trigger SSIS/SSRS jobs manually/on-demand without using the SQL Agent. How can I let end users trigger dtsx packages. Are there API hooks that I could run from a VBScript form (ideally) or perhaps .NET


A
It should be as easy as this (C#) and can be used in Winforms, WPF, ASP.NET, etc…

string pkgLocation;
      Package pkg;
      Application app;
      DTSExecResult pkgResults; 

      pkgLocation =
        @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services" +
        @"\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
      app = new Application();
      pkg = app.LoadPackage(pkgLocation, null);
      pkgResults = pkg.Execute();
from http://msdn.microsoft.com/en-us/library/ms136090.aspx


Q
>>I would like to know how you loop through different directory and upload files from various directories using SSIS. It will be great if you can give some demo.

A
Check this out
http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

Latest Posts

Popular Posts