I have put a Run SQL task that first drops an index, then a second Run SQL task that creates that index.  The first task runs before the transformation and...

I had some theories as to what might have happened.  What did you do to fix it?

Russel Loski, MCSD

Actually what I mean by x < 5 is that if the varchar is less than 5 I convert to char.  My rationale for that is that a varchar takes...

I have never seen this problem.  Here are a couple thoughts.

Try changing the SQL field from ntext to text.  ntext is for Unicode data and text is for ANSI data.

Another...

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...