SSIS package reacts slow in BIDS

Question

Post reply

SSIS package reacts slow in BIDS

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I'm trying to find out where to specify to work offline so that I can delete a bunch of tasks (hundreds).

Does anyone know how to do this?

I heard that it is the equivilent to disconnected edit in DTS.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I found the work offline and it is no help.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I tried it on a Server that I set up at the beginning of the month and I did not have the issue.

I broke up the package quickly on that Server into 3 packages and I still have the problem.

I kept getting the message Visual Studio needs to restart, find a solution or restart.

So I have the issue on my PC and a Development DB Server which I have been working from.

I recall that BIDS crashed and I started having the problem.

Checked the Windows Application Log and no hints.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

archie.gilbert Grasshopper Points: 21 More actions · Answer 4

I have been having headaches with a new installation of BIDS on my laptop. Whenever I opened a package from a solution file, the validation would take forever and eventually hang-up the BIDS environment. I found that by editing the hosts file under system32/drivers/etc fixed the issue. Now loading a package in the designer takes seconds as compared to hours before and no lock-up of BIDS.

Johan van der Wilk Grasshopper Points: 24 More actions · Answer 5

We had the same problems. Tried everything disabling parts of bids, removing bids, cleaned registry, latest SP with CU, checked hardware, battery cache raidcontroller ...., but adding an entry to the servers hosts file did the job: 127.0.0.1 a3842.akami.atom86.net and everything responses normal.