close a connection ssis

• kjabbar

  SSC Veteran

  Points: 215

  More actions

  June 12, 2008 at 1:21 pm

  #129522

  Hello,

  I have a one Excel file with two sheets.

  (Sheet1 and Sheet2)

  Sheet1 has the data I am going to upload into an Oracle table.

  Sheet2 has the email addresses in each row for the SendMail task to use.

  If I try to delete the Excel file after the For Each Loop fails

  caused by the SendMail task when an email address is wrong.

  [File System Task] Error: An error occurred with the following error message: "The process cannot access the file 'C:\Inetpub\ftproot\quality\quality_block\LNVQUALITYBLOCK.xls' because it is being used by another process.".

  How do I delete the Excel file after it has gone through all the email address?

  Thanks

  KJ

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  June 13, 2008 at 4:06 am

  #828333

  Use a file system task. One of the features is that it can delete files

  ~PD