Hi Jack - thanks for your response. Just after posting this I did a little further digging ("googling" to give the technical term) and found a property on the...

Thanks chaps. 🙂

Ah ah - just sussed out the problem. I changed the Timeout setting on the SMTP Connection Manager to be 15000 milliseconds. All now works well.

Hi Orlando - no, I still can't get the Send Mail Task to work within the infinite loop. As I suggested, it consistently fails on the second run with...

Thanks Orlando - I've PM'd you but can't attached the dtsx file.

Thanks for the great article. I'm using SQL Server 2012 and all work well, until I add a Send Mail task at the end. The object of the...

I've put the whole process inside an infinite loop and have two near-identical processes running side by side (for two differing file formats), and I've also included a Send Mail...

This was helpful, so thanks.

I needed to use a Derived Column transform, then a Sort, and undo the IsSorted and SortKeyPosition, before the Merge Join would work. I'm still...

Hi Andy,

Just found your link to the db, so please ignore my most recent post. Apologies, I should have read through the posts first.

Cheers,

Richard

Hi Andy - I can't seem to find a copy of the sample db. Would you be so kind as to post a link?

Cheers,

Richard

Thanks for all your replies and suggestions. The solution was, as it were, under my nose. I was using a text box, rather that a table object. ...

Hi Chris,

Yes, I'm getting the correct number of row when I exec the sproc from the tab. There's no filter at all, except for the parameter chosen at run-time....