How large is the Database and How long is the Job taking to run? Any Idea ?

As, mentioned earlier by others, what is the Query Execution Plan displaying ???

and also how many Records exist in the Base tables and do you have Index on the columns...

Use DBCC SHRINKDATABASE Command.

Follow the Link on Microsoft http://support.microsoft.com/kb/307487

It seems to be you are in a hurry !!!

But Can't understand...

This is for improvising your thoughts on implementing.

try enabling checkpoints so that you would also have a way to restart the Package executions

from the point of failure instead of restarting...

Sorry forgot to answer about NON-DBA to be able to doing it.

If you edit your package and incorporate this logging you need not do anything, as the SSIS Packages execute...

Open/Edit your SSIS Package,

Right click in the Control Flow in the Design Mode and select Logging.

You need to enable logging at the Package Level.

See the attached Screen Shots.

If you...

You must be having an Idea what is that you are trying to achieving by setting up the test Server.

It's a general rule of thumb that your test Server is...

Hey Jason,

After seeing your post, I tested and it was working perfectly fine (on 32 Bit Servers)

My setup was Enterprise Edition was Publisher and Subscriber and Standard Edition was the...

Yes you can do

Look at the info at BOL

http://msdn.microsoft.com/en-us/library/ms162810(SQL.90).aspx

Looking at your posts for the past week or so one thing I found is it looks like you are preparing in SQL Server seriously and posting the questions that...

Obviously when you get backup and try to restore in the same SQL Instance, this error would occur, I thought you would have been aware of this. When...

When you overwrite the existing Database, you do not need to worry about creating the new Filegroups in the database2, it will be written by the new backup of the...

Yeah I found it on the web.

I need to enable the trace flag 3226.

Thanks Sugesh for the Blog

http://sugeshkr.blogspot.com/2009/01/introduction-to-sql-server-trace-flags_14.html