Tag Archives: ssis

Automate changes in SSIS packages

Posted on January 28, 2022 by erictummers

We use Sql Server Integration Services (SSIS) for importing and exporting data. The number of SSIS packages is stil growing and on writing this post we have 35 of them. Changing the database connectionstring for development means opening and editing … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Lift and shift SSIS package

Posted on October 15, 2020 by erictummers

We use Sql Server Integration Services (SSIS) to import text files into our database. The dtsx files are deployed into the MSDB on the Sql Server. Everything works well with deployment with a powershell DSC script. But times change and … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server

Posted on April 12, 2017 by erictummers

We use SSIS packages to import files. These SSIS packages are run with sqljobs. During deployment the sqljobs are created with a script. That is the plan. While running the script to create the sqljobs we got an error: Error … Continue reading →

Posted in Development | Tagged , , , | 4 Comments