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 

I have been unable locate any documentation regarding UniOleDB and file name 

Has anybody else discovered similar discrepancies?


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

Reply via email to