1. Goto this REgKey and update the path for the .mdw

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\SystemDB

2. Create an Access linked Server

3. Set up Permissions on the Linked Server Security Tab

3. Use LinkedServerName...AccessTableName

4. If you use that...

Increase the Max Errors to an "acceptable"  number

AND

Bulk Insert into an staging the File then

Compare the two to know what's missing!

if you want the...

you could allow changes to the data only through SP and Hadle that IN the SPs !!!

HTH

DO NOT use @@dbts as you would SCOPE_IDENTITY() !!

AFAIR @@dbts is NOT Transactionaly safe!!

ALL MS suggestions are based on RE-Reading the new TS column if you need to update again...

SELECT F1, MIN(F2)

FROM TBL

GROUP BY F1

Yes the issue is definetly that the PAGE is not downloaded in full and the editor is NOT enabled until it happens

PS: I have lost a lot of post because...

It does not appear to be a code Error in the ActiveX Script so you should try to apply SQL Server SP3a!!

It does not make sense that you get an...

SCRIPT OUT the TABLES with ALL dependent object Seleted!

then Run the Script on the Destination! (don't select copy data)

(DTS WIZARD)

- Are you running any scripts?

- what Patch level is your Server at?

- can  you let it run with the Full file and in the option task select source rows error

-...

try:

ALTER TABLE tbl_open_order

ADD rownum  AUTOINCREMENT (1,1)

OR

ALTER TABLE tbl_open_order

ADD rownum IDENTITY (1,1)

OR

ALTER TABLE tbl_open_order

ADD rownum Counter (1,1)

Can you check the Source ROW at which is reporting the Error?

Check the Agent proxy account

Use Information_schema views

Ex:

SELECT * FROM

INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME ='Your Table'

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=93494

USE @@PROCID for that too

CREATE FUNCTION fn_1()

RETURNS int

AS

BEGIN

 DECLARE @data AS int

 SELECT @data = @@PROCID

 RETURN @data

END