Question

JohnZT on Tue, 10 Sep 2013 17:08:43


Hi everyone!

I have an SSIS package imports que the mdb file to the sql server. My problem is that every month mdb undergoes changes in one or more tables (adding or removing columns).
Which means that SSIS has to be corrected to recognize the new columns.

My question is, is there way to get around this problem?

Best regards


Sponsored



Replies

ArthurZ on Tue, 15 Oct 2013 15:11:13


SSIS relies on static metadata, that being said the only way to process ever changing schema is by capturing changes in the metadata in a preamble step (say a C# console app with SMO) and generating a new package programmatically if the change has indeed occurred.