Tim Mullady
asked on
SSIS - excel connection string parameter
Hello,
I'm trying to implement a SSIS ETL to import excel files into a DB. I keep getting the following message with the excel connection variable:
Current variable
@[User::FileFullPath]
Evaluate Expression
C:\Users\jmullen\Desktop\Input\
I believe I need to change it to something like this:
Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\Users\jmullen\Desktop\Input\;Extended Properties="EXCEL 12.0 XML;HDR=YES";
Can someone help me write the expression for this? I'm not too familiar with SSIS expression formats and strings. I'm assuming that I need to add pieces of strings to the Excel expression.
Thanks,
Tim
I'm trying to implement a SSIS ETL to import excel files into a DB. I keep getting the following message with the excel connection variable:
"It must consist of one or more components of the form X=Y, separated by semicolons...."
Current variable
@[User::FileFullPath]
Evaluate Expression
C:\Users\jmullen\Desktop\Input\
I believe I need to change it to something like this:
Provider=Microsoft.ACE.OLEDB.16.0;Data Source=C:\Users\jmullen\Desktop\Input\;Extended Properties="EXCEL 12.0 XML;HDR=YES";
Can someone help me write the expression for this? I'm not too familiar with SSIS expression formats and strings. I'm assuming that I need to add pieces of strings to the Excel expression.
Thanks,
Tim
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
How does Excel Input component look like?
Can you please send us a picture about your SSIS package and the list of variables?