Nope, did not work. Thanks for your help though. Happy New Year to you all and may you grow very rich <smile>.
I got this line from Perl Cookbook. Here's what the CookBook says:
========================
% perl -pi.orig -e 's/DATE/localtime/e'
will be executed as:
while (<>) {
if ($ARGV...
Hi,
I am trying to switch all occurences of the word "OLD" to "NEW" using either of the following simple commands, but my FILE.TXT does not change. What am I doing wrong? Neither of these commands seem to work. They do create a FILE.TXT.orig though.
>perl -i.orig -pe 's/OLD/NEW/e' FILE.TXT...
I think you will have to write VB script into your DTS to format dates strings. I don't have sample code but there should be lots in SQL programming forum.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.