Thanks for your reply ndiro.

I am not using BIDS/Report builder for generating the RDL file.

I am creating the RDL file programmatically (.net). So not sure how to get the Datasource...

Hi,

I also face the same issue where errored rows is being created with a blank row between each errored row.

My Source file is Comma...

Forgot to mention..... We actually use SQL Server 2005

Thanks,

Arunvijay

Thanks for ur reply.

I am not sure how to check if MsDtsServer100 is running in this server or not. can u let me know how to check this?

Thanks,

Arunvijay

Thanks man

Hi,

Any other ways to resolve this issue? i feel,re-installing SSIS maynot be the ideal solution.

Thanks,

Arunvijay

Veeran, Thanks for your reply.

But this doesnt seem to work. The blank spaces remain as before.

Any suggestions?

Thanks,

Arunvijay

But i face a strange problem.

In SQLServer 2005 environment (enterprise&standard edition) when i use this DLL ,

the solution works gr8 if we preview the report using BIS. But...

Thanks Adams. The solution looks gr8.

But i face a strange problem.

In SQLServer 2005 environment (enterprise edition) when i use this DLL ,

the solution works gr8 ,

---->when we...

Thanks all for ur replies..

The # of rows to skip will vary , and in the production environment , we will not have priviledge to change the ETL packages. Thats...

Thanks for ur reply CozyRoc.

I know we can very well use variables in send mail task . But my requirement is to use custom components as far as possible.

to give...

if i use Send mail task , i need to manually put the smtp server,from & to address , mail subject,etc ..... These info are taken from table and assigned...

i got a link which satisfies my requirement :

http://www.sqlservercentral.com/articles/SSIS/62678/

(As per the forum) the "Get Daily Totals" (execute sql task) works perfectly , but i have problems in "Test...

Hi Paul,

I am trying to generate a package similar to what you have put it over here. I use the same variable , same name for all tasks too. But...

No. Actually speaking , i really dont know how to close the file.

Can u let me know how to close the file??

Moreover , i dont see any option like...