SSIS Source Script Component won't let me set output column data type

Question

SSIS Source Script Component won't let me set output column data type

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Norman Kelm SSCommitted Points: 1922 More actions · Answer 1

Hi Derek,

Is there a reason that an OLEDB source with the Oracle OLEDB privder was not used in the transformation? It has the capability to have a query as the Data Access Mode.

Norman

DTS Package Search

http://www.dtspackagesearch.com/

derekmallard SSC Veteran Points: 256 More actions · Answer 2

I was not using the OLE DB source because I could not see how to make it use the

database link that in turn connects me to the DB2 database on the mainframe.

The mainframe DB2 database does not have a listener that supports a network

connection other than the Oracle agent that is running on the mainframe in support of

the Oracle transparent gateway.

All I saw when using the OLE DB source is the ability to pick which table to access.

That all said, I just took a closer look due to your question.

Turns out I can set the OpenRowset to sqlprod.emp@sqlflc when using the advanced editor.

Thanks for prodding me along. 🙂

This will probably meet my needs.

Derek

Norman Kelm SSCommitted Points: 1922 More actions · Answer 3

Derek,

Looks like you made it, but not where I was "prodding"

On the "standard" OLEDB property editor there should be four items on the Data Access Mode drop down. One of them should be SQL Command. I would hope you could have pasted your query in there dblink or no dblink.

Norman

DTS Package Search

http://www.dtspackagesearch.com/

derekmallard SSC Veteran Points: 256 More actions · Answer 4

Yep, that's exactly where I ended up as I looked closer at that data access mode field.

derek