DTS Package and Access

• Tom Brackney

  SSC Veteran

  Points: 245

  More actions

  September 16, 2004 at 10:30 am

  #66208

  Using a DTS Package is there a way to automate the running of a DTS Package that needs to get data from the only table in Access to SQLServer. The access database table will have a different name every month. I currently have a DTS Package that will grab the data in the table and put it into a SQL Server table. My problem is I would like to automate this but I need to set the table name every time in the transformation properties since the name changes every month. Can anyone help?

  Tom

• richardshields

  Old Hand

  Points: 381

  More actions

  September 17, 2004 at 7:24 am

  #523487

  Not sure if this approach would work for you...

  Can you use Access to duplicate the data in the source table into another table with a name that doesn't change (e.g. ThisMonthsStuff).

  That way there would be no need to change the current DTS package.

  Richard