importing data from interbase
I'm trying to write a integration services package with interbase involved in it.
Set up a DataReaderSource with a totally basic sqlcommand: select * from BDR, connect to Interbase using ADO.NET.
Unfortunately I'm getting an error :
"Error at Data Task [DTS.Pipeline]: The "output column "TIME (50)""has a length that is not valid. The length must be between 0 and 4000."
I got the same problem with six different columns.
Each time a change the data type in the input or output proporties I get an Error :
Invalid Data Type.
Do Anybody have an Idea how to solve this kind of problem ?
Is there a possibility to convert the data in the DataReaderSource ?
I really got stuck and still looking for any solution ...
I'll be gratefull if someone could give me clue.
Hope to hear from You.
