|
|
You're in the
sql server dts
group:SSIS
sql server dts:
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
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.
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@discussions.microsoft.com> wrote in message news:1B4DBDF7-638E-4F0A-A6DC-F3BCDE1CF6CA@microsoft.com... [quoted text, click to view] > 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
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/details.aspx?displaylang=en&FamilyID=cb6c71ea-d649-47ff-9176-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 [quoted text, click to view] <SSIS2005Hangs@discussions.microsoft.com> wrote:
>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,
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
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 [quoted text, click to view] "SSIS 2005 Hangs" <SSIS2005Hangs@discussions.microsoft.com> wrote in message news:327AAD99-FD33-4C96-8221-654F00503A9F@microsoft.com... > 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
Yes I have updated the statistics. Still doesn't help. Takes long time now.
Any sugestion??
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/ShowForum.aspx?ForumID=85&SiteID=1 -- Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com [quoted text, click to view] "SSIS 2005 Hangs" <SSIS2005Hangs@discussions.microsoft.com> wrote in message news:A20C57FF-3FF6-425F-8B48-893E9398C089@microsoft.com... > Yes I have updated the statistics. Still doesn't help. Takes long time > now. > > Any sugestion?? > > Thanks
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
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |