Ok, so this is a single data record,

A222|ZS08          |0005      |H350        |GENERAL_REPAIR      |A              |28.02.2004|01.02.2004|0000352836     |000

Is A222 the destination table  and ZS08 the field? (For sanity sake I hope not :crazy

And would it also be related to this post?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=159576

Making it three posts for the same problem.

Is that some sort of record?

Yes. Lookup DTSRUN Utility in Books Online. There is a link about half way done that says "The table shows the global variable data types and their IDs."

Click it...

A bit confusing.

So you have a table variable called @tablecol that has two fields (table name and column name).

What do you mean by "I want to pull Table name first...

Direct copy and paste from Books Online

Important  Use the Microsoft® SQL Server™ 2000 function DATABASEPROPERTYEX to obtain information about the current setting of database options or the properties of a...

Should you be using BCP at all? Why not use BULK INSERT?

Given that the laptops will not be able to access the SQL Server, what is the definition of a locked record?

I would use MSDE (Is that what you were...

Super simple really. just use a standard T-SQL UPDATE for matching records and an INSERT for missing records,

eg:

UPDATE Tbl1

SET Tbl1.Field1 = Tbl2.Field1

FROM Tbl1 INNER JOIN Tbl2 ON Tbl1.Key = Tbl2.Key

INSERT...

Very easy solution, the last step in the package is called when one of the previous step fails

eg:

Post your SQL statement and table details so we can look at it.

Yes, but exporting to CSV and opening in Excel means that you lose any formatting, like column widths, borders, etc...

What I have found to be the best solution for Excel...

Actually, this sort of approach is recommended as "Best Practice" by Microsoft in developing the routines for the Business Intelligence Accelerator.

What I do here is have all my global variables,...

You can do it programmatically with a wee bit of ActiveScripting.

You would need to get a list of packages from the server (via ADO or DMO), load the package...

The DTS Transformation you're doing is processing the input a single row at a time. Are the two tables accessible from one server? ie: can you run a single query...

Is there any reason you couldn't just use

SELECT * FROM dbo.employee WHERE hire_date > ?

Then assign the global variable using the Parameters button?