Top "Ssis-2012" questions

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

querying ssisdb to find the name of packages

i was querying the ssis catlog to find out the name of all the packages in the catalog. There are …

Read More
sql sql-server ssis ssis-2012 ssis-2016
In Integration Services Catalogs getting "Cannot access a disposed object." error

In Integration Services Catalogs I configured parameters of the project and pressed OK and then again when I am going …

Read More
ssis ssis-2012 ssis-2016
Building an SSIS EXPRESSION to test if a variable is empty

I am building an expression in expression builder to do the following, but this gives me an error: @User::AccountID != …

Read More
ssis ssis-2012
SSIS:File System Task 'Could not find file'

I am working on a SSIS project that download a file via web and upload the data in sql server …

Read More
sql-server ssis etl sql-server-data-tools ssis-2012
How to pass parent variable value to child package for reference type: External Reference

I have a ssis project in which the master package contains many child packages. All the child package are invoked …

Read More
sql sql-server ssis ssis-2012 ssis-2008
How to skip last row in the SSIS data flow

I am using FlatFile Source Manager --> Script COmponent as Trans --> OLEDB destination in my data flow. …

Read More
sql-server ssis etl ssis-2012 dataflow
Query a database based on result of query from another database

I am using SSIS in VS 2013. I need to get a list of IDs from 1 database, and with that list …

Read More
sql sql-server ssis etl ssis-2012