@dbadotraghu

A memory leak or unused DLLs over RAM can be a issue. I too once faced this trouble... I resolved this manually by closing all the programs and freeing up...

Guys,

Any help/inputs??

Still In 'Thoughts',

[font="Comic Sans MS"]LonelyRogue[/font]

@pujain

I too Compress and UnCompress the Zip files thru SSIS using Execute SQL Task...perhaps you can try this as an alternative....

Add the below code in SQL Statement of Execute SQL...

Hey,

Is there any other way when dealing with SQL Server 2008; I tried the same trick on 2008 but it didn't work.

So, will this trick only works for SQL 2005??

[font="Comic...

@dinesh-2 Asanka

I have experimented your setting, and ran my package with "SQL Server Destination" created for a remote server.But my package failed again with the same error.

Here is what I...

Then, is there any way to fire the Trigger upon this Truncate action, as well?

In ' Thoughts ',

[font="Comic Sans MS"]Lonely Vampire[/font]

Thanks.

Still In ' Thoughts ',

[font="Comic Sans MS"]Vampire[/font]

@ James Connor.

Thanks for the input. I too have solved the same issue by replacing " SQL Server Destination " with " OLE DB Destination ".

This behaviour has been explained...

Dear CrazyMan and All,

Could you please answer few queries reg sp_OAMethod.

1. What are all the parameters this method accepts? i mean besides scripting out jobs,Views and SProcs what is it...

Jack,

Thanks for the reply.

What are you trying to accomplish using ole automation?

Are you running SQL Server 2000 or 2005/2008? If 2005/2008 then you should look into using...

But, it seems theres been some post-restoration issues of this System Database. After I restored MSDB...one of my job is failing with the below error:

Message

[LOG] Step 1 of job 'DataImport'...

Hey Paul,

I was able to restore my MSDB jobs 😀 without creating a new MSDB.

Here is what I have done, probably help them lying in the dark struggling with this...

@paul-2,

Thanks for the reference link. However, will that method work even for System Databases ( in my case its MSDB).

I am asking you this because as said in the reference,...

Hello Guys,

My SQL 2005 MSDB database is put in SUSPECT mode, that has lot number of jobs and Sprocs. I dont have any backup of MSDB.

I have tried the following...

@Sayfrend,

1) I have checked and Broker Service is enabled for my MSDB,

2) About Port 25 :let me put a fact here.. I have other mail profiles configured through...