This is a batch separator. In some places, it will impact what your scripts will do.

The semi-colon you have included is also a batch separator but is different in...

Time to pitch a Red-Gate product:

http://www.red-gate.com/products/SQL_Prompt/index.htm

You get some intellisense as well as shortcuts for frequently types "phrases".

In your data flow task - right where you attached the OLEDB destination component. Remove the destination component and from the toolbox in the Transformations section, drag out an...

OPENQUERY and OPENROWSET will likely give you the same performance. 4 part names with linked servers will be far more interesting when you do a join. If you...

You have specified:

1) Get data from D1

2) See if data already exists in D2

3) If it already exists, INSERT it into D2 (add new rows)

What you seem to want is:

1)...

I use the "ignore failure" option now and then for this type of thing also - string operations like this will always find some bad data that you could not...

Ok, make that first IF a bit more specific:

FINDSTRING(REVERSE(TRIM(FirstName))," ",1) = 2 && LEN(TRIM(FirstName)) > 2 ? SUBSTRING(TRIM(FirstName),1,FINDSTRING(TRIM(FirstName)," ",1)-1) : TRIM(FirstName)

Of course, you may want to make that first IF...

I cannot understand your post entirely, but I think you are looking for the information_schema.columns view

Ok, I have not tested this, but I would tend to build a more standard parse with a space as your delimiter. This would help you handle some bad...

You are using a SQL destination adaptor, not an OLEDB destination.

I was referring to the OLEDB destination adaptor.

The SQL destination adaptor is designed for high performance batch insert of a...

The spid was performing a rollback - probably because it had already been killed, but not necessarily so.

You cannot stop a rollback that is incomplete - it would leave you...

What error do you get when you click preview on the destination component?

SSIS maintains schema information in XML on the input and output of every component. It is very...

You can run the DELETE statement as you suggested with a SQL Command task in your control flow.

Rather than doing this, I tend to keep a template spreadsheet with no...

I would have to say that your database design is less-than-perfect when you find yourself making a new table every month with the date tacked onto the end of it.

I...

There is a PreCompile property in the Custom Properties section. This defaults to True on both SQL 2005 and SQL 2008.

Your error message is not very descriptive. I...