Dynamic query in SSIS

• Binoj-427413

  Newbie

  Points: 5

  More actions

  May 27, 2008 at 10:17 am

  #187175

  I'm new to SSIS.i need to upload few acces files to SQL server-2005 database every month.i want to create a SSIS packge which should read files from a specific folder and create the tables.each time ,when i execute the package the table name should create dynamically which should conatain month and year at the end.(eg:tbl_052008).how is it possible?Please help me..

• maya potiyevskaya

  SSCrazy

  Points: 2091

  More actions

  May 27, 2008 at 3:27 pm

  #820863

  seems like you need to create a variable in your package called, let's say, @fileName. then, assign a value to it dynamically.

• Mark Beringer-730383

  SSCommitted

  Points: 1824

  More actions

  May 28, 2008 at 2:08 am

  #821018

  You will need to use expressions to update the variable and properties of your package. Read up on Expressions in SSIS.