May 7, 2012 at 4:26 am
Hi guys i have one question are ssis package in sql server 2005 can take data from more tables in database to another that i know it take data from tables or view and if possible how
May 7, 2012 at 11:29 am
Yes, using dataflow tasks.
Sounds like you might have some reading up to do!
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 8, 2012 at 3:42 am
If I understood you correctly, the easiest way to get there is to use "SQL Command".
Use a Data Flow Task and then choose a source you want (probably OLE DB Source). Then you need to pick "SQL Command" data access mode instead of "Table or view", and choose "Build Query". There you can add tables and choose which columns to add to your query.
May 8, 2012 at 8:36 am
Yes, that is correct. I believe in your reading it will suggest using a SQL Command ALWAYS even in cases where you only want to read from a single table.
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply