As far as I know, you cannot create a JPEG file with multiple pages.

I'm not sure exactly what those settings affect, but worth a try 🙂

Have a look in Tools / Options / Database Tools / Table and Database Designers / Column Options in BIDS.

Lynn Pettis (3/30/2012)

---

Phil Parkin (3/30/2012)

---

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...

Koen Verbeeck (3/30/2012)

---

The reason there's no error is probably because the For Each Loop thinks it has no access rights, so there are no files to loop over.

So I would...

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?