Set Variable Dlm SSIS Command Line

/SET "\Package.Variables[User::gvSourceId].Value";101

String Convert Dlm SSIS

(DT_STR,4,1252) DATEPART(yyyy,date)

Login through ssh using no password

1. a@A:~> ssh-keygen -t rsa local pc
2. cat .ssh/id_rsa.pub | ssh b@B 'cat >> .ssh/authorized_keys' local pc

ETL

1. Table dari datasert asal

PHP + Oracle

1. Uncomment the line: extension=php_oci8.dll

2. $db = “(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.34)(PORT = 1521)))(CONNECT_DATA=(SID=orcl)))” ;

   if ($c=OCILogon(”system”, “your database password“, $db)) {

   echo “Successfully connected to Oracle.\n”;

   OCILogoff($c);

   } else {

   $err = OCIError();

   echo “Connection failed.” . $err[text];

   }

   ?>

SCP then gzip file

1. scp remote/dir /locadir | gzip -f
2. tar cvf - . | gzip -c -1 | ssh user@host cat ">" remotefile.gz

Piping Dalam Linux

tar -cvf - /usr | ssh root@lnx_srv "cat > /dev/st1"