November 15, 2010 at 6:33 am
hi
i have an Oracle view, which needs
ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN'
to be run in the session before i do my select statement, otherwise it returns zero rows
fine...but am struggling to pull the rows via SSIS
have tried:-
1) writing both bits of sql into one. failed, syntax, not sure it's possible
2) doing an execute sql task to run the language settings before the data flow. failed due to presumably the session ending before it opens up the second box
i could try and fix this on the Oracle side of things, but i wondered if anyone had any ideas to try in SSIS
ta
November 15, 2010 at 12:16 pm
Can you try option 2 again, but now with the RetainSameConnection property of the connection manager set to True?
With a little luck, that should work 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 16, 2010 at 2:05 am
da-zero (11/15/2010)
Can you try option 2 again, but now with the RetainSameConnection property of the connection manager set to True?With a little luck, that should work 🙂
yeeeeeeeeeeeeeeeeeeeees!
you sir are a god amongst men
damn, i tried mucking about with the task properties looking for something like that and didn't even think to go for the connection properties
🙂
November 16, 2010 at 2:25 am
oliverpenney (11/16/2010)
you sir are a god amongst men
I hear that from time to time 😀
(just kidding of course)
Glad that it worked out.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply