Avatar of thinksysinc
thinksysinc
 asked on

How to create a cXML document from SQL2000

I am trying to figure out how to create a cXML document from a SQL 2000 database. Can anyone point me in the right direction?

Thanks!
XMLMicrosoft SQL ServerDatabases

Avatar of undefined
Last Comment
thinksysinc

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Mark Wills

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
thinksysinc

ASKER
After digging into this more I have some more questions. The requirements from the trading partner state that we need to produce a document feed that consists of a control file and document files. The control file can be either a csv or xml file. The document files can be either a word doc, pdf, tif or text file?

I need to be able to automate the process of producing the document feed and the FTP it over to a FTP server.

I have been looking at XMLSpy to see if I can use that to do this.

Anyone have any input about the best way to do this?

Thanks!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes