Reading these posts makes me feel better about only having SQL Server 2016 (and an exit plan for it) and procrastinating over upgrading my Windows 8.1 tablet because it works...

Check the schedule on the SQL agent job to make sure it isn't running repeatedly.

Check the advanced settings for the job step and make sure that the job is set...

I've never been across the pond to the USA but I hate pubs here in the UK where the music is too loud and everyone is having to talk loudly...

As a data engineer currently involved in a pilot for migrating an on-premises SQL Server corporate data store to a cloud AWS data lake with S3 storage and Athena querying,...

You set which version of SQL Server you are deploying the package to in the project properties.

Open SSIS solution in visual studio and right click the project name and select...

I had to do this recently in SQL Server 2016 and used STRING_SPLIT which was far simpler and seems to keep the order anyway.

It's another day when I think SQL Server Central must have been spying on us, producing such on-topic editorials, as here I am, old enough to claim my UK state...

When this post was first published I was commuting two hours each way to contract work in a city with an hour of that on the train. My train time...

This doesn't float my boat because I'm a fan of the MERGE statement and use it extensively in our data warehouse loading. So extensively that I have written a script...

I generally parameterise Connection String and Password and set up environment variables to match. That keeps down the number of parameters.

And yes they do overwrite whatever is in the package.

But...

I use portable hard drives for my personal systems because the internet is not truly global and I go to many places where it is not possible to get a...

This article assumes data is defined and dropped for us. Most of the time we have to fetch it for ourselves, whether from direct database access or via API connectivity....

You can right click and export a project from the SSISDB catalog and save it as a .ispac file. Then you can open visual studio and File, new Project, Import...

Like Jeff I love working remotely and I now find it very difficult to concentrate and do any individual work in an office environment. With the return to office working,...

I use MySQL for web sites because it is free, open source and the chosen standard to work with php and wordpress and is fine for small stuff such as...

• This reply was modified 3 years ago by  P Jones.