kapil_kk (12/18/2013)

---

Koen Verbeeck (12/18/2013)

---

kapil_kk (12/18/2013)

---

Abu Dina (12/18/2013)

---

If your source data comes from a SQL Server table then why not use SQL command as your Data Access mode (in the OLEDB...

Do you rely on any specific assemblies in your code? (who might not be present on the other machine?)

kapil_kk (12/18/2013)

---

Abu Dina (12/18/2013)

---

If your source data comes from a SQL Server table then why not use SQL command as your Data Access mode (in the OLEDB Data Source component)...

Please do not crosspost. It fragments replies and wastes peoples time.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1524028-2799-1.aspx

Are you talking to yourself now? 🙂

Easy one. Doesn't even matter which feature we're talking about as those two are the most restricted versions of SQL Server.

Try setting DelayValidation to true on the package and the data flow.

Do any of your tables have indexes?

That tool is already built-in into SQL Server:

SQL Server Audit (Database Engine)

What's your source, SSAS or SQL Server?

I would read the head as it were data and concatenate the values in a script component.

One question though: why do you need to fiddle around with the header when...

wendy elizabeth (12/17/2013)

---

In your formula of

Body + header + footer + margins <= report,

can you give me examples of values you would use?

Is the body the actual data that...

mister.magoo (12/17/2013)

---

Good day Threadizens 🙂

I have written an article (my first) on how to get help with SSRS reports.

It was inspired by Jeff's classic "Forum Etiquette: How to post data/code...

wendy elizabeth (12/17/2013)

---

So you are saying that the 'report' object is the largest object in ssrs report? Then the 'body' should be just slightly smaller than the 'report' object is...

Pulivarthi Sasidhar (12/17/2013)

---

Thanks for Info...

But in mycase, the Job generates Single file only as Filename_YYMMDD_HHMMSS.csv

How my SSIS package read this file as YYMMDD_HHMMSS[ This will differ at the time of...