Bill: VSG is the "Visual Schema Generator" available for UniData only. In order for the U2, or any MV dbms for that matter, to be accessed via an SQL type tool (via ODBC or OleDB) you need to "map" the MV data structures into a flat SQL schema. VSG is what's used for UniData and it's pretty easy to use. Setting up UniOleDB is a bit tricky though.
For UniVerse, I don't believe VSG will do you any good. Hope this helps. Bill > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Hazard > Sent: Friday, May 19, 2006 1:32 PM > To: [email protected] > Subject: [U2] Accessing UV Data from Microsoft SSIS in SQL Server 2005 > > Hi All, > I would like to use Microsoft SQL Server Integration Services > to access data in UniVerse. Do any of you have advice on > accessing UV data from SSIS? > > Also, I have found several references to VSG ("Visual Schema > Generator"), but I cannot locate this application anywhere. > Is it of value in preparing for ODBC/OLEDB access? What > product includes VSG? > Thanks for help, > Bill Hazard > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
