Recent content by denis60

Can we preroute a tcp port to a ssh port with the same line of command: ex.: iptables -t nat -A PREROUTING -i ppp0 -p tcp --dport 21 -j -s 10.1.1.0 DNAT --to-destination new_server_address:22

Thanks so much QatQat. I'll try as soon as possible :)

Hi! Is it possible to reroute an incoming ftp connection to an other server from a specific ip address. Thanks in advanced

To flora9090 What i mean is: i receive (sql server) many text file in csv format from a linux server. Those files have to be push in 1 table. I'm new with store procedure could you tell me more. Thanks also to cmmsi for your help.

Hi! I did a dts task importing 1 file to a table with the text file souce connection, but how to import multi text files in 1 table. I tried with the execute process task (with a dos batch) copy append to 1 file. It work fine but i don't know how to return code to validate. Help please!

Hi! everyone I'm a newbe in SQL server 2000. I need help on how could be the best way to transfer data (+10,000 lines) from a linux server to a SQL 2000 server (some codes would be appreciate). Here the step i'm thinking about: 1- Server linux send each 10 minutes a text file with data for...

I receive text file containing file name with $ at time and i have to manipulte them. Thanks for your help...

How can i do that when the $ is not always there. Is it possible to have an exemple?

Sorry The variable $tst could have more than 1 expression. ex.: $tst="2->DATA$\n2->data1$\nn2->data2$\n";

Hi! I'm trying to match a variable containing a $(dollar sign) and it fail, like $tst="2->DATA$\n"; $tst1='2->DATA$'; if($tst =~ $tst1){print "yes\n"}else{print "no\n"}; These 2 variables are here to represent data capture in 2 files and compare. How to fix it ??? Thanks in advance for your help

Ok fishiface your script work fine thanks. I was trying many thing in same time and your solution was too close of my nose... i didn't see it sorry. For the binmode way, i don't know how to use it with a compress file. Thanks all for your help and supports.

Sorry i did a mistake I tried something else: #!/usr/bin/perl $var="/home/denis/jf/jftemp/240DU050725230311JF.Z"; open(IN,"zcat $var|") or warn "error"; print "file opened\n"; print $var=<IN>; close IN; print "end\n"; and the answer is: zcat: /home/denis/jf/jftemp/240DU050725230311JF.Z...

Hi! I have a corrupted compressed file. It opened well but after reading 3 lines it failed and return: zcat: /home/denis/jf/jftemp/240DU050725230311JF.Z: corrupt input. How can i control the error message. Here my script: #!/usr/bin/perl $var="/home/denis/jf/jftemp/240DU050725230311JF.Z"...

Duncan it's work well with a \E at the end of the variable like \Q$var\E Thanks a lot Your the best

Yes it work with single quote, but the $rwrd variable come from a substr and i think the data in it is like $rwrd = "$123" and it fail...Sorry.