Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extract array data from Vantage 8.03 into SQL Server 2008

Status
Not open for further replies.
QueenKirsty

QueenKirsty

Programmer
Jul 21, 2010
1
I am trying to extract data from the Progress DB on the back end of Vantage 8.03 into SQL Server 2008 for analysis. The data I need is in Progress array fields that SQL Server can't seem to read.

I currently have the Progress DB as a linked server in my SQL Server instance and can read from the tables where the fields are not arrays.

Does anyone know how to extract the data from the array fields using TSQL stored procedures or the like?
 
Status
Not open for further replies.

Similar threads

wilsomgai
  • Locked
  • Question
our XL Connect cannot reflect the most updated data of Epicor
Replies
0
Views
197
wilsomgai
wilsomgai
jyothi12389
  • Locked
  • Question
Unable to generate report for an invoice in vantage epicore
Replies
0
Views
81
jyothi12389
jyothi12389
Yana2016
  • Locked
  • Question
How to un-assign buyer from part or part from buyer in Epicor
Replies
0
Views
211
Yana2016
Yana2016
AndreRandsdorp
  • Locked
  • Question
Planning Orders in Epicor Vantage 8.03
Replies
0
Views
65
AndreRandsdorp
AndreRandsdorp
MillsBatman
  • Locked
  • Question
A EPICOR 9.05.700 BAQ Report to show lost resources from active schedules.
Replies
0
Views
70
MillsBatman
MillsBatman

Part and Inventory Search

Sponsor

Back
Top