Reverse Engineering SSIS

[Paolo F Cantoni]

Hi All,

In my new gig, I'm currently heavily involved in creating models of the physical data structures and maintenance processes on the live databases.

Has anyone had any experience in reverse engineering Microsoft SSIS objects into EA?

If not has anybody poked around inside EA with a view to extracting the metadata therein?

TIA,
Paolo

[George..Brennan]

Hi Paolo,

SSIS is a pretty complex beast with lots of flow options, what were you thinking of trying to create/map?

Never tried to get the SSIS from the database directly but I have some code somewhere that examines an SSIS project's packages/codebase, I have some code that creates EA objects, just never tried to combine them. ;-)

George.

[Geert Bellekens]

No, never tried it, but seems like a fun task.
If you are looking for an external consultant to write some kind of import tool, contact me.

Geert

[Glassboy]

No, never tried it, but seems like a fun task.
If you are looking for an external consultant to write some kind of import tool, contact me.

For some weird value of fun 

[qwerty]

Most hackers are kind of masochists. They love this "oh, it doesn't work, but why?"-feeling. I've been one of them, but now I'm in the "ah, it doesn't work, I'll have a beer"-premier league.

q.

[Glassboy]

So many beers, so little time.

[Geert Bellekens]

No, never tried it, but seems like a fun task.
If you are looking for an external consultant to write some kind of import tool, contact me.

For some weird value of fun 

Yeah, the same kind of fun it is to open op a radio to figure out what's inside.
I enjoy figuring out how stuff works. (on computers, I don't really enjoy the same thing on physical devices )

Geert