tmpCase would not be the name of a temporary table. Temp tables need to start with # or ## (two pound signs is a global temp table).

I would expect...

That is going to depend on many things that you really stand very little chance of describing here.

From your description, I do not think you are very far along in...

SQL 2000 came with an undocumented command line utility called TextCopy.exe. It will be in the Binn directory on a SQL 2000 server.

It may have been part of the...

It will partly depend on your faxing software. RightFax, for instance will allow you to include an additional page (which you would have to add to the report) with...

Remember that the foreign key constraints in your cascading deletes makes them slower. If you are deleting a row from a child table, the PK value of that table...

I'll add the "why" to the original question and answer. If you have the development tools and evnironment installed on your machine, you can create and run any package...

You really need to look at expressions and package configurations in books online. You should be very hard pressed to find any reason to use a script task to...

SQL 2005 does not really support storing an updating something in the file system. There are some things in SQL 2008 suggesting that it is a direction MS is...

ADO does this for you.

Select your data using an ado recordset with the cursor options set to pessimistic locking on a server-side cursor. Make your you do not disconnect...

That will work just as it did in 2000.

You are way off track for what SSIS is designed to do.

If you need to collect information from a user to run an SSIS package, collect it before you start...

PW is probably on the right track. Inserting into a temporary table or a table variable returns rowcount information. In many cases, this will actually cause your select...

The FlowSync came from here:

http://www.sqlbi.eu/Default.aspx?tabid=74

It is to make sure the two data flows go into the TableDifference component at the same speed (for memory reasons). The TableDifference component (which...

Here are some pictures:

The OLEDB Command will be in-line.

When you are in your data flow, you are currently dragging the OLE DB Destination from the Data Flow Destinations components.

Instead of this component, scroll...