November 7, 2012 at 4:56 am
Hi Guys,
I want to perform a task.
I want to insert the table name of the destination tables to the another table
My Source : Excel
My Destination : Sql Server (OLEDB)
how to do this..
Like i have inserted the rowcount of the inserted data of the destination table to the another table...
plzz help me on this..
November 8, 2012 at 12:59 am
How do you configure the destination table? Is it fixed in the package or dynamic?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 8, 2012 at 5:24 am
Dyanmic...
If it was fixed then i wud have hardcore the table name and insert but it is dynamic
November 8, 2012 at 5:43 am
farooq.hbs (11/8/2012)
Dyanmic...If it was fixed then i wud have hardcore the table name and insert but it is dynamic
OK, and how do you configure the tablename?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 8, 2012 at 5:49 am
It is something like this...
In the Execute SQL task, Should configure this..
Name of the table of the data flow task and row_count of the insertion took place for everytable into another name..
I done with the destination rowcount insertion to another table but same like need to configure the table name of the destiantion
November 8, 2012 at 6:07 am
I'll ask it again. You said you configure your destination in the dataflow dynamically.
My question was: how?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 8, 2012 at 7:59 am
farooq.hbs (11/8/2012)
Dyanmic...If it was fixed then i wud have hardcore the table name and insert but it is dynamic
Hardcore table names? I'm thinking your mind isn't 100% focused on ETL ... 🙂
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 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply