Hi Koen,

I really have to thank you for all your replies . I have changed the Delayvalidation...

Hi,

WOW! that worked. But i see this error : "[Excel Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the...

--Connection string for Ado.net

ConnectionString : "Data Source=G:\EXCEL TO SSMS\wave2_CM.xls;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=EXCEL 8.0;"

Expression :@[User::FileName]

FileName variable is set with default value "G:\EXCEL TO SSMS\wave2_CM.xls" in variables window.

I have three...

I am using expression do acheive this..I had selected and udated servername as Filename in the properties of the connection managers..Do i need to do any thing else

Regards

Chaithu

Hi,

I am using Microsoft Excel 2010. But i have saved my excel file with extension ".xls" . Also, I have changed Run64bitruntime...

That's where you store them. But where do they come from? I assume the variable doesn't change value by itself?[/quote]

What do you mean by "where do they come from?"...I didnt...

Hi,

I have set the property Run64bitruntime to false..still I do got this error :

[Excel Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. ...

Hi ,

I store sheet names in variable whose scope is at level. I have initilized the first sheet name to the variable.

Hi,

Thanks for Replying..I have read in some post that SSRS 2008 no more uses IIS as hosting server..My Question is ..Where the report gets deployed...

Thanks ...I could able to find out some....

Monster is a major job portal in india too

I am looking for a job in india..

I do have Experience working with C#.net 3.0 and Good understanding of .net Framework..