If everyone just agreed to crown me King, all of these voting issues would be gone.

As well as the people I deemed stupid or annoying or just simply refused to...

In that case, you can, but it will be a bit of work.

The trick is to modify the procedures that get created for replication. By default, replication will create...

What you have posted looks like what the ADO objects do when you open recordset objects. They open cursors and iterate through them as needed.

Is this efficient? Usually...

You were not very specific, but conditional logic can be handled in the control flow through the Precedence Constraints. Double-click on one of your control flow connectors (the green...

You could truncate the table and then insert, but with a large number of records, this is pretty inefficient unless most of the records actually change.

You will probably want to...

Depending on what you need for security, the domains do not need to trust each other to have a linked server and a single view to handle your data need....

Ok, that is getting into a bigger subject.

What you are trying to do is exactly the same thing as a "Type 1 Slowly Changing Dimension" update. You have several...

What you don't realize is that ATM machines do have some of the same issues. Transactions are lost and misdirected all the time. In some recent consulting, I...

I'm trying to be elitist.

How did you create your initial snapshot of your database? If you use the NOT FOR REPLICATION option on the publisher and allow replication to create the snapshot, the...

This is not a very well prepared question. Are you trying to put the entire Excel files into a database table? Are you trying to pull data from...

You can check for NULL in your expression for your derived column, but it may be better to check for an appropriate length.

The expression will be something like:

LEN(ColName)!=8 ? ""...

You want to use a conditional split component in your data flow. This will allow you to specify an expression (MyCol=="A") to split data into multiple outputs.

It is not...

I am amazed at the problems they are having with the new electronic machines. Plenty of people handle banking online and through IVR systems with a very low percentage...

I can understand basic, foundational questions, but what has been driving me batty lately are the questions that you can copy and paste into google and click "I'm Feeling Lucky"...