SSIS and MUMPS?

Last Post 25 Sep 2012 03:11 AM by dstoltz. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
dstoltz
New Member
New Member

--
24 Sep 2012 06:01 AM
Does anyone know if SSIS can work with a MUMPS database?

I'm guessing no, since MUMPS is not a relational database, it's hierarchical

Any information appreciated.
rm
New Member
New Member

--
24 Sep 2012 06:05 AM
Can try if you are able to connect to it in ssis.
dstoltz
New Member
New Member

--
24 Sep 2012 06:07 AM
Yeah, I was wondering if anyone knew if you could connect, or has experience with this...
Banyardi
New Member
New Member

--
24 Sep 2012 02:15 PM
When I worked at a major health care biller, we had MUMPS drop text files in a DMZ and use the command-line utility to inititate the DTSRUN.exe, which also passed the filename in as an input package level parameter. The SSIS packages then used the flat file object to import into staging tables. Make sure the MUMPS text files are in Code Page 1253 format (ASCII), or else you will have to do some hairy binary transformations.
dstoltz
New Member
New Member

--
25 Sep 2012 03:11 AM
Great info! thank you!


Acceptable Use Policy
---