Saturday, February 13, 2010

VS 2010 RC installation

Installed VS 2010 RC successfully. List of things to keep in mind while installing

1. Uninstall VS 2010 beta 2
2. Uninstall .NET 4.0 (there are two items related to this that you have to uninstall)
3. Any VS 2010 Office development components

If you are developing azure applications

1. Uninstall Azure SDK
2. Uninstall VS 2010 and VS 2008 tools for Azure

----------------------------------------------------------
a] Install VS 2010 RC
b] Install VS2010 RC TFS Client

c] Install Azure SDK (1.1)
d] Install Feb 2010 release of Azure tools (not NOV 2009)

VS 2010 RC and SilverLight Client Proxy with collections

I have this application. Some of the data types in server application are collections of type ObservableCollection.

Example:
public class VisitCounts : ObservableCollection[visitcount]
{
}

In VS 2008 silverlight client application generates a proxy where I can still reference ObservableCollection in e.Result (of async calls).

For whatever reason, VS 2010 RC is not able to generate proxy with these special collection types (even after tweaking the advanced options).

Friday, February 05, 2010

SSIS and MERGE statement

I encountered an error while working on a DW/ETL project.

If you are using dynamic connection manager settings in your SSIS packages, you some how set the connection string as follows

Provider=SQLOLEDB.1;Initial Catalog=MYDB;Data Source=(local);User ID=myuser;Password=myPassword;

Well this works just fine as long as you are NOT using any of the SQL Server 2008 new features.

In my case, I had to use MERGE statement and above connection string did not work. After spending couple of hours, I found out the issue. You have to make sure that, new provider will be used in your connection string. The connection string should look like this.


Provider=SQLNCLI10;Initial Catalog=MYDB;Data Source=(local);User ID=myuser;Password=myPassword;

Hope this helps....

Followers