February 21, 2011 at 3:17 am
Hi All
Maybe very easy 1 this, On my PC I always have the regional settings, set to yyyy/mm/dd, now the SSIS pacakge might be run on a different PC as well, with regional settings set to maybe mm-dd-yyyy.
In my script I want to rename a text file and then move it to the archive folder.
If the reginal settings is set to the second version I'm going to land up with a file where the format is going to be "mmddyyyy file.txt"
How can I ensure that the date will be in the yyyymmdd format, seeing that in SQL server I can use the convert function with parameter 121 but I cant seem to find anything for SSIS script component
I'm using
sDate = Replace(Convert.ToString(Today()), "/", "")
to return the string of date
February 21, 2011 at 4:16 am
You could try playing around with custom date formats where you specify the format in code, eg
Now.Date.ToString("yyyyMMdd")
February 21, 2011 at 5:20 am
Thanks Phil!
You are never to old to learn something new. I didnt even know about the now.date
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply