I've run the following to mimic your package

i get the following error log, however all of my new logins that i created are transferred correctly

Step 'DTSStep_OMWCustomTasks.OMWTransferLogins_1' failed

Step Error Source:...

Unless i'm mistaken - and there's every chance i could be.

DROP table is logged. if you have 10 million rows of data your drop table will generate a huge log...

As a matter of practice with large tables I always perform TRUNCATE TABLE before i drop the table

I think the key thing here is that the Upsize is USELESS

I make a point of always re-linking my tables.

it's the same with views - create a view that...

i'm guessing then that this is one of the settings on the options menu of query analyser......

but i'm not sure that i can see any that do this.

joyeux,

an unspecified error - (Erreur non spécifiée)

why can't they make these a little more helpfull ?

I thought so

Does anyone know if any of the later versions (particularly XI) can do this

i might be able to persuade teh customer to upgrade

i think he means profiler trace

how are you sending it to text file ?

via bcp? dts? query analyser?

i've seen it done this way as the text of a job in SQL agent

xp_cmdshell 'isqlw.exe -S myserver -d master -U sa -P password -i c:\script.sql -o results.csv'

although surely doinc...

I've come across this exact problem in the past and i can confirm it does affect access with linked tables held on SQL server.

I can't remember how i got round...

here's my advice.

go through enterprise manager and ensure all your tables have primary keys

drop all of your linked tables in access

re-link all of your tables in access - it...

i'm guessing here but i bet you have to be a memeber of diskadmin as a minimum?

can't you just use query analyser and use the output to file function ?

the other ones i forgot to mention that just came back are...

if you have BIT/Boolean fields in SQL server and they are linked to Access then you must add a...