May 27, 2008 at 10:17 am
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..
May 27, 2008 at 3:27 pm
seems like you need to create a variable in your package called, let's say, @fileName. then, assign a value to it dynamically.
May 28, 2008 at 2:08 am
You will need to use expressions to update the variable and properties of your package. Read up on Expressions in SSIS.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply