I already tried the link but the solutions are static. My requirement is dynamic. Based on the parameter values the column hide/ show is decided

If you are using table to display the report then right click on the table -> go to Tablix properties. You will find a page break option in the General...

Hi

My unique Id is of type string. Is that is the problem for random data insertion??

Hi

I m attaching the files of input csv file and the data inserted in the database table. The delimiter is fixed length of 88.

Data is not inserting in order from csv to database table. csv file has 10K records which has unique id records(1,2,3,....10000). when I transform the csv file data to database...

Hello,

My question may have confused you. I want to make it more clear. here is the flow:

I m creating a Excel source with static columns and database with static columns...

Excel file depends on user input. I cannot say what type of columns exists in the excel file. I can get the columns at run time.

Hi

Thanks for quick response. Let assume that I have schema of both source and destination in the following formats.

In excel File, I have columns (Id, Name, Salary) and in...