right click table in EM and paste into qa, then simply rename the table in the create statement

Why not try and use filemon, free from sysinternals. Use the app to find out what has hold of these files, and if you find out you can eaither kill the...

Look at dbcc showcontig, run it against the table and see if you have fragmentation. If so run a reindex.

create a staging table that matches the table you ultimately whant to import to, truncate this table at the begining of the dts using the execute sql task.

After the truncate...

use dbcc shrinkdatabase('dbname') out of business hours

Maybe the sql server service started before the disks were ready. Do you have any event log entries that show the disks were not ready after the sql service started

open up dts in designer and right click in white space and choose package properties from the resulting menu. Then click on the logging tab and check the log package...

It sounds like a permissions issue, check the account that starts the sql agent, also see who owns the job.

--Script to script out object permissions

DECLARE @DatabaseUserName [sysname]

SET @DatabaseUserName = 'byford777'

SET NOCOUNT ON

DECLARE

@errStatement [varchar](8000),

@msgStatement [varchar](8000),

@DatabaseUserID [smallint],

@ServerUserName [sysname],

@RoleName [varchar](8000),

@ObjectID [int],

@ObjectName [varchar](261)

SELECT

@DatabaseUserID = [sysusers].[uid],

@ServerUserName = [master].[dbo].[syslogins].[loginname]

FROM [dbo].[sysusers]

INNER JOIN [master].[dbo].[syslogins]

ON [sysusers].[sid] = [master].[dbo].[syslogins].[sid]

WHERE...

use sql profiler. use this site for an indepth overview and scripts to do this:

http://vyaskn.tripod.com/analyzing_profiler_output.htm

andy

Thanks

Akane

Hi stacenic,

Liked your post and would be grateful if you could post this script or email it to me on andrewkane17@hotmail.com.

Regards

Akane