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!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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