Q
SSIS can export data into excel files, and SSRS can also do this. Which way is better / more appropriate in which circumstances?
Showing posts with label SSIS. Show all posts
Showing posts with label SSIS. Show all posts
SSIS and SSRS - QA from the BI class
Labels: business intelligence, sql server, SSIS, SSRS
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.
Labels: business intelligence, sql server, SSIS, SSRS
Subscribe to:
Posts (Atom)
Latest Posts
Popular Posts
-
*Updated* 26. September 2010: Updated with comments from Adam Cogan *Updated* 27. September 2010: Updated the comparison between anonymo...
-
It's easy I thought, just select the Property of the EntityType and set the Default Value in the Properties window to: DateTime.Now ...
-
Had some discussions about Lists and controls, like Listbox and Listview, and sometimes its difficult to distinguish those. System.Win...