September 18, 2008 at 8:47 am
hi
i'm an utter newbie to SSIS (as you can see postcount=1!) but have a background in Access
i'm trying to set up a Data Flow in SSIS to pull data from Oracle to a table on my server...
using a DataReader source component is proving fiddly...
i have set up a connection in connection manager which tests ok (and previously i set up an Execute SQL item that connected and the query parsed ok)
i have set up the DataReader source and used my connection, but it steadfastly refuses to give me columns when i link it to a target and it always says "inconsistent metadata" (whatever that means??)
any suggestions would be more than welcome, i've been stuck for half a day now
:crying:
September 18, 2008 at 9:27 am
Why are you using a datareader source? I'd recommend using the oledb source.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 18, 2008 at 9:40 am
aaah, have just got it to work with OLE after someone from IT laughed at all my work and told me how to do it
thanks 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply