Hi,
I just started using SQL server integration services. It looks me very buggy
and hangs so frequently. When i select a table name as a oledb sources it
hangs there. Some times the package does n't open saying the package has been
deleted or moved. Has anybody faced similar kind of problem/

Thanks
Swayam

Whilst I do not doubt there are a few things that need ironing out in the
product on the whole I would say it is pretty much fit for purpose.

Can you describe the steps you take to build your package and include
colours of objects (Red:Yellow:Green:Grey).

Is the source table large?

What does the Output window say?

When does it say that the package has been removed or deleted?



--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"SSIS 2005 Hangs" <SSIS 2005 Hangs (AT) discussions (DOT) microsoft.com> wrote in
message news:1B4DBDF7-638E-4F0A-A6DC-F3BCDE1CF6CA (AT) microsoft (DOT) com...

Thanks Allan,
Let me describe in more detail what problem i am getting.
We are testing sql 2005 before we decide our production environment to
migrate to 2005. I installed SSIS. Do i need to configure anything (like in
SQL reporting services) after installation.
I went BIDS, open up a new project and trying to create a text extract file
from a view.
I created a datflow, with oldedb source and flat file destination. I right
click on oledb source and edit it, I set up the server and database
connection, and trying to select the view, and at that place when i clcik ok,
the windows doesn't come back and hangs. When i click on the screen, on
bottom right corner, a pop up comes , and sayd" Microsoft visual studio is
busy doing an internal operation. if you find this problem in a regual basis,
please report to microsoft". a select * from this view usually takes 20 mins.
I have waited 2/3 hrs for the screen to comeback. But it doesn't/ Finally i
kill the process from task manager. Next time when i try to open the same
package from the SSIS project by right clciking the package, it says, the
document you are trying to open is moved or deleted.
No idea whats going wrong. Any insite is helpful
Thankyou in advance to all of you.

Hi,

It isn't necessary to configure BIDS in a way comparable to the RS2005
configuration tool.

I wasn't sure from your description if you had successfully created a
package from the relevant server i.e. only the view you mention fails
or if every time you attempt to use that server as a source data store
there is a hang.

BIDS does hang occasionally but usually for maybe 10-30 seconds. I
asked during the Beta phase and, if I remember correctly, MS couldn't
repro the problems. They were much more marked in early builds but
still do occur occasionally. Just curious, you didn't by any chance
leave the machine running overnight? In very early builds there was a
hang problem which only affected people i.e. me who left BIDS running
overnight. It was fixed (at least for me).

SP1 is now available. It is available at
http://www.microsoft.com/downloads/d...6-e7cac58fd4bc.
I haven't installed it yet but it is supposed to have several bug
fixes. I do hear, however, of some problems about applying SP1 so
maybe hold fire on that meantime.

Andrew Watt [MVP]

On Wed, 19 Apr 2006 11:46:02 -0700, SSIS 2005 Hangs
<SSIS2005Hangs (AT) discussions (DOT) microsoft.com> wrote:

Hi,
The problem what I find now is , select * from the view takes long long time
now in sql 2005. Select * from that particular view was taking 18 to 20 mins
in Sql 2k to process 4.2 million records, but when i run the select * from
the same view in sql 2005 , the execution plan is different now and it
executes 20000 rows /20 mins. Do you have any idea why the execution plan
changes for the same view in 2005. and pickup a poorly performing plan . What
i need to do to fix it.

Thanks
Swayam

Have you updated the statistics (if this is a converted DB)

The optimiser may well choose a different plan but my first port of call
would be the stats

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"SSIS 2005 Hangs" <SSIS2005Hangs (AT) discussions (DOT) microsoft.com> wrote

Yes I have updated the statistics. Still doesn't help. Takes long time now.

Any sugestion??

Thanks

Look at the query plan. What is different about this version and the 2K
version

You may get better help in the programming NG

Take a look over here

http://forums.microsoft.com/MSDN/Sho...ID=85&SiteID=1

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"SSIS 2005 Hangs" <SSIS2005Hangs (AT) discussions (DOT) microsoft.com> wrote

I could fix the problem. Just want to share this with everyone.

I have a view called sales_vw which has many table joins and fairly
complicated and select * from this view takes 20 minutes in sql 2000 to
process 4.2 million records. when i updated to 2005, the query plan changes
and now the same select * from the view process 20000/20 minutes. I shuffled
the ordering of table joins, used index hints. Iinterstingly the execution
plan changes in which order you join the table in sql server. Now the the
updated view runs in 10 minutes on 2005. but if i take and execute select *
from this updated view in the old sql 2000 (in another instance), it runs
for 40 minutes.
The the updated view's query plan again changes in sql 2000.
Amazing!!

Swayam