Thanks Jeff, I might give that a try. Even though the creating views bit doesn't sound too appealing.
I actually have been thinking to start off by leaving it as is and pull the data from SS 2000 instead of UD 5.2 directly since the table structure is exactly the same and the updating of the SS 2000 tables with DTS every night is so far working OK. Once I get the upgrade to 7.2 done, I will have the SSIS projects for the datawarehouse all in place, only need to change the data source and everything should be working just fine. Mecki -------- Original-Nachricht -------- > Datum: Thu, 14 Jan 2010 08:43:06 -0500 > Von: "Lettau, Jeff" <[email protected]> > An: U2 Users List <[email protected]> > Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad] > You may not want to do this due to volume of data your trying to pull, > but... > > Have you tried setting up your UD5.2 server as a linked server in SQL, > then creating views to your linked server. Then use SSIS to pull from the > views, that way it doesn't know it isn't a SQL data source? > > Performance isn't bad if your limiting your I-desc and keep the data to > single files in UD. Also use indexes in your UD views to limit your data. > You can't pass variables for data selection this way. You can limit data by > day using @date-99 type i-descriptors or just write a quick program to > pull your data to a temp file, then pull the file for updating things > incrementally for Cognos. > > Jeffrey Lettau -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
