Top "Ssis" questions

SSIS (Microsoft SQL Server Integration Services) is a platform for building enterprise-level data integration and data transformations solutions.

SSIS Result set, Foreachloop and Variable

I'm having an issue and I don't know if this is possible to do. I have a simple SQL task. …

sql variables ssis resultset foreach-loop-container
DTExec: The package execution returned DTSER_FAILURE (1) in SSIS package execution

I've got this question within a project in ssis. I had to divide the original project into different packages because …

ssis execution ssis-2012 extract-error-message
"Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server

I can not find a solution for this error: The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded …

sql ssis ms-office
SSIS Expressions setting two variables

I'm trying to use an "Expression Task" within SSIS to simply initialize/set two variables. This seemingly simple task has …

ssis expression bids sql-server-data-tools ssis-2012
Select Query for the fixed length

I have an table called customer where i am selecting few columns and making its fixed length,where i need …

sql sql-server-2008 ssis text-files fixed-width
SSIS Element cannot be found in a collection (but I have them all listed!)

I'm getting a persistent error: The element cannot be found in a collection. This error happens when you try to …

variables ssis dts
Why does the SSIS Runtime fail to start the distributed transaction?

While creating an SSIS package for SQL Server 2008 i run into the following error: Error: The SSIS Runtime has failed …

sql-server ssis msdtc
Difference between ADO NET source and OLE DB Source in SSIS 2008?

Can anyone say the Difference between ADO NET source and OLE DB Source in SSIS 2008 ?are they both same in …

ssis msbi
Batch Inserting from Excel into SQL Server

Is there a way to do a batch update on SQL Server from a row of data in Excel? We …

sql-server excel batch-file ssis batch-insert