SQL 2005: SSIS QUERY
Posted on 2011-09-06
i am currently developing my first package in ssis, one element of the package is a data flow task that uses an ole db source - which points towards an excel file - thinking being that it will pick up this file when its saved in the correct location process it accordingly and move the file when fisnished
this is all working perfectly in debug, until when the excel document isnt there - it then gives back an error!
how would i best achieve this process? eg i will want to check the folder daily and if its not there simply do nothing and return no errors..