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 |
|
murrayb3024
Yak Posting Veteran
79 Posts |
 Posted - 2005-03-24 : 16:14:53
|
| I am using an Excel Spreadsheet as a source in the Data Transfer. I get a report put in the same location by the user. The report is always in the same format. The name of the report is always different, but I worked around this. My next problem is that reports tab in the bottom of Excel is a different name, after each day of the week. So on the Sunday excel sheet, the tab is called Sunday, and on the Tuesday spreadsheet, it is Tuesday. So when I try to move from one to the other it can't find the data. For testing I manaually changed the tabs in my sample docs to the same thing. Is going to the person who pumps out this report and having them change that to be the same my only solution, or is there another option? |
|
|
murrayb3024
Yak Posting Veteran
79 Posts |
Posted - 2005-03-25 : 12:17:32
|
| I take it naming the worksheet tab the same name on every document is my only option. |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-03-25 : 12:54:10
|
| You could write a job that uses BCP to pull in your file instead and use some sql to figure out the name of the day so you don't have to baby sit it.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Problem using Excel as Source in DTS