Sorry, hope this is more helpful. The code below creates two sample tables, Job and Stream and populates them with some sample records.

USE [MIStg]

GO

/****** Object: Table [dbo].[Stream] ...

Thanks for the response - I had seen both those articles but unfortunately it's none of those issues. The package finishes running - if the data viewer window was hiding...

Just wanted to express my thanks for putting this article together! You got the concept of CROSS APPLY across perfectly. I'm grateful to all you DBA/DEV boddhisattvas out there sharing...

Thanks a lot - makes perfect sense now 🙂

Doodles

Hi Suresh

That's worked - thanks so much! Seems obvious now 🙂 In fact, there is no need to cast the @pwd variable within the EncryptByPassphrase function. Simply returning as varbinary...

Wow, what a great article - it was really clear to understand & helped introduce some new ideas to a TSQL newbie like myself. The comments on the article are...

Thanks for that - it kind of put me on the right track - i think. Although this is what my final solution looks like:

call c:\robocopy\robocopy c:\Source\ \\SomeShare\Destination\ /NP /MAXAGE:1...