Uniiverse 10.2.4 AIX Unix 5.3 We have been using UniODBC to run our DTS jobs (to our DataWarehouse) since before I began working here. I have been told by our VAR that our setup is not typical. We are now attempting to change from UniODBC to UniOleDB using SSIS.
The problem that I am encountering is the SQL statement will not recognize the visible files in the same manner. We have a file MO-GL-DET and using ODBC, we have to refer to the file as MO_GL_DET in the SQL statement. But with the OleDB connection the file does not exist. I created a new voc (alias) without the hyphens (MOGLDET) and everything works (even without running HS.UPDATE.FILEINFO). I have been unable locate any documentation regarding UniOleDB and file name constraints. Has anybody else discovered similar discrepancies? Vance ________________________________ CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users