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 |
|
tran008
Starting Member
38 Posts |
 Posted - 2005-02-03 : 10:36:04
|
| hello,How would I check from DTS to see if the Excel sheet is open by another user and close the user out before the package transfer? thanks |
|
|
bmains
Starting Member
27 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-03 : 20:00:05
|
| I would suggest NOT exporting data via DTS into a live workbook. Export to an isolated workbook and copy the file to its final destination. Even if you COULD determine if someone was using it, you won't be able to kick them out. It's much easier to do it the other way. |
 |
|
|
|
|
|
dts to Excel sheet...