So I have a very simple package I have created, all it does is look in a folder for any csv files and then import the file to a table and then delete the csv file. When I run it in BIDS its absolutely fine. When I try and import the package into SQL management studio as a job the job reports it successfully completed but none of the data is being imported into the table. I don’t know why none of the data is being imported can anyone shed any light.