I have a DTS package to export the data to an MS-Excel file. How can I make sure that the Excel sheet is not open another user, and get a lock on the excel file until the DTS transfer is complete?
I found that having DTS create a table and then linking to that table from Excel workd great. You can always have excel set up to create a permanent copy of the data within the Excel spreadsheet if you like.
Eric
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply