Thanks for the replies, all.

We redefined the file in the ODBC text DSN, and were able to import the
data.

Thanks for the help.

Steve

>>> "John Thomas" <[Email Address Removed] 09/08/03 17:20 PM >>>
This might help you. An interesting thread here ...

http://tinyurl.com/mo8v

HTH,
John

-----Original Message-----
From: Stephen Holland [mailto:[Email Address Removed]
Sent: Monday, September 08, 2003 3:05 PM
To: LazyDBA.com Discussion
Subject: TSQL Problem

I have a colleague who is having a problem with a DTS import of a text
file directly into a table in his database.

He is getting the following error:

"Need to run the object to perform this operation. Provider generated
code execution exception: EXCEPTION_ACCESS_VIOLATION"

He has verified his permissions on the DB, and has assigned his login
DBO privilege.

Any ideas what might be causing this or how to resolve it?


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page