Search results

  1. S

    DTS Package - XLS File Connection Stays Open - How to close?

    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...
  2. S

    DTS Package - How to prevent a 0 byte file?

    I've created a DTS package -- that uses a query to export to a .txt file. My question is -- if the results of this query are zero (no results returned within the package ) -- how can I tell the package not to export a zero byte file. Any thoughts on that? Any help you could give would be greatly...
Back
Top