February 3, 2005 at 8:56 am
Hi all,
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?
thanks
February 3, 2005 at 9:10 am
As far as I know you cannot.
Only hint I can give is to export data to another excel file and run a copy job overnight.
February 4, 2005 at 4:50 am
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy