Tag Archives: SSIS

Did someone restart the server over night?

Sometimes, when you are running lenghty integration jobs over night, you get in the office the next morning, and may be surprised that nothing has completed. And actually nothing is running anymore. Today was such a Day for me. Last night … Continue reading

Posted in Programming | Tagged , | Leave a comment

SSIS Script Task and Proxy Auto Configuration (PAC) Script

m4s0n501 Actually this post could have been divided into several topics, but currently time does not permit me to write that often. So this will be the whole shabang at once. We needed to import data from an external source, … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Microsoft Connect Bug Reports

Just posted two bug reports to Microsoft Connect We don’t take kindly to sensitivity ’round here… First, I perceive it as a bug, when a foreach loop fails to list variables when a project parameter is set as sensitive. When a project … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Run out of disk you say, eh?

In the rare occasion, that when you are executing a project from the Information Services Catalogs, and the SysAdmin didn’t foresee some, unforeseeable event causing the disk to run out of space. And the execution doesn’t fail, just waits for … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Microsoft Connect Suggestions

Just posted two new suggestions to the Microsoft Connect site. First of is a suggestion, that when using a sensitive parameter, you get a warning when trying to use it in an expression. On the other hand, if you create … Continue reading

Posted in Programming | Tagged , , | Leave a comment