Hi,

Have you tried increasing Page Width and Page Height on Report Properties ?

Hope this helps,

Raj

Hi,

You should also be looking at the child report. Make sure you are passing Field.<FiledName>.Value from Main report. In Child Report, make sure these parameters are non queried, if Its...

I know this might not fulfill your requriement, you could just Insert table. in Column Expression enter parameter.<parameter Name>.Value

Hope this helps 🙂

Hi,

I see your post is very old, were you able to resolve this issue ?

For Each file works fine for me. Just checking if you follow same steps as I...

Hi,

Could you let please tell the version of DTS/SSIS you are using. If you are using SSIS 2005/2008. There lot more easier way to do this. You could avoid more...

Hi,

I was little puzzled to figure out that having for each loop container, it has to be servername property need to be set instead of connection string or any other...

Hi,

I remember working with Excel files with macros in SQL Server 2000, I didnot had any issue loading this file to SQL. But I used Activex script for loading. I...

Hi There,

If I understand correctly you want child package to inherit values from master package ? If Yes, 2 Solutions.

1) Use Execute package task in Master pkg, in Child when...

I am sorry, little confused with the reply. Could you be specific, what's the input and what needs to be the op with few examples. If the the volume of...

Hi,

I am not sure with this, but it might help you. Try changing the datatype of the column from Varchar to nvarchar. This might help.

Raj

Hi,

Are you missing the path of your file 😉 ?

Raj

Hi,

You should be using derived column transformation, and use substring or available string functions. This would help.

Raj

If you are mapping error output to an error table, yes you could have an row count. Declare a variable in package variable and use this variable in row count...

Would you please mention the tasks you have from the wizard. Ok, here you go. You should be having a task to delete records from the excel. check this task....

Hi,

Would you check for the excel destination connection ? Some times this could also because of Excel version.

Rajesh