Connection string Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Imports\2011-11-14\Data.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1"; Error Parsing the expression "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Imports\2011-11-14\Data.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";" failed. The equal sign (=) at line number "1", character number "9", was not expected. A double equals sign (==) may be required at the location specified. (Microsoft.DataTransformationServices.Controls) What am I doing wrong ?

Are you wrapping the expression with double quotes?

Connection string Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Imports\2011-11-14\Data.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1"; This is the way I am putting it in ? Where should I be putting in double quotes.

Hi i am not exactly sure about the issue. i can see one website where connection strings can be seen for each data providers and adapters. Check the site http://www.connectionstrings.com/ Hope this may be useful. Thanks Karthikeyan Anbarasan http://f5debug.net/

Hi SSIS User2011, Please refer to the following article about Connection String in SSIS, ConnectionManager.ConnectionString Property: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.connectionmanager.connectionstring.aspx And here is a good article about the topic, please see: Use Connections Properly in an SSIS Script Task: http://toddmcdermid.blogspot.com/2011/05/use-connections-properly-in-ssis-script.html Thanks, Eileen

Hi SSIS User2011, Please refer to the following article about Connection String in SSIS, ConnectionManager.ConnectionString Property: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.connectionmanager.connectionstring.aspx And here is a good article about the topic, please see: Use Connections Properly in an SSIS Script Task: http://toddmcdermid.blogspot.com/2011/05/use-connections-properly-in-ssis-script.html Thanks, Eileen

Problem not SOLVED yet . Is there no Connection String guru out there that can solve this ?

Put the following in your expression (include the leading and ending double quotes): " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\\Imports\\2011-11-14\\Data.xlsx;Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\"; "