Jeff Moden (3/30/2012)

---

If you can make a small mod to your Calendar table... I usually create a Calendar table with 2 date columns to easily solve such an eventuality. ...

Create two new variables in...

Not in my opinion. In statements such as 'between a and b', it is generally assumed that 'a' is smaller, less or fewer than 'b', whatever a...

Koen Verbeeck (3/30/2012)

---

Phil Parkin (3/30/2012)

---

Or create a linked server on the TBL_A server to the server with the codes table. Then create a view on the TBL_A server which returns...

Or create a linked server on the TBL_A server to the server with the codes table. Then create a view on the TBL_A server which returns the required data (join...

Execute Process.

Set a breakpoint in your code by clicking on one of the lines near the top and hitting F9. A red dot will appear in the margin.

Save that and click...

But you have SSIS installed? Otherwise, how are you running this?

Have you stepped through the code in debug? This should help you identify the exact cause of the problem.

Expand on what you mean by this please. What have you tried?

I do that sometimes ... it's not always a happy experience - sometimes you realise...

Well that clears things up.

Personally, I'd keep the file name as-is and instead use...

😎

Thanks for...

Try this. Use a Script task and add the following two Usings:

using System.Net;

using System.IO;

Then change your Main sub - here's something I copied from elsewhere on the Web:

...