i have a datecolumn 2055/12/09 with date datatype i have to populate to target datatype timestamp i.e to MSOLEDB but it is comming as 2055/00/00 i have tried 2055/00/00 : " " : Oconv( Time(), "MTS:" ) and
2055/00/00 :00:00:00 but it is not working
2.And i have to check a date if it is valid i have to load to target date datatype is date(8)
From what it looks like your date datatype is of length 8 and you are trying to insert data whose length is greater than that. That is where you will need to look at. or are your point 1 and 2 two different scenarios?
What is your source and target???
The date format seems to be ok.And if Oconv(Time(), MTS) is giving you all zeros, then there is something else going on. Try loading the output to a flat file and check the format.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
first and second points are different scenarios my source is sequential file and target is msoledb stage. when iam loading to flatfile it is working fine but it is coming as 2500/00/00 :00:00 when i am loading to database stage