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 |
|
learntsql
524 Posts |
 Posted - 2009-12-09 : 03:26:01
|
| Hi..How to pass the Excel path and Sheet name(values in SQL table) as variables to load Excel sheets data to SQL server table.or any other ways other than ssis. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-12-10 : 13:57:37
|
| you need to create variables inside ssis to hold value and you may add evaluate as expression property for them if they need to be determined at run time based on an expression. then map them to relevant property of task using expression builder in property expression editor |
 |
|
|
learntsql
524 Posts |
Posted - 2009-12-10 : 22:27:06
|
| Thanks Visakh16,Could you plz. provide any links. |
|
|
|
|
|
|
Pass Path as variable for Excel Import