XML Source, Created From Managed DTS, Getting An Error

Hi,

I am stepping into the world of developing SSIS packages as part of a project I am working on, and I am kicking the tires at the moment, and I am having a couple of problems.

First, is there a really good source of 'how-to's in terms of developing against SSIS. There is plenty of documentation on MSDN/Technet, but there are NO books which cover managed DTS in ANY kind of depth.

Secondly, I am looking at bringing in an XML file programatcially, and linking in the columns I need. Works fine using the BI tools, but I get an error when I do it from visual studio.

The following code :




Code Block
IDTSComponentMetaData90 xmlinputfile;
Package package = CreatePackage("SSISPackage", "Test Package");
MainPipe pipe = AddDataFlowTask(package);
pipelineEvents = new ComponentEvents();
xmlinputfile = pipe.ComponentMetaDataCollection.New();
// configure it up...
xmlinputfile.ComponentClassID = "Microsoft.SqlServer.Dts.Pipeline.XmlSourceAdapter, Microsoft.SqlServer.XmlSrc, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91";
xmlinputfile.Name = "XML Source";
xmlinputfile.Description = "Source data in the data flow...";
CManagedComponentWrapper instance = xmlinputfile.Instantiate();
instance.ProvideComponentProperties();
// At this point you would normally associate with the runtime connection manager,
// but as it is an xml file, we do not need to do that
// We need to set the appropriate properties to look at our xml file...
instance.SetComponentProperty("XMLData", @"C:filechangedtoprotecttheinnocent.xml");
instance.SetComponentProperty("XMLSchemaDefinition", @"C:filechangedtoprotecttheinnocent.xsd");
instance.SetComponentProperty("AccessMode", 0);
instance.SetComponentProperty("UseInlineSchema", false);
// We need to set output connections....
instance.AcquireConnections(null);
instance.ReinitializeMetaData();
instance.ReleaseConnections();

IDTSVirtualInput90 vInput = xmlinputfile.InputCollection[0].GetVirtualInput();
// Iterate through the virtual input column collection.
foreach (IDTSVirtualInputColumn90 vColumn in vInput.VirtualInputColumnCollection)
{

}






When I go anywhere near the InputCollection[0], watch throws an exception, and the call to GetVirutalInput() throws the same exception which is :

System.Runtime.InteropServices.COMException was unhandled by user code
Message="Exception from HRESULT: 0xC0048004"
Source="Microsoft.SqlServer.DTSPipelineWrap"
ErrorCode=-1073446908
StackTrace:
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSInputCollection90.get_Item(Object Index)
at IntegrationServicesScratchPad._Default.btnExecute_Click(Object sender, EventArgs e) in C:Documents and SettingsjMy DocumentsVisual Studio 2005ProjectsIntegrationServicesScratchPadIntegrationServicesScratchPadDefault.aspx.cs:line 75
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Does anyone have any kind of clue as to what is going on. I have seen comments on here from other people in regards to errors with input columns?? The XML files work fine in the editor as I said, and the XSD was generated by the editor using the Generate XSD option.