it means you need to fetch these field data

you can do following:

create a subreport, place that in the "YOURREPORT", and show these field.

OR

create parameters in the report. get these...

In 'ReportServer' db you can find the following view

1. ExecutionLog

2. ExecutionLog2

3. ExecutionLog3

Find the relative Data from them i hope it will serve the purpose for u.

if there is large data set in the #Temp table, all you find in the query execution plan is "tableScan" for #Temp table, If you need to increase the performance...

is this table consist of all field with varchar/nvarchar, or there are multiple data types. i am asking this because if you have all varchar field it is a issue...

try following

1: Remove the Old ADO.NET Source and place the new one.

2: Select the Connection (Also test the connection).

3: Place the query, without Column99 and click the "Preview" button available...

what is your source type? can...

ananda.murugesan (12/12/2013)

---

I want to know if an issue...

Best practice is to only fetch the required columns from source its speedup things, so that you do not get into these kind of issues. Furthermore, there is no issue...

Jim1234 (12/12/2013)

---

Hi Bhaskar,

In my case, multiple sheet is not preffered. Is there any way to rename the CSV column header. It is giving text box names now. For ex, Emp_Name1...

Koen Verbeeck (12/12/2013)

---

avdhut.k (12/12/2013)

---

Hi Koen,

I don't want all the requirement to be done by you,

I just described by ...

hmmmm .... one should look for a bank for loan 😛

look like a assignment for you Koen :hehe:

Okay , what is the Row Per Batch value configured on your destination level?

in bulk insert Task options, what is the value of 'TabLocK' and the value of batchSize?

By the way, why you want to view the data in that table? is for...

try to make a copy of the excel file and then use bulk insert. by doing so you can avoid the blocking source issue.