May 21, 2013 at 2:23 am
Dear All,
i have task to copy all data from source table to destination table (30 table), so i keep source table name and destination table name in database and use sql statement to get each source table name and destination into variable and use table variable to source table and destination table then I got error VS_NEEDSNEWMETADATA. I try to set delayValidation = TRUE at data flow level and ValidateMetaData = False at Data Source level but error still happened
May 21, 2013 at 2:27 am
waralees (5/21/2013)
Dear All,i have task to copy all data from source table to destination table (30 table), so i keep source table name and destination table name in database and use sql statement to get each source table name and destination into variable and use table variable to source table and destination table then I got error VS_NEEDSNEWMETADATA. I try to set delayValidation = TRUE at data flow level and ValidateMetaData = False at Data Source level but error still happened
I'm not sure what your question is, but I'll make a guess.
If your table structures are different and you are using data flows to copy data, you cannot do this. The column meta data is fixed at design time.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 21, 2013 at 3:02 am
Thanks Phil Parkin, You answer my question. i want to use only one data flow task to copy data from various datasource table to various destination table also by using For loop to change table name.
Do you have any recommend for doing task like this??
May 21, 2013 at 3:14 am
waralees (5/21/2013)
Thanks Phil Parkin, You answer my question. i want to use only one data flow task to copy data from various datasource table to various destination table also by using For loop to change table name.Do you have any recommend for doing task like this??
Doing it elegantly? Not really. You'll probably need one data flow per table.
If this is a one-off, the Import Wizard may be of help in doing some of the grunt work.
If you can install third-party tools (and have the budget), I believe that Cozyroc has a dynamic data flow component which will do what you need. That is not a recommendation, by the way - I have never used it 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply