Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
goodsolution
Starting Member
38 Posts |
 Posted - 2009-06-19 : 00:43:20
|
| how to write this connection string in an expression?Data Source=@ [User::LatestFile] ;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties="Excel 12.0 Macro;HDR=YES";-Thanks |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-06-19 : 05:31:36
|
| go to the properties of the excel connection string and click on Expressions..Click on the ellipse and you will see a set of properties..Get the Connection String and put the code on the Expression box.. I recommend you also use the Bids Helper (http://www.codeplex.com/bidshelper) when using Expressionshttp://www.sqlserver007.com |
 |
|
|
|
|
|
Expression in SSIS package