Thank you all for your reply.

My problem was solved.

My mistake is I am using SET ANSI_WARNINGS OFF, I am missing a colon at the end.

When I put a colon, SET...

In my package, I am collecting the values from a table into a variable using execute sql task and then passing those values to for each loop.

It will load the...

try to add Excel File Path property instead of connection string in connection manager ,connection expressions.

Thank you for your reply.

Your guess is almost correct, my problem is the Oracle source that I am calling is not in TNS file, my DBA told me that and...

Thank you all for your reply.,,

Here my problem is the data is coming from an Oracle source and is loading into a SQL table.

The Oracle data is updated at anytime , so I need to...

Try to adjust the Size and location of the Image and text box from properties window.

There is no limit for subreports as per my understanding because I am currently working with 30 subreports for my KPI.

Adjust the size and location of each subreport in properties...

Try to Adjust the Subreport Locaton and size in Properties window.

Hello krishusavalia,

use this.

SELECT distinct ID,SUBSTRING(NAME1, 1, DATALENGTH(NAME1)/2 - 1) AS [temp]

FROM

#temp1 c CROSS APPLY

(SELECT CONVERT(NVARCHAR(10), NAME) + '|' AS [text()]

FROM #temp1 o

WHERE o.ID = c.ID

ORDER BY o.NAME

FOR XML PATH('')) AS...

Drop table deletes only the column headings not the data.

I didn't find a way to delete the data from Excel. In my work, I copied the excel with a new...

Thanks Koen,

I solved this issue using 3 excute sql tasks and is working fine now.

Thanks Parkin for your reply.

I need my output must be in Excel, I found one of the articles where he is using a execute sql task to write in an...

Thank you for your reply John.

then can you tell me how can I avoid that?

thank you friends.

with the Replace function, my convert function is working fine.