May 3, 2011 at 1:33 pm
Hi,
In a SSIS package, I am getting the output to a table named query.
Now, I want to transform the data or I should say I want to put t-sql code( many updates,joins) to the table named query and then put the results into anohter table.
Which tool in SSIS i should use for doing this?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 4, 2011 at 12:18 am
What is a table named query?
I only know about named queries in SSAS, so I'm not sure what it has to do with SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 4, 2011 at 2:38 am
If I read this literally, I come to the conclusion that data has been imported to a table whose name is 'query', which is somewhat confusing, to say the least!
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 4, 2011 at 6:49 am
@ phil
Exactly
Regards
Sushant Kumar
MCTS,MCP
May 4, 2011 at 6:51 am
Koen Verbeeck (5/4/2011)
What is a table named query?I only know about named queries in SSAS, so I'm not sure what it has to do with SSIS.
When I import data from another server, then the default name SSIS gives is Query.
But, I dont know, wat has table name to do wid all this...I wish i wouldn't have mentioned the table name
in the first instance.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 4, 2011 at 6:59 am
So you have data in one table, you want to manipulate it with TSQL and put the results in another table.
I would use an Execute SQL Task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 4, 2011 at 7:11 am
Koen Verbeeck (5/4/2011)
So you have data in one table, you want to manipulate it with TSQL and put the results in another table.I would use an Execute SQL Task.
Why does execute SQL task doesn't come under data flow task...
That means I have to put it under Control flow task...
But the output query is under Data flow..
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 4, 2011 at 9:12 am
SKYBVI (5/4/2011)
Koen Verbeeck (5/4/2011)
So you have data in one table, you want to manipulate it with TSQL and put the results in another table.I would use an Execute SQL Task.
Why does execute SQL task doesn't come under data flow task...
That means I have to put it under Control flow task...
But the output query is under Data flow..
Regards,
Sushant
If you are transferring data from one table to another, an INSERT query will do the work for you in a fast set-based fashion - it is a one-hit operation and there is therefore no data flow and no data pipeline.
What do you mean by 'output query'?
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 4, 2011 at 10:32 am
Phil Parkin (5/4/2011)
SKYBVI (5/4/2011)
Koen Verbeeck (5/4/2011)
So you have data in one table, you want to manipulate it with TSQL and put the results in another table.I would use an Execute SQL Task.
Why does execute SQL task doesn't come under data flow task...
That means I have to put it under Control flow task...
But the output query is under Data flow..
Regards,
Sushant
If you are transferring data from one table to another, an INSERT query will do the work for you in a fast set-based fashion - it is a one-hit operation and there is therefore no data flow and no data pipeline.
What do you mean by 'output query'?
By output query I mean the table output (query) from which I have to do the transformation. It is the source of data for me.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
May 4, 2011 at 11:31 pm
Your explanation is very confusing. You should get your syntax straight.
If you want to do some transformations on the table, create a new dataflow, use that table as source for the OLE DB Source, add your transformations and write the results to the database with the OLE DB Destination.
If you want to do the transformations with TSQL, use an Execute SQL Task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply