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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-05-05 : 11:00:24
|
| Hi,I'm using the excel connection manager and trying to import the data from Excel to OLEDB Destination using DataFlow Task.My requirement is I want the Name of the sheet should be named as "UploadDataSheet" during the runtime i.e. whatever may be the excel sheet name, i need to change it to "UploadDatasheet" name and import the data.Your help is highly appreciated.Thanks in advance. |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-05-06 : 01:30:39
|
| Any help guys? |
 |
|
|
|
|
|
Excel Sheet - rename during the runtime