SSIS Package - detect if Excel is empty

• elenad.ungureanu

  SSC Enthusiast

  Points: 183

  More actions

  August 18, 2015 at 5:32 am

  #299784

  Hi,

  I have a SSIS Package that imports data from Excel into a database. Also, in SSMS i have a job that runs the package every 24 hours. The job fails when the Excel is empty ( It can be empty because it contains the updated records from a Share Point list, but for example in weekend the data is not updated).

  How can i detect if the Excel file is empty or not? And if it's empty, to stop the running of the package, and if it's not empty to continue importing the data?

  Any ideas?

  Thank you!

• michal.lisinski

  SSCertifiable

  Points: 7201

  More actions

  August 20, 2015 at 3:07 am

  #1821297

  Hi

  My package uploads documents (pdf) into repository, sometimes files are empty, so I check the size of

  file thru the Script Task to exclude them from import . Please refer FileInfo Class https://msdn.microsoft.com/en-us/library/system.io.fileinfo%28v=vs.110%29.aspx

  Regards

  Mike