Top "Ssis" questions

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

cannot show Visual Studio Tools for Application editor in SSIS 2012

When I click on EDIT SCRIPT button for Script Task in SSIS 2012 package, It does not open the Script editor …

ssis sql-server-2012 vsta
SSIS is executing successfully, but it doesn't seem to be running the script task portion

I have an SSIS package that runs an SQL query and exports it to a csv file via a Data …

c# sql-server csv ssis script-task
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
Script task won't open Editor in visual studio 2013

I am using SSIS 2014 and Visual Studio 2013. When I click on Edit Script button of script task no error nothing …

visual-studio ssis vsta
Error : The result binding name must be set to zero for full result set and XML results

I have only a single row that is being returned from a sql query(count(*)), but upon execution of the …

ssis ssis-2008
Could not load file or assembly 'Newtonsoft.Json' Version=11.0.0.0

I have read a lot of the responses to previous versions of this issue but none seem to work. Every …

c# visual-studio ssis json.net script-component
Migrating from Postgres to SQL Server 2008

I need to migrate a database from Postgres 7 to SQL Server 2008. I am familiar with the SSIS Import and Export …

sql-server postgresql ssis data-migration
See complete tooltip error message for Data Flow SSIS element in Visual Studio

One of the elements in my SSIS data flow diagram shows an error in the tooltip when I hover the …

visual-studio visual-studio-2008 ssis dataflow-diagram
Is it possible to perform T-SQL fuzzy lookup without SSIS?

SSIS 2005/2008 does fuzzy lookups and groupings. Is there a feature that does the same in T-SQL?

sql-server tsql ssis fuzzy-search
Why aren't my triggers firing during an insert by SSIS?

I have an SSIS data flow task with an OLE DB Destination component that inserts records into a table with …

sql triggers ssis bulkinsert