You will also see this error when using a VPN to connect. I had a work laptop that you would log in using domain credentials. Then you would connect to...

I found an example online that used a cursor and didn't protect its own spid from getting killed so I created a different version.

DECLARE @spid INT, @sql VARCHAR(8000);

SET...

There is nothing inherently wrong with the Excel destination, but over the last several years I have found some significant limitations.

1) SSIS can only recognize and use the 32-bit MS...

Very good article! I can't tell you how much time I've spent having to parse delimited in T-SQL. While I haven't gotten all the way through the article,...

Instead of deleting all the rows in the table try truncating it.

TRUNCATE TABLE xxxxx

The truncate command deletes all the data and resets the identity column.