I have an SSIS package with a Data Flow that takes an ADO.NET data source (just a small table), executes a select * query, and outputs the query results to a flat file (I've also tried just pulling...

I'm having an issue processing an excel file with SSIS unless I manually open the file and click 'save'. I've noticed that it doesn't mater if the file is .xls or .xlsx The file is downloaded to...

I am trying to programmatically create an SSIS package containing a simple data flow from table A to table B in the same database. I am using the example given here. The package gets created and sa...

I am trying to update a field in a table with data from another table, based on a common key. If it were in straight SQL, it would be something like: Update EHSIT set e.IDMSObjID = s.IDMSObjID fro...

I'm trying to use event handlers to log errors in my SSIS packages. Unfortunately there is no option to add event handlers to individual tasks within a data flow task; I have consequently added an ...

I'm using a Derived Column Task to change column data using a CASE WHEN statement. However, I need to be able to say.. SQL CODE WOULD BE: CASE WHEN Column01 LIKE '%i%' THEN '0' ELSE '1' END In ...

I am in the process of developing an SSIS job on my workstation which a Data Flow Task open a comma delimited flat file on my local workstation and imports the data to a SQL server database on a re...