December 4, 2008 at 4:40 am
hi frnds
i have one column "Date_Value" having dates in "dd/MM/yyyy" coming from Source File of EXCEL.(Data Type - "DATE")
i am transfering this data of EXCEL source file , into Destinetion of MS-ACCESS table by using SSIS.
now before Loading the Data into Destinetion file i want to validate the data coming from the Column " Date_Value" , that date format should be in "dd/MM/yyyy" .
i am using Script component to validate date this column data..
so problem is that i am not able to compare its format..
validation is only whn the data is in the "dd/MM/yyyy" otherwise redirect to Error file.
Please help to resolve this issue.
December 4, 2008 at 5:20 am
You should use a data-conversion transformation instead of the script, as this date is in a standard format the data-conversion will re-direct any rows that are not valid dates. You can set up this re-direction to a file and then review the bad dates.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply