You can check if sqlserver finds the group using Query ananlyser.

connect to the server position in the database

and execute :

use yourdb

go

EXEC master..xp_logininfo @acctname = 'yourdomain\yourgroup',@option = 'members'     -- who belongs...

this would be like pulling a cat insideout   (in a matter of speaking )

If you don't...

Can you try running the dts in the job with its proper name in stead of the guid ?

dtsrun /Npackage_name

Yes it has.

In fact, you can prepare and save your package (if you used the wizard, you must have seen the panel where it asks "run immediate , save as...

Is this package password protected ?

it's _the_ way for importing / exporting data.

Even the wizard is intuitive

EM (enterprise manager) \ databases \tables got to the righthand side, right-click...

did you put the jobowner to SA (and not a windows account) ?

can you perform a dbcc checkdb ?

Read about it in Books Online to check the options?

just to be sure ...

- you know EM does _not_ refresh automaticaly. You have top position on the...

so you can login and execute using _that_ (sqlagent) domain-account ?

Can you enable the jobstep's outputfile to capture windows output ?

jobstep\advanced outputfile

Is your sqlagent running using a windows-domain-account ?

When you run the package yourself, it's using your account to get network or share rights.

If it runs using localsystem, is has no...

I ride a Honda NTV650 (1995 preceeding the Deauville and succeeding Revere&nbsp

I tend to join a "riding techniques (advanced) refreh"-course every 1 or 2...

Did you take a look as to how DTS may help you to solve this problem ?

or mess with ansi padding

declare @tb table (col1 int identity(1,1) primary key

, mychar10 char(10) not null default('a')

, myvarchar10 varchar(10) not null default('b') );

set...

aparently an I/O bottleneck

- What's your drive(s) config ?

Maybe this helps a bit : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=214046

(check the mentioned articles ! )

- http://www.sql-server-performance.com/performance_monitoring_tutor_part4.asp