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 |
|
wotrac
Yak Posting Veteran
98 Posts |
 Posted - 2005-07-28 : 14:56:36
|
| I am currently designing a package to extract data from an Excelspreadsheet and import into a SQL database. However I want to be able to flag the data in the Excel spreadsheet, so that once extracted, it will be ignored next time the package is run.Is it possible to do a write back to the excel sheet, to exactly the same rows selected in the transformation.Is it just a case of reversing the original transformation, but using a default value of some sort? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-28 : 17:16:46
|
| You could possibly do it that way, but it may be a bit unreliable. To be sure, I would process the transformation task using an ActiveX transformation which would manually update each row as it's transformed. Tim |
 |
|
|
wotrac
Yak Posting Veteran
98 Posts |
Posted - 2005-07-28 : 17:35:31
|
| As DTS is a bit new to me, could you suggest a good source for this type of routine |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-28 : 17:56:07
|
| You might have to do some googling on this. What you're after is not a trivial thing in DTS. Do you have to use DTS? It might be just as quick to write a small .exe that does the same job. |
|
|
|
|
|
|
Excel write back