check the error log

script data

Do u have any server...

and system stored procedure like sp_lock ,sp_helpdb

What in error log??

wat port number u using for gmail??

Try using SQL Authentication..

Thanks a ton Vani..:-)

Do you have any other heavy jobs running at the same time??

Are you using windows authentication??

Whats your server configuration?

Are you remotely accessing the server or configuring job from any client machine??

whats your query timeout??

Hope you tried DBCC CHECKDB from query windows,wats...

Do u have any fixed time for transfering data from CE to server?

Is it possible to take backup from CE before deleting the data?

Thanks Vyas,

But how??

GilaMonster (5/7/2010)

---

Again, it doesn't need to be installed on the server.

Then how can i create a new integration service package there in that server??

Thanks Gail,

That server is dedicated for SSIS but they forgot to install BIDS 😛

Thanks Raunak,

I selected the link http://www.databasejournal.com/features/mssql/article.php/3600201/SQL-Server-2005-Integration-Services---Packages-Deployment---Part-23.htm.

I hope i selected the right one..

Is ther any link for SQL 2008?