Importing data from oracle into SSIS
Hello, hope this is an ok forum to adress my issue...
I have created a table in sql developer (oracle), it consists of 7 rows. Some of the columns contain no information (i.e. null value). I have created a data flow to import the data into SSIS and then create a flat fuile (csv-file) which will contain the data rows from the tabel in oracle environment.
The problem is that no data is imported into the OLE DB Source, I cannot understand why. I have done this for other tables, and it works there. The only difference is that these rows contains null value.
Any light on this issue would be greatly appreciated.
best regards
Harald