Top "Ssis-2012" questions

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

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
SSIS error: delimiter for column "columnX" is not found

This question was asked here before but the solutions proposed don't seem to be working for me. I'm trying to …

sql ssis etl sql-server-data-tools ssis-2012
Reading project parameters in Script Task

This is what I'm trying to do in a script task: long lngMaxRowsToPull = Convert.ToInt64(Dts.Variables["Project::MaxRowsPerPull"].Value); …

ssis ssis-2012
SSIS Package Not Running as 32bit in SQL Server 2012

I have a package that I developed in VS2012 (using the SQL Data Tools component) which collects data from a …

ssis sql-server-2012 oledbconnection visual-foxpro ssis-2012
ErrorColumn value does not exist as Lineage ID

During the insert into a destination table, any error that occurs is redirected to Errors table where we can see …

ssis etl ssis-2012
Why is "Use environment variable" option disabled/grayed out in SSIS2012 catalog configuration?

This may sound like an easy question but the answers on the net all point to the basics of setting …

ssis-2012
Anyway to deploy a SSIS 2012 project built in VS 2013?

First, I'm loving the very clearly delineated versioning of the SSIS tools. >:( I installed SSDT BI for Visual Studio 2013 …

visual-studio-2013 ssis-2012 ssdt-bi
what is environment variable configuration in ssis and what registry entry configuration in ssis

I am learning SSIS. Now I'm stuck with configurations. I have done xml, parent package and SQL configuration but I …

sql ssis etl ssis-2012 msbi
Convert String to Int SSIS

I have an string of original source and into destination table It was decimal(5,2), I try to change it with …

sql-server ssis etl ssis-2012 derived-column
How to download SSIS Packages from SSISDB

I'm still fairly new to SSIS. I've figured out how to download packages from a server by connecting to Integration …

sql-server ssis ssis-2012 ssis-2014