October 19, 2012 at 3:00 am
Hi
I have a dataset in the final step of my transform.
currently the data is being put into a table in a database and the next step is a query on that table.
The query is quite complex including window functions and nestings and stuff like that.
I wouldnt have thought this could be done with any ease in transforms, can I query a dataset in a transform?
Thanks in advance
October 19, 2012 at 4:40 am
Can you be a bit more specific?
Are you working with SSIS?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 19, 2012 at 5:10 am
ha sorry yes SSIS
October 19, 2012 at 5:12 am
basically i just want to know if there is a way of querying a recordet i have in a transform as if it were in management studio
and then obviously passing the queried data onto the next transform
thanks in advance
October 19, 2012 at 5:35 am
No, that's not possible.
You can access the data and manipulate it with a script component, but the easiest way would be to write the data to a staging table, run the query on it and load it back into SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 19, 2012 at 5:48 am
thanks for the reply
yeah thats what i am doing currently, i just wondered if there was a way of missing out that step
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply