Keep in mind that doing a replace in a join will cause a table scan.

There is a SQL command object for doing updates within your data flow.

One way of doing what you are talking about is to use a lookup component to determine if...

Without looking at this in a lot of detail, I would break it into two pieces if your application architecture allows it.

The CTE runs fast, so why not execute that...

I would use the NUMERIC data type and select a precision appropriate for your data. The FLOAT and REAL data types are approximate numerics and that may impact the...

Ok, I hate to pick like this, but I have to ask.

Are your servers moving around onto different domains so often that you need an automated process to keep track...

No, it can be a basic account with access granted to the SSIS server, the file share, and give it an email account.

Ask your network administrator what permissions would be...

What does your SQL Server need network access for? Why would all of your servers need to use the same account?

You probably want to use SQL Mail, that is...

I like the rule of only giving accounts the access rights they actually need. So, I never make a SQL service account a domain admin. I also tend...

Do you realize your statement is trying to update every record in GOLD_BROKER_OUTPUT to the same value?

If you do, the problem is in the GROUP BY in your subquery. ...

This would typically be caused by using a connection manager for managed code with an OLEDB component (or the other way around).

It is hard to do in most cases because...

Use a DataReader source.

Ok - one more post.

I didn't mean to post that you did not think SSIS was any good. I also did not mean to post that it is a...

Set the ValidateExternalMetaData property to False.

However, you are better off using a CAST or CONVERT in your SQL statement and changing the column to another data type.

These arguments always drive me crazy, so this will be my only post on the subject.

I have always bucketed people into "programmers" and "developers".

My idea of a programmer is someone...

You have mis-read a bit - I had some of these same concerns not long ago.

They have not included Analysis Services in their Data Warehousing bullet - it is in...