I had the extreme pleasure recently to extract some data out of an Oracle database. I wrote the source query in Toad, where it executed successfully. I created my SSIS package, added the dataflow and an OLE DB Source component. I copy pasted the query into the editor and tested it using the preview. Which […]
Tag: oracle
Reblog: The OLE DB Source and the Oracle Date Literal
SQLKover update: when of the stranger Oracle issues I encountered over the years. Some time after I published the original blog post, there was a forum question about the same issue. I googled and found my own blog post as the answer. Recently I was developing an SSIS package in BIDS 2008R2 which was part […]