Jeff Moden (5/9/2015)

Heh.... exactly...

We use Kimball, it is all I have used. Downside is that data must input SORTED.

Sorting and aggregating are blocking functions in SSIS. this means, every...

Do not give up! we have all had days like that (oh boy, have I...)

Just step back, take a deep breath, think about something really pleasant for a few...

This doesn't look like a connection error to me.

Is there a script component in the flow, or is your source a text file?

Is the source component turning red...

Yes, you can do it in derived column. what you need is a bit more cumbersome than what I would want to do in a dc, but if you...

We have a sourcesystem table, each source is defined. We needed the ability to enable/disable sources and this accomplishes it, and leaves us a trail in case something strange...

SSIS pkgs weren't meant for this kind of ad hoc firing. Obviously, everything depends on your unique environment, but here, an SSIS pkg could be moving gigs or terabytes...

are you sure it's the null values triggering the error?

I am puzzled why a date field would require itself to be named after the current date that is presumably the exact content it holds, but, not the wackiest business...

You can get around this by making your source a query that joins to that reference table.

Don't limit yourself to tech sites. If you have any special interests and are active on non-tech message boards, post there. It does seem like the questionaire is...

and another...

Sounds like Agent permissions. Can't tell ya much more than that as someone else here handles all config and security issues at server level.

Congrats!! Spotting the trick questions may have grabbed that job for you as another candidate that really didn't know might have started down some path of mumbo jumbo in...

your title says logging. after you send the email, no bother to insert a row into a table you create for the purpose of capturing things like this. ...