DTS Package - variable Table Name

Hi,

I have created a DTS Package which copies data from a Access Database table to a SQL Server table. The DTS Package is scheduled to execute every 15 minutes. Everyday the source table name will change. Is there a way to reset the source table name everyday without changing it through DTS wizard.

Thanks,

Vivek Gupta

Yes it is possible, you can try to read data table name from input parameters, and pass your parameters on each DTS run from you SQL Job agent.

Thanks