March 10, 2009 at 7:05 am
Hello All,
i have a issue
Our MMS Agency centers have a file produced by their management system that has dates in the UK format, that is, DD/mm/yy. For some reason, the package won't accept that date format, so they are manually fixing the file so that the date is in US format, or mm/DD/yyyy.
how can we change the date format to US format MM/DD/YYYY automatically in file with in SSIS
Best Regards
asini
March 10, 2009 at 8:03 am
LocaleID property will let you handle such kind of conversions.
On the source flat file connection manager properties set localeid to English (United Kingdom).
Use data conversion transforormation task to convert data into US formart. The localeId property of Data Conversion task should be set to English (United States)
March 10, 2009 at 9:12 am
Hello Jay,
Thank you very much, it works like a charm (this is what exactly i am expecting )
i appreciate your help and i grateful to you
Best Regards
asita
March 10, 2009 at 11:59 am
Hello,
here what i did was, took one Data flow task, in the Data flow task, have one Source file manager (as locale ID=UK) then, Flat file destination (US locale)
when i execute it is creating the files with US date format as specified path in flat file destination (basically both source& destination foloders are different so no problem)
now can any one tell me how can i change source file (or overwrite) i.e,. both source & destination will be only one file (finally after package executes the folder should contain only US format file
please...
Thanks in advance
asini
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply