Microsoft Great Plain integration application and new tables on sql

In dexterity iam using table_compare() function to check if tables in datasource and dictionary are same but its not picking up the primary key change but it does pick up the column change

any suggestion

thanks

This forum is for SQL Server Integration Services. Are you trying to integrate Great Plains with another system via SQL Server Integration Services? I read your question as being about Great Plains only, so this is probably not a good forum, you may have better luck on a Great Plains specific forum.

Microsoft Data Analyzer

I have downloaded Microsoft Data Analyzer and it is
asking for a CUBE on online OLAP server. Is there anyway
to connect it to Data in a plain 2000 SQL server.
if I do need OLAP what do I need to install on my SQL
server
Thanks
Steven Hill wrote:
> I have downloaded Microsoft Data Analyzer and it is
> asking for a CUBE on online OLAP server. Is there anyway
> to connect it to Data in a plain 2000 SQL server.
> if I do need OLAP what do I need to install on my SQL
> server
You need to have OLAP services installed on your SQL Server. From MDA FAQ -
OLAP refers to an online analytical processing database capable of handling
queries more complex than those handled by standard relational databases. It
does this through multidimensional access to data, intensive calculation
capability, and specialized indexing techniques. To learn more about this
technology, visit the OLAP and Data Mining page
(http://msdn.microsoft.com/library/de...-us/createdw/c
reatedw_1vqf.asp) on the MSDN site.
sincerely,
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.
sql