Thank you Tim that was my issue.

I was trying to eliminate the sys and schema's from displaying on the tables so the users would not get confused.

Which I still have...

That was the issue, and is fixed.

Where would I find the security for 'View any database'?

This maybe my issue.

What I should of indicated was the mdf is in a specific folder, however the mdf is dropped randomly (no set date).

Found the issue.

The source system was converting the text files to a dos format (need this for sql2000 not sql2008).

We removed the unix to dos conversion and the extra {CR}...

I've loaded the file in excel and it looks good.

From my research it looks as if it may be trailing nulls, however I've tried filling the nulls with a value...

Maybe I stated the delimiter backwards.

Should be row delimiter cr/lf

and column delimiter tab.

See attachment

Thanks for the quick reply.

Yes, I've verified the cr/lf is truly there.

Thanks, Norman

objFile.WriteLine("How do I reference the trailer row here?")

strFile = "c:\output.txt" ' e.g. c:\output.txt

' ------ END CONFIGURATION ---------

const ForAppending = 8

set objFSO = CreateObject("Scripting.FileSystemObject")

set objFile = objFSO.OpenTextFile(strFile, ForAppending, True)

objFile.WriteLine("Script completed:...

Hi Norman,

I do not have the knowledge to write a ActiveXScript Task.

Any help would be greatly appreciated!;)

I use DTS to map and load the data in a table.

I guess I do use QA to view the data.

See attached file.

Okay, I'll need a little help.

In DTS I created a BulkInsertTask, how do I specify columns 1,3 and 33?

Thanks I've set up the exception file.

I'm not using Query Analyzer:unsure:

If I delete part of col033 the file loads.

I've attached the txt file.

I added the msgbox.

Where do I find the exception log?

Okay changed to:

Changed field back to varchar(6000)

Function Main()

DTSDestination("MAID") = DTSSource("Col001")

DTSDestination("Mem_ID") = DTSSource("Col003")

If Len( DTSSource("Col033")) > "6000" Then

Main = DTSTransformStat_ExceptionRow

Exit function

End If

DTSDestination("Ac_Ded_Yr") = DTSSource("Col033")

Main = DTSTransformStat_OK

End Function

AC_Ded_Yr is...