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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-02-04 : 09:09:36
|
| An excel spreadsheet has to be open on Machine B on the network to pull data from a third party tool.I have to refresh several columns in this spreadsheet every minute with new data.Every time there is a new data into the columns i.e. columns 7 and 10, the spreadsheet pulls data from the third party tool automatically and populates other columns i.e. columns 12-15.Then I will have to retrieve the new data from the spreadsheet into sql server 2005.So first I wrote a query to use to populate the spreadsheet each time with the result using Import Wizard.It gives an error: 0xc0202009And I am not sure if my approach for this project is correct?What do you think?Thanks |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-02-04 : 13:24:53
|
| If there is no presentaion to the users is involved, try to avoid using excel as the middleman during the ETL process.you will have hard time 1) to manage who/which program has the right to write to it at particular moment; and,2) to override excel's own formatting capability. |
 |
|
|
|
|
|
ssis - import-export