Tried adding a CAST to all columns returned in the source (which is an ADO.NET source pointing to the DB2 database) and still got the error when it ran as...

Yeah.....I thought about a stored proc to creat a temp table and go that route but I actually liked the concept of having a more structured output.

I'm always looking at...

Dynamic is gonna cause the problem there......maybe someone else knows a way of doing a SELECT statement with a dynamic number of Select fields but I've never come across one.

Here's...

I still have the concern about the configuration connection....

Is that a static connection that is always pointing to the same database or does it become dynamic somehow.

Let me explain my...

I have never worked with an OLTP Database before and really don't know anything about them.

The reason there are triggers firing all over the place for what I'm doing.....

The Application...

Okay, so all these triggers I'm making.....it doesn't really matter whether they go in the App database or the Reporting Database.....if they cause any lag then that lag is going...

This seemed like the best bet...

Can anyone even just supply some possible concepts for me to research?

Totally at a dead end with this at the moment.

Thanks for everyone's responses.

I ended up taking it to the next level because there's really a double check that needs to be done to be 100% sure that you will...

Have you ever tried this for a Default Value Constraint?

I can't find any trace of the constraint in question within that schema anywhere. Even...