And if you schedule the package and run the job?

So your FTPtask hangs. I'm sorry, I am at a loss there. Does checking the Current activity tell you anything? Have you checked the processes in Taskmanager?

David, I'm not sure if I'm of any help, just been dabbling into FTPtask myself with probnlems of my own. However, I think your question is to vague. Ofcourse you...

Tnx for responding, Victor. You say: You may be getting this error message...

There are non-clustered indices. However, it does not happen always, and it happens not always with the same...

Tnx for responding, guys, this answers the What are they. It still leaves the Why do I receive the error, sometimes and on different tasks?

Tnx for the info. This table indeed has no clustered index/primkey. It was deemed not necessary. I'll give this a try and see what happens next time. Very informative posting,...

Tnx, this sounds promising and I am going to give it a try. Cuurently I am struggling with another problem, related to this 1: see http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=114219

If you have an...

Tnx for the info. I'll have to do this in smaller bathces then.

Awright! I stand corrected.

When I google the i-net for this message I find something completely different. (http://support.microsoft.com/default.aspx?scid=kb;EN-US;294999)

Since none of the possible answers given even hints on the possible cause...

Holdit,holdit,

Are you telling me, that when I start a job via EM on my workstation it runs under MY securityaccount, and not under the SQLServerAgent account of the machine involved?!...

It has become more weird! I found an article with a possible solution, which simply comes down to accepting the (only) profile for the Microsoft Exchange profile, stopping and starting...

Another very good question. Had to google the internet to find the answer. I did not no it was possible to place a database on a remote drive; on some...

I have configured a masterserver with it's servername, not IPadress. I have created linkedserver connection on the future targetserver, first with the servername, then also with it's ipaddress. Makes no...

So here I am playing with this functionality. Now I run into a problem. I'm trying to enlist a server, which is in USA, behind a firewall. We can connect...