January 13, 2013 at 3:40 pm
I need help understand how to use the Script Component to create a connection to the database, submit a SQL, retrieve the results. Are there any good tutorials?
I would like to use the script component basically as a lookup to incoming rows. I have to perform numerous lookup and thought this approach of using script components would allow me to do this. Also, it would allow me to perform additional steps, where I need to built up a field as a result of the lookups.
Any help would be appreciated.
January 15, 2013 at 2:16 am
You can use SQLCommand or other relevant classes.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2013 at 3:42 am
Koen Verbeeck (1/15/2013)
You can use SQLCommand or other relevant classes.
You missed the obvious question: why use a script component to do lookups when there is already a dedicated lookup component?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
January 15, 2013 at 3:46 am
Phil Parkin (1/15/2013)
You missed the obvious question: why use a script component to do lookups when there is already a dedicated lookup component?
To quote the OP:
to perform additional steps, where I need to built up a field as a result of the lookups.
But you're right, if a traditional lookup can be used, by all means, please do so.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2013 at 3:50 am
Koen Verbeeck (1/15/2013)
Phil Parkin (1/15/2013)
You missed the obvious question: why use a script component to do lookups when there is already a dedicated lookup component?
To quote the OP:
to perform additional steps, where I need to built up a field as a result of the lookups.
But you're right, if a traditional lookup can be used, by all means, please do so.
Fair enough. I think we need to understand the problem/requirement better before knowing whether it's possible using lookups (and maybe derived columns) or not ...
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply