Yeppie the haunting of coding continues....:-D:-D:-D

happy to help you

Anyways you may use a Script Task to validate your incoming file...

But a word of caution:

You are inviting a lot of .NET I/O code to be composed.

Happy coding

Laurence an empty cell in Excel corresponds to a NULL field in SSIS

So if you can manipulate the NULL field to some meaningful entity you have a work around....

Thanks i'll give it a shot

:-):-):-)

Yes Phil you are correct

Rohit I have another solution...considering the restrictions posed

You may use variables TO and FROM variables to filter your query inside a foreach loop

(Assuming you have implemented ROW_NUMBER() to get distinct...

Anitha,

SBS= SQL Server Business Intelligence Studio.

http://www.sqlservercurry.com/2007/12/configure-report-to-be-cached-ssrs-2005.html

Sachin,

You have to cache your dataset.

It's taking long time because the server is actually executing the entire query again and fetching the result...:-):-);-)

Even better...make table partitions of your dataset.

then send each partition to a respective sheet

You might consider using the export to Excel 2007

balasach82 (7/26/2010)

---

For Input files which are dynamic, rather than using the Variable option, is there a way to store the details in a table, so that when the pkg runs...

Hi Pramod,

You might want to create a a set of Event Handlers.

You may use the Script Task to suit your need.

As a best practice it is adviced to use a...

Quick rule of thumb:

If you want to add it, sum it, average it or manipulate it numerically in almost any way, put it in the fact table. Put everything...

check the performance monitor....chk the process which is causing high memory consumption...