Top "Ssis" questions

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

How to debug a script component in SSIS

It's simple but I can't make it work, and I read in so many places a lot of solutions but …

visual-studio-2008 sql-server-2008 ssis
Why doesn't SSIS recognize line feed {LF} row delimiter while importing UTF-8 flat file?

I am trying to import data from a utf-8 encoded flat file into SQL Server 2008 using SSIS. This is what …

sql-server sql-server-2008 utf-8 ssis flat-file
SQL Server Agent - SSIS Package - Error 0x80131904 - Timeout expired

There's been a string of random occurrences of the following error in the SQL Server Agent scheduled jobs lately that …

sql-server ssis sql-server-2012 sql-server-agent
Is it possible to perform a "LIKE" statement in a SSIS Expression?

I'm using a Derived Column Task to change column data using a CASE WHEN statement. However, I need to be …

sql ssis sql-like case-statement dataflowtask
gpg: decryption failed: No secret key

I am not able to decrypt my file without secret key. I know this question is asked on this before, …

encryption ssis gnupg
What is a staging table?

Are staging tables used only in Data warehouse project or in any SSIS Project? I would like to know what …

ssis etl data-warehouse staging-table
SSIS importing datetime column into SQL Server 2008

I am trying to import a PSV file into SQL Server 2008 using SSIS. All is working fine apart from one …

sql ssis dts
Haven't got Microsoft.SqlServer.ManagedDTS.dll but

I am trying to write a .NET program so I can execute a Dts pacakge but I cannot find the …

sql-server-2008 c#-4.0 ssis
SSDT-BI SSIS in x64?

I run Visual Studio 2012 and I'm new to SSIS. I attempted to install SSDT-BI (June 2013 version) in order to research …

sql-server visual-studio-2012 ssis sql-server-data-tools ssdt-bi
How to reconfigure the column information on a flat file connection manager?

I have a Flat File Source that is reading data from a flat file. We have recently added a new …

ssis etl dataflow