One of your five a day
Sometimes in SSIS we want a particular task to succeed but still have two paths or options, almost like a SSIS Success on Failure outcome. For example, we may want a package to check to see if a file exists before
When using the new SQL Server Integration Services (SSIS) catalog we can deploy our solutions using the UI or build a T-SQL script to deploy it creating folders on the way for a repeatable successful deployment package.Firstly we set the database,
Using SSIS we had a Excel Source to import regularly into a database. We constructed a simple project in SSDT and it ran successfully. We then deployed the project, started an SQL Agent job step with a step as an SQL