The semicolon is not a batch separator, it is the end of statement character. However, it is not required because the SQL language is specified using Bacus-Naur Form or...

Yes Mark, I think we are.

I didn't see your post until the page was refreshed after I posted.

Since when has the choice of columns for the primary key ever been dictated by the performance of the database?

Your choice of columns for the clustered index should be a...

I don't have time to tell you how to do it, but I would look at using the Dynamic Properties task to set the destination server name.

The following link demonstrates...

I can't see the purpose of the ORDER BY clause.  If you were to remove this from your select statement, you may find that you improve the performance.  It may also be...

Hi Robert,

The details of the ExecuteOutOfProcess property can be found in the Books on line for SQL 2005 June CTP.

Paste this link into the BOL address bar:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9mref/html/P_Microsoft_SqlServer_Dts_Tasks_ExecutePackageTask_ExecutePackageTaskClass_ExecuteOutOfProcess.htm

I've attached the entry in case you...

I can't see why this is 'nonsense', 'a waste of time' or 'stupid'.  The question is valid, the answer is correct, the explanation however is incorrect, but that's a minor point.

I think...

SQL only recognises a semicolon as an end of line character.

If the question had been structured as follows, it becomes clearer what is going on:

SELECT id_a, id_b, ds_a, ds_b

FROM tab_a...