SSMS allows you to publish to an Integration Services runtime in Azure, but you can still create an on-prem SSIS catalog and deploy packages there. If you have an on-prem...

How are you executing the package? Is it running as a T-SQL job step, or are you using the SSIS Package job step type in the SQL Server Agent job?

Take a look at a post I wrote on that topic, using the same corrupt file pattern as an example: https://www.timmitchell.net/post/2013/08/05/continue-package-execution-after-error-in-ssis/

You *can* connect using the legacy Integration Services connection in SSMS, but only for packages that are deployed to MSDB. I rarely see packages deployed to MSDB in 2012 in...

Yes, that's where the SSIS catalog will reside. It looks like you haven't yet created an SSIS catalog on that instance. You'll need to first create the SSIS catalog before...

Starting in SQL Server 2012, you no longer connect to Integration Services directly like you would in prior versions. It is now accessible as a node in the connection to...

• This reply was modified 5 years, 10 months ago by  Tim Mitchell.

The short answer is that there's not an easy way to convert all of those package connections with the same name to a new project connection.

The longer answer: When you...

I keep an install of SSDT 2015 around just for this reason. That version will let you downgrade all the way to SQL Server 2012.

You'll probably get more responses if you'll post some context rather than just the raw text of the error message.

Are you storing the packages in the SSIS catalog? If so, set up a project or package parameter for the password, and then use an SSIS catalog environment to store...

I call it Coding for Eventual Failure. Every process will eventually fail. Like you, I tend to code pessimistically as well.

Nick, I blogged about using the SSIS object variable to handle multiple result sets: https://www.timmitchell.net/post/2015/04/27/the-ssis-object-variable-and-m

I hope this helps!

I'd recommend looking into Biml. There is a great Stairway To Biml series on this website to help you get started.

Thanks for the mention of the SSIS Design Patterns book (I'm one of the coauthors). Our publisher is running a Black Friday special on this and all of...

Those send mail tasks are inside a For Each Loop. If you're getting two emails, I'd guess that the loop condition is set to allow the contents of that container...