Fix the error. There's something in your source that's a conflict. Otherwise you're asking how to insert dirty data and to break your referential integrity.

I work in an analytics department. We have two levels of modelers - Predictive Modelers (working on or have their masters degree in the relevant field) and Data Scientists (working...

I noticed that you were getting Result Set errors. That leads me to believe that you've set the task to have a result set but haven't directed it to a...

First - What errors are you getting? We can't help without knowing those.
Second - Are you connecting to the correct database?
Third - Does the stored procedure run outside...

Does anyone else think GeorgeCopeland was having a bad day? Or does he really not get the fact that there's a lot of dirty data out there and this IS...

Dealing with data scientists I've been learning R out of self defense.

The book they recommended as a starter is "R for Everyone" by Jared P. Lander.

Having...

I'm keeping this one in my briefcase because I'm dealing with a lot of legacy data out of multiple systems. I keep finding dirty data all over the place and...

I would add that a satisfying job also lets me improve my existing skills and learn new ones. Yes this means a training budget. It also means being assigned to...

SSIS, stored procedure sources, and temp tables can be tricksy. Very tricksy.

It seems like SSIS will take the first temp table definition it finds and make that the...

I run 2 separate games of Dungeons and Dragons. Doing that includes:
* Planning encounters that the players will completely ignore;
* Trying to have other encounters that will fit...