I've seen it in the past were the square boxes are the translation of a carriage return/line feed (iether on alone or in combination).

Trend could be causing this issue.  Try excluding .mdb and .ldb files from being scanned.

I can think of 2 solutions. 

1. If this is a scheduled job try this approach:

     Add a step to you DTS that writes the start time to table before...

What JLK said is correct.  You need to test your update statement in Query Analyzer. Simply use a select statement instead of an update.

I believe that you'll find that your select...

Sorry, but I've never heard of such a beast.  I'd guess that most of us are self taught DTS folks and have learned by attempting to solve a specific issue.

If there...

Couple of options and questions:

1.  Create a new DTS to connect to the Access DB that you created.

2.  Create a new DTS and a new Access DB.

Now for the questions: ...

I believe you got this one right.  Probably easiest to use the recordcount as the output parameter and procede from there.

Check books online.  Search BCP and then look at "Copying Data Between Different Collations".  You are using the -c option to specify a codepage but not identifying a codepage.

I would...

I believe so.  That was my sample from Dev, where I had control, but as I recall once it was pushed to Prod the DBA's assumed control and simply edited...

This should fix it for you.  From your ASP page call a proc that calls the DTS.  This is how I did it.  Below is the proc code:

DECLARE @myline...

If your DTS is a series of steps all setup with on success and a final step of sending the "Success" email you can add a failure path to each...

The easiest way is to create a proc (we called ours usp_execute_dts) that calls the DTS.  You call the proc from your VB app.

The contents of the proc are:

go

CREATE    PROCEDURE...

I remember having issues with the quotes.  Sometimes you need the standard " other times I've had to use 2 single quotes together ''.  They look quite similar and are...

Shouldn't matter.

USE DTS to get your data from the original DB.

Set up your Final and conversion tables in the destination DB.

Once the DTS imports your data it's all local and...

Sounds like the following process may work for you.

Import your data, as is, into a temp table.

Set up your conversion temp tables. 

Create convtable1 (OriginalValue int, NewValue varchar(10))

Create convtable2 (Value...