I have a DTS package that is importing an xls file into a sql server database. one of the last steps of the package is to move the file to an archive directory -- the move command is not working because I'm getting the error that 'the connection is still open' to the xls file. any thoughts on how to close the connection to that xls file so that it can be moved to another directory?
Thanks!
Thanks!