Need to check existence of an msaccess table and if it not exists create it using ssis

• pvsrpk

  SSChasing Mays

  Points: 602

  More actions

  November 5, 2015 at 7:01 am

  #322360

  Hi,

  I have an access file which will be my destination.

  Daily a job runs which fills the data in this MS access db (say XYZ.mdb) in a seperate table (say ABC). the table name is appended with current date (like ABC11-01-2015)

  Now in ssis task, I need to check the existance of this table (ABC11-01-2015) and drop if exists and Recreate this table .

  I tried using execute sql task with OLEDB for access as conn manager and query via variable, but its not working.

  Can some one guide me to accomplish this.

  Thanks

• pharmkittie

  SSCertifiable

  Points: 5775

  More actions

  November 6, 2015 at 2:39 pm

  #1838355

  In what way isn't it working? Did you see any error messages? Here's a link but I'm not sure if it applies to your situation: Access/SSIS[/url]

• Alexander Suprun

  SSCertifiable

  Points: 6253

  More actions

  November 6, 2015 at 4:52 pm

  #1838369

  That's a very common error :hehe:

  

  ---

  Alex Suprun