Bulk load using SSIS - manipulate column

[Scott249]

Hi you all,

I'm a new programmer and new to SSIS.
I have this project to load csv file into an oracle database. I'm using SSIS to load data into an oracle table. So far it's working. My problem is one of the column ( datatype - datetime) needs adjustment. I need to adjust the column data into Pacific Time and Mountain Time.

The original csv file is in Eastern Time. I want to use one of the " Store_number as the basis of transaformation"

Ex: store 10-50 ( Pacific Time)
Store 60-100 (Mountain Time)

How do I do this? I read that I need to write scripts but its too complicated for me. i'm comfortable using derived column to manipulate the column data. Would someone help me with this? Sample work would be appreciated. thanks a lot

 

[SQLScholar]

I am not 100% sure how it will work in Oracle - but normally i would use the data conversion tool, between the source and destination.



----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------