February 10, 2009 at 2:43 am
eg i want to output a new table everytime the code is run showing as part of the tablename the date the code was run..
thanks
February 10, 2009 at 9:25 am
Can you give some more details about how you are doing it? I believe what you are looking for is the ability to use a variable to set the Destination table which is possible. Select Table or View Name variable as Data Access Mode in the destination. I think you would want to actually create the table in a prior step though. I've never tried using a variable for the table name.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 10, 2009 at 9:28 am
Hi, I want to import a csv file then transform the output so it ends up in an sql table. I want to name the sql table according to the date ie Consumer02092009
thanks..
Fiona
February 10, 2009 at 9:54 am
Here's a flow of how I would do it with what I know about SSIS now (meaning there may be a better way):
Package Variable for table name
Script Task that populates the variable name
Execute SQL Task that creates the table
Data Flow Task
Any transforms needed
Destination Set to use the variable as the table name
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply