Thanks. It works.

Now I am trying other way. Moving data from flat file to ADO Net destination and I get following error:

[ADO NET Destination [293]] Error: An exception has occurred...

This has fixed the problem. Thanks.

It shows me warning

[ADO NET Source [1]] Warning: Rows sent to the error output(s) will be lost. Add new data flow transformations or destinations to...

I can get the data in crystal report without any problem. In SSIS preview it shows data correctly.

The workaround I am using now is exporting data into text file using...

In the target it shows as empty string.

I have tried to output it to nvarchar data type and text files without any success. It shows data inserted with no...

I am having same problem. Any help will be greatly appreciated.

I wanted pipe to use pipe as field delimiter instead of comma. However I found the answer. It should be:

declare @sql varchar(8000)

select @sql = 'bcp demo.scheme.test4...

In your dataset include row for zero values, which will force the row to appear.

orignal dataset

union

Select

'' as volume negotiated,

'' as volume pending,

'' as volume not negotiated

I have, If I put ReportV0_00_00_00 instead of dot It dispalys correctly.