Creating SQL Server 2008 R2 DTSX from C# - Exception from HRESULT: 0xC0048021
I'm creating a dtsx from C# (.NET 4.0) but when I try add the OLEDB Source into the data flow and is time to execute the ProvideComponentProperties step, I recieve the following error in VS2010: Exception from HRESULT: 0xC0048021
This is part of the code I'm using:
//add SQL destination
IDTSComponentMetaData100 SQLDestination = dataflowTask.ComponentMetaDataCollection.New();
SQLDestination.ComponentClassID = "DTSAdapter.OleDbSource.1";
// Set the common properties
SQLDestination.Name = "SQLDestination";
SQLDestination.Description = "SQL destination";
CManagedComponentWrapper SQLDestComponent = SQLDestination.Instantiate();
SQLD开发者_如何学CestComponent.ProvideComponentProperties(); // The error happens here
I am using SQL Server 2008 R2 SP1 and C# .NET Framework 4.0
You are limited to VS2008 and .NET 3.5 for SQL2008 R2.
精彩评论