Gripe about SSIS – SQL Server Integration Services

I have been using this tool for a while now and it contains a lot of good things that, in general, augurs well for future releases.

I have griped before in the News Group about some things that are way too complicated compared to other ETL Tools such as Informatica and Cognos DecisionStream.

One of things that really annoys me is that the property: ValidateExternalMetaData is always set to True. Basically, it assumes that all tables will pre-exist. As we all know, tables are apt to be changed and hence our code contains bits that create tables and indexes. Hence one has to set the property to False if a source or destination is dynamically generated.

I just want to set it’s default to False. Where does one do this?

Advertisements

2 thoughts on “Gripe about SSIS – SQL Server Integration Services

  1. Agreed. I saw a posting where the developer was creating Database views to allow data model changes without causing SSIS repercussions… hardly ideal IMHO either.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s