Archive for November, 2010

SSIS–Excel Connection Manager Error November 29th, 2010

Vinod Kumar

Yesterday, I was playing with SSIS on my host machine and had bumped into an interesting error:

[Load Promotion Data [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

[SSIS.Pipeline] Error: component "Load Promotion Data" (1) failed validation and returned error code 0xC020801C.

[Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

Now this looked interesting because I was on a x64 bit OS, x64 bit on SQL Server but had a x86 (32 bit) Office 2010 installed when I was using my Excel Data Source. These errors were taken as-is from the “Execution Result” tab directly. The errors give away some detail that this combo is the problem. But fundamentally various search yielded me into places which stated I need to run SSIS in a x86 mode. And this is well hidden inside the Project –> Properties tab –> Configuration Properties –> Debugging menu.

image

Just turn the “Run64BitRuntime” option to “False”. And go ahead with your build !!! This just solved my problem.

Continue reading...


 

Denali–DTS Support November 26th, 2010

Vinod Kumar

It is high time that we started looking at moving our age old DTS packages back into SSIS with full fledged functionality soon. Just checked the SSMS on the CTP1 to figure out that under the Legacy system, this has gone missing.

image

Moving to the new features is always advised and make sure to keep an eye into the support for way old features that you are likely to still have around as you plan for your migration or upgrade. All the best !!! The documentation will surely have a note, but as we start playing around I am getting to know of these one by one …

Continue reading...


 

Denali–Extended Events November 24th, 2010

Vinod Kumar

As I installed Denali (next version of SQL Server) on my machine, I have been trying to figure out what all have been added as part of this CTP1. On playing around with the SQL Server Management Studio I found something very interesting –

image

Now Extended Events in completely integrated inside of SQL Server and this is such a cool thing. Though there is very less we can do with this in this CTP1 release. I just tried to query from the database to figure out that the there are tons of events and actions already there inside the database.

image 

I am sure the subsequent CTP’s we are sure to see more of this xEvents infrastructure. As shown in the figure 1, there is already an Event on System_Health check which has been configured out-of-box. Interesting to play around, you can script it out and check how it has been configured. Remove the grouping and the wealth of events and actions come out …

More on this later, but you get the point. Extended Events are now part of UI and lots of fun things are coming round the corner !!!

Continue reading...


 

Denali – TSQL Paging November 15th, 2010

Vinod Kumar

I am slightly late on writing about next version of SQL Server release. But here you go – SQL Server “Denali” CTP1 is available for download from the Microsoft Download Center here. Best part is I got did download and get the instance of SQL Denali side-by-side with SQL 2008 R2 instance. These work just as expected even in the current CTP1.

As soon as I got the instance running was looking for something interesting. And this TSQL enhancement caught my attention. All of us do Paging and we do tons of gimmicks to get this working in our application. Now there is a much more Simplified result-set paging via new ANSI standard OFFSET clause within SQL Server natively.

select * from sys.objects
Order by name
Offset 5 rows
Fetch Next 10 Rows ONLY;

You can see how easy now paging is with SQL Server. I will explore the “Improved generation of numeric identifiers using new SEQUENCE object.” and post a simple sample soon.

So what are you waiting for? Download and post me what you found interesting with SQL Server Denali CTP1 …

Books On-Line: Programmability Enhancements topic here.

Continue reading...


 

Composite Service Application Guidance CTP1 November 7th, 2010

Vinod Kumar

The goal of this guidance developed by patterns& practices team is to provide best practices to implement the most common SOA Patterns and  Integration Patterns.

P&P Team published the first public community preview here, which contains reusable source code and samples to illustrate the following patterns and scenarios for enterprise customers:

  • Repair and Resubmit pattern – this pattern is implemented in ESB Toolkit 2.0 as part of Exception Management Framework (EMF). This code drop provides a code sample showing how to implement this pattern for Windows AppFabric workflow service, Exceptions Web Service and workflow activities to create fault message.  In addition, we included a sample Operations service to allow integrating ESB Management Portal from ESB Toolkit to browse fault messages and fault report metrics generated by applications that leverage Windows Server AppFabric.
  • Analytic Tracing – this code drop contains reusable code and samples for implementing ETW tracing, which includes event collector service and database to store collected events. This capability may be used for scenarios that need flexibility on how collected events are decoded and processed using extensibility points you can configure and/or implement as plugins and event decoders while leveraging ETW tracing capabilities provided by the event collector service.  
  • Inventory Centralization patterns – this code drop contains a service catalog database, web services, utility and samples to show how to implement service Metadata Centralization and Policy Centralization patterns. 
  • Service Governance patterns – this code drop contains reusable code and samples to illustrate how to define service business metrics and collect these metrics using analytic tracing and policy centralization capabilities.
  • Service Virtualization pattern – we included a sample for implementing this pattern using WCF routing service( which is part of .NET framework) and service metadata centralization capabilities to define routing service metadata in service catalog.

Continue reading...