Try with 2 'single quotes' as text qualifier instead of double quotes..

Thanks,

Arun.

SSIS script component supports C# as well as VB scripting.. If you are comfortable with VB , you can use that..

Script component in most cases involves 2-3 standard methods...

BULK INSERT acts as a series of individual INSERT statements and thus, if the job fails, it doesn't roll back all of the committed inserts.

It can however be placed within...

For SSRS

1. Back up encryption keys and ReportServer database.

2. Restore ReportServer database and apply encryption key to the RS 2008.

3. Use the Configuration Manager to upgrade the ReportServer database to...

Use script component and increment the variable proportional to the rows..

Thanks,

Arun

Does your report has hidden columns??

Thanks,

Arun

Please check out this blog, might be helpful.

http://www.wiseowl.co.uk/blog/s94/extra-space.htm

Thanks,

Arun.