I have created a ssis package to load the csv file to oracle destination table.
I have a Destination column with a datatype Timestamp(2) with local timezone in oracle table.
My flat file (csv) column value will look like these: "3/1/2011 1:38:32 PM" . I need to provide the datatype manually for the source in the advanced tab of flatfile conn manager to the columns looking at the destination table metadata.
I am using Oracle destination (added as a dataflow item from codeplex) as the oledb destination is not permitting this type of datatype as it says datatype is not supported.
So how can I populate the value. I haven't faced the situation before.
When I use database timestamp(2) with timezone in the source connection manager, it is not matching when it comes to destination.
Could you please guide me.