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 |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2013-05-22 : 03:32:31
|
| Hi,i am loading the data from Excel to Sql server using SSIS packages.i have Single EXCEL file having Mutiple Sheets with same DATA Structures(8 columns).to same table. i have tried this one using ssis variable. that variable i have assigned to one sheet .so only assigned sheet is loading multiple times any one know explain me the exact way of loading.. |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-22 : 03:43:04
|
| You need to make variable dynamic by setting the EvaluateAsExpression to true and set an expression to get correct sheet name. The expression can be based on another variable which gets populated using a query that retrieves sheet names in th excel. Also You will reuire a for each loop for looping through each of the sheetshttp://visakhm.blogspot.in/2012/05/package-to-implement-daily-processing.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
singhvikash
Starting Member
1 Post |
|
|
Angel6666
Starting Member
2 Posts |
|
|
|
|
|
Load Multiple All SHEETS from Single Excel file