Ehrm... why would you create your databases on the D drive, but store...

And why o why do you keep your log files on your C drive?

That is waiting for disaster to strike.

Can't you put the generated files in specific folder and use a for each loop in the SSIS package to pick up the files?

If your data source is a database (most likely), you can add a column BoldIndicator to your query that is just a simple CASE expression:

CASE WHEN UserName IN ('John','Mike') THEN...

You should go to the report properties and check the size of the report. Make sure it fits on one page (A4 in Europe). This should be the same for...

I wonder how a page break in a CSV file looks like.

You can influence the layout based on the export format though:

Hide/Show Items Dependant On Export Format (SSRS)[/url]

I have been enabling page compression on our entire data warehouse recently, so this was a pretty easy question 🙂

It's possible. The source component got a timeout, which can be caused by locking.

Can you force SSIS to run after the update? If not, you can maybe try another isolation...

Whoah whoah, it's Monday! Easy with the questions 😀

(seriously, nice question)

Great question, thanks.

Nice question, thanks.

It would probably be useful to see what the stored procedure actually does.

Any reason you pass dates converted to strings as parameters instead of the actual dates?

avdhut.k (12/12/2013)

---

Hi Koen,

I don't want all the requirement to be done by you,

I just described by whole ...

I'll send my hourly rate... 😛 😀

You can do this by writing queries (obviously).

However it is not our duty to your job in your place. I'm willing to help with specific questions, but not with "here's...