I'm making the assumption that the UV server is on Unix, and the SQL server is on ... Well, windows.
Using perl, there is nothing that needs to be added to the windows system, or any configuration changes (other than allowing the IP of the unix machine to connect and/or with a particular username). Nor, any services to start or schedule to read the flat files into MSSQL No ODBC's to install on unix or windows that are not already there. Create a VOC pointer to /tmp for instance Write out a flat file to that VOC FILE SH -c 'perl uploadfile.pl -f filenameintmp' George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Bob Witney > > MS BIZTALK WORKS FOR US > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of George > Gallen > > Another option would be export a flat file, and use a perl to read the > flat file, > log on to the SQL server and update the database as needed. This way > you don't > need anyone to import the data, you can have the UV program that > creates the > data, trigger the perl program to send it along using standard perl > modules. > > The perl program to logon to SQL and issue SQL commands is simple > enough. > > George > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
