Post reply

Executing SSIS in SQL as a job reports successful but nothing happens

  • July 27, 2011 at 3:41 am

    #390059

    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.

  • July 27, 2011 at 4:09 am

    #1359037

    Possible because the SQL Server Agent service account doesn't have access to the location of the csv file.

    John

  • July 27, 2011 at 4:39 am

    #1359052

    Ahhh of course, spot on thanks. Rookie mistake :Whistling:

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply