http://support.microsoft.com/default.aspx?scid=KB;EN-US;q262499

At the bottom is one of their code samples, that I think is most helpful.

Russel Loski, MCSD

DECLARE @SQLString NVARCHAR(500)

DECLARE @ParmDefinition NVARCHAR(500)

DECLARE @IntVariable INT

DECLARE @Lastlname varchar(30)

SET @SQLString = N'SELECT @LastlnameOUT = max(lname)

                  ...

Here is one thing to consider:  check the ANSI_NULLS settings for the database.

This setting is described in Database Options in books online.

Russel Loski, MCSD

My ritual when moving Access tables to SQL Server is to first run the import wizard in SQL Server.  Then using Enterprise Manager I write the SQL for the tables. ...

What are you trying to do with this query?

Russ

Try outer join syntax?

SELECT distinct tr.Prcs_dte

FROM tbl_Tracking tr left outer join Acct_Stats asts

on tr. prcs_dte = asts. prcs_dte

where asts. prcs_dte is null

This may work faster.

Russel Loski, MCSD

I'm not sure I understand what you are trying to do.  The query you have will return a list of unique [page] for all of the records since by definition...

There is one piece that is not in the exception log file (I think that is what you are talking about):

The column sysdtssteplog.progresscount contains the number of records that were...

Is your backend script different from VBScript?

There is some scripting tool that will allow you to run visual basic script from a command line.  You could also run this as...

I have done this using VB code.  I created this code in Access VBA after setting a reference to Microsoft DTS Package.

Dim pkg As DTS.Package2

Set pkg = New DTS.Package2

pkg.LoadFromStorageFile "

I think that this was longer than 4000 characters.  I changed the type to

DECLARE @l_XMLDoc_Nva  VARCHAR(4000)

The errror suggested that the last element closers were begin cut off.

I changed it to

DECLARE...

You can log the package application.  I believe that it will record the number of records affected.

The Log the package option is set by FIRST DON"T HAVE ANY OBJECT SELECTED...

I am more comfortable using OPENXML in a custom SP.  But that is more because it is all I have tried.

I have not found a nice way to use DTS...

The first item is looking for a FK_ClientID that has the form:  '!2OiC','!3zje'

It treats the variable as one item in that list.  If you had "in (@x, @x1, @x2)" then it...

To be honest, I have no clue what is going on.  By going to a temp table, you eliminate one unknown.  Let's say that going to a temp table doesn't...

Just to reduce the variables in this, could you use a temporary table to hold the id that you currently have in the doc?  Move the OpenXML out and replace...