Trying to import an excel file using SSIS.

 

For this error,

 

Solution available in Web,

 

Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"

Applies to: Microsoft SQL Server 2005 Standard EditionSQL Server 2008 StandardMicrosoft SQL Server 2005 Enterprise Edition More

---

Symptoms

---

On a 64-bit computer, you install an instance of the 32-bit (x86-based) version of Microsoft SQL Server. On the same computer, you install an instance of the 64-bit version of SQL Server 2008. If you then uninstall the 64-bit instance, you receive the following error message when you open SQL Server Configuration Manager:

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace [0x8004100e]

This problem also occurs if you uninstall the 32-bit instance, and you then open SQL Server Configuration Manager.

Cause

---

This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server. The 32-bit instance and the 64-bit instance of SQL Server share the same WMI configuration file. This file is located in the %programfiles(x86)% folder.

Workaround

---

To work around this problem, open a command prompt, type the following command, and then press ENTER:

mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"

Note For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.

The value of number depends on the version of SQL Server:nnn

Microsoft SQL Server 2012	110
Microsoft SQL Server 2008 R2	100
Microsoft SQL Server 2008	100
Microsoft SQL Server 2005	90

After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.

Status

---

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

---

Installing a 32-bit instance of SQL Server 2008 in a 64-bit cluster environment is not supported. For more information about the Microsoft SQL Server support policy, click the following article number to view the article in the Microsoft Knowledge Base:

327518 The Microsoft SQL Server support policy for Microsoft Clustering

For additional information about Managed Object Compiler (Mofcomp) tool, consult the following page on MSDN:

http://msdn.microsoft.com/en-us/library/windows/desktop/aa392389(v=vs.85).aspx

 

Investment Research Analytics

Investment Research using Data Warehouse.

What is FSB ? Fund’s Sentiment Beta.

Recent advances in Behavioural finance have shown that stock prices are affected by “Sentiment”.

When investor sentiment is high, the low-sentiment-beta stocks (i.e the stocks with negative loading on sentiment) are undervalued and their subsequent returns are higher. As per the white paper by Massimo Massa & Vijay Yadav, the low-sentiment-beta stocks significantly outperform the high-sentiment-beta stocks. This also suggest that an ideal trading strategy for asset manager interested in maximizing performance is to invest mostly in low-sentiment-beta stocks.

This strategy would definitely be more efficient if asset managers were not only able to identify the degree of sentiment loading of the stocks (i.e whether they are high- or low-sentiment-beta stocks) but also predict the degree of market sentiment.

News about the financial market can be found on news websites, social media, blogs, and forums. Automating the extraction of relevant data using web scrapers provides businesses with constant updates about the general population’s sentiment about specific products or brands, and enables financial leaders to predict the success or failure of certain stocks or ETFs in the market.

Additionally, some web scrapers integrate IP proxies to extract web data about specific geographical regions. This can be useful for businesses to analyze the financial market in a targeted region and optimize their financial strategies accordingly.

Journey to Peak

 Data Architect

Visionary in the D company. Its the data world. And to see it from a architect's perspective is dreamy as well as sad. 

When you design something, you want it to be perfect. But we know sometimes it takes a lot of effort to even build a sand castle. Now imagine creating a castle out of all the data which is generated by so many events in real world.

A single button click creates atleast 3 data points, ip, hyperlink, response time.

So designing a Mutual fund data Warehouse is an enormous Job. 

We have to think from the business perspective. Now one of the case is driving the Achievements of the sales team. 

Scenario: An AMC has different schemes and products. They also have different channels to make 

was thinking about brokerage.

Trade monopoly is a disaster in growing stage. Brokerage is another. Although i understand that brokering is a healthy process for certain regions and profession.
For example brokers in trading. They seem to have a legit process and worthy of brokerage cuz of there knowledge regarding the market. But in case of renting a home. They take too much for just the information.

Telangana bill not coming in monsoon session - The Hindu

Telangana bill not coming in monsoon session - The Hindu


Shinde thinks its some kind of crop. Will grow in 6 months. Sucker. Ruining my country. And shame on me for sitting here and typing instead of doing something to undo this.

Was thinking abt a complete desi industry oriented country

May be seems like a misplled idea. But imagine even the smileys with indian scent. What i am trying to say is when i looked for appropriate smiley to ping my friend asking him abt the plan. I didnt find one. I should. I wud have if these computers had slight Indian touch in there invention or modificaion.

learnt about Prunes

Prunes are used in cooking both sweet and savory dishes. Stewed prunes, a compote, are a dessert. Prunes are a frequent ingredient in North African tagines. Perhaps the best-known gastronomic prunes are those of Agen (pruneaux d'Agen). Prunes are used frequently in Tzimmes, a traditional Jewish dish in which the principal ingredient is diced or sliced carrots; in the Nordic prune kisel, eaten with rice pudding in the Christmas dinner; and in the traditional Norwegian dessert fruit soup. Prunes have also been included in other holiday dishes, such as stuffing, cake, and to make sugar plums. Prune filled Danish pastries are popular primarily in New York and other parts of the U.S. East Coast. Prune ice cream is popular in the Dominican Republic. Prunes are also used to make juice.