Is it possible to execute a SSIS package in C# Code ? We can process cube using the namespace \"Microsoft.A开发者_如何学JAVAnalysisServices.AdomdClient\". What will be namespace/method to be used for
I would like to Download Email attachment using SSIS.If possible,Please describe the pr开发者_StackOverflow中文版ocess.If you can use third-party solutions, check the commercial CozyRoc SSIS+ library.
Given a entry in a sysdtslog90 table in SQL Server 2005 fro开发者_JAVA技巧m an SSIS package, how do you figure out what database agent job the entry was run under?It looks like, after many tests and e
Unfortunately I don\'t have a repro for my issue, but I thought I would try to describe it in case it sounds familiar to someone...I am using SSIS 2005, SP2.
Working on a Data Warehouse project, the guy that gave us the tutorial advised that we stick to using SQL queries over defining a lot of data flow transformations, citing points like it\'ll consume a
We are a team working on a bunch of SSIS packages, which we share using version control (SVN). We have three ways of saving sensitive data in these packages :
I have a table with three fields, one an identity field, and I need to add some new records from a source that has the other two fields.I\'m using SSIS, and I think I should use the merge tool, becaus
I am trying to merge records from an Oracle database table to my local SQL table. I have a variable for the package that is an Object, called OWell.
Using Script Task, I have written a code to create a folder and create a MS Word document inside the newly created folder. It is working on the local machine but it is not working on the server where
I have an SSIS package that works fine. The package runs every night and takes about 4 hours to complete. I have am a newb to SSIS, so I want to see what my options are. I am not finding anything on t