Daily Archives: July 31, 2014

The external metadata column collection is out of synchronization with the data source columns.

One of my SQL Job failed with Error and the failure was due to an issue with SSIS Package. There are multiple reasons when this error occurs but I just share the approach and one of the examples: Do you … Continue reading

Posted in SQL, SQL Error, SSIS | Tagged , , , | Leave a comment

Declaring Variables in SQL – Declaration will take place during PARSING, not at Runtime

All SQL variable declarations will take place during parsing but not during Runtime. Let us try simple test to prove it! Let us try to declare a variable in a loop which runs for 5 times… There are no errors … Continue reading

Posted in knowledge, SQL, SQL Query | Tagged , , | Leave a comment