Top "Ssis" questions

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

SSIS - How to loop through files in folder and get path+file names and finally execute stored Procedure with parameter as Path + Filename

Any help is much appreciated. I am trying to create an SSIS package to loop through files in the folder …

ssis ssis-2012
How can I clean up the SSISDB?

When I set this up I overlooked the retention period. My database has become pretty large so I want to …

ssis sql-server-2012
SQL Server Agent Jobs: How to execute a job step without executing the entire job

I have a SQL Server Agent Job that previously had two steps. Today, I've had to integrate a third step …

sql sql-server sql-server-2005 ssis sql-server-agent
SSIS Error: VS_NEEDSNEWMETADATA

I'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting …

sql sql-server tsql ssis sql-server-2016
SSIS Variables vs Parameters (SSIS Denali)

What is the difference between Variables and Parameters in SSIS Denali? If there is any difference then What is that …

ssis
To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher

I am testing SSIS package that I upgraded from VS2005 project to VS2013 (package deployment model) project. This is very …

sql-server ssis sql-server-data-tools ssdt-bi
SSIS - Delete rows

I'm new to SSIS and need help on this one. I found an article which describes how to detect rows …

ssis insert delete-row sql-delete
Is Alteryx an ETL tool? How it differs from SSIS?

My client want me to implement ETL process using Alteryx as they have a license of it. I am confused …

ssis etl difference alteryx
xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors

I have an xlsx file that I generate using SSIS. The data to this file is written through a data …

xml excel ssis xlsx