Thanks,

so if I have been importing records using bcp then cancelled this then those records should then not appear after it eventually rollbacks?

An obvious question I know !

Regards,

Mr Careful

When i kill the process SQL goes into a roll back.

Does this mean that the rows inserted so far from the text file I am importing from will be removed...

Gail....that's even better...thanks !!!

John, heyyyy...thanks a million, perfect

Hi dw,

the call to the currenrt DTS package is

oPkg.LoadFromSQLServer "Svr\Instance", "User", "Pwd", 0, , , , "DTS Package name"

oPkg.Execute

with "DTS Package name" been the name.

This isn't actually that urgent anymore...

sorted ...

I just changed this line

oPkg.LoadFromSQLServer "MyServer", "MyUserName", "MyPwd", 0, , , , "Full path name and name of DTS package.dtsx"

Yes, I had the same problem and have a copy of the files I use in Access as linked tables. before the call to DTS I move the data I...

Hi Guys,

Here the MS Access VBA code I used:

'-------------------------------------------------------------------

' Access VBA code for MyButton

Dim oPkg, oStep, sMessage, bStatus

Const DTSSQLStgFlag_Default = 0

Const DTSStepExecResult_Failure = 1

Set oPkg = CreateObject("DTS.Package")

oPkg.LoadFromSQLServer \\Myserver_name\MyInstance, "MyUsername",...

Thanks Guys for the guidance

you led me to this link which done the trick

http://support.microsoft.com/kb/252987

Eamon

there's nothing like answering your own question !

http://www.sqldts.com/default.aspx?234

Thanks alot for this guys both make this very clear now

Eamon

Hi,

here's a follow on issue/scenario.....

I create DTS packages using my windows user name. I have dbo (not in msdb though) access and would like to save it as dbo....Can I...

Thanks Sreejith that works for me !!

THANKS....that was wayyyyyyyyyyy to obvious !

Thanks again,

Eamon

Hi,

I got this sorted and it was because the command was inside a transaction.

I did a work around on this using some IF statements.

Regards,

Eamon