I'd be curious to hear more specifics about what issues you ran into. What type of setting were you using those params/variables for? Possibly a connection string?

Parameters, whether...

Why does it have to be a single data flow?

Hi Steve,

I use the start and end point so there are clearly defined boundaries for each load. Without that end point ID, it is possible that a row in the...

Hi Steve,

I'm a big fan of change tracking in SQL Server for change detection. When I integrate change tracking into ETL, I usually do it within SSIS. Using SSIS to...

Hi Luther,

Some good replies on here so far. I'm curious what causes the load to fail in the first place. Is it worth exploring it from that angle, or is...

This is a case where the execution logs will be very useful. Are you executing from the SSIS catalog? If so, take a peek at the logs for that execution.

I've noticed the same thing on multiple machines, and I've heard similar complaints from others. I haven't yet found a fix.

Grumpy DBA (5/16/2016)

Bautista did what baseball...

Not excusing the punch, but I suspect it had to do more with Bautista's dirty and dangerous slide than the celebratory bat toss.

Your images aren't showing up so I can't see your exhibits, but from what you described, I suspect you need to use the No Match Output (not the Error Output)...

This is the key part of the message:

Object reference not set to an instance of an object

There's an object in your code that is being referenced but has not been...

There's no way to fully obfuscate the SSIS source code. However, you could set the package setting for Package Protection to EncryptAllWithPassword, which would require a decryption password to view...

Ah yes - VS_NEEDSNEWMETADATA. My favorite four-letter word 🙂

SSIS is certainly fickle about metadata changes, and because it does a .NET comparison (rather than a database comparison, which is usually...

Bad days for the home teams so far.

I'm going to ALDS Game 3 on Sunday. If the Rangers win today, that'll be a potential clinch game.

Also, on #1, I'd point out that sending an email upon failure is a notification, not exception handling. If I wrote a spec and asked for exception handling, I would...