Link to home
Start Free TrialLog in
Avatar of Chris Michalczuk
Chris MichalczukFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SSIS Data Flow runs very slow

I am building an SSIS package which runs very fast until I added this step. I want to add all records in a view into the master database.
The step caused the whole package to hang (I turned off DelayValidation property set to True on the task) but it still takes a while (minutes to process either NO records or maybe up to 30 records so not a lot.)

Any suggestions?

I got an error message at one of the runs

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{203E24BD-5203-4C76-AFC7-7C8545EBA1A0}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)). (Microsoft Visual Studio)

------------------------------
Program Location:


Server stack trace:
   at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
   at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100.get_Name()
   at Microsoft.DataTransformationServices.PipelineDesignTimeObject.DoGetName()
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
   at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
   at Microsoft.DataTransformationServices.PipelineDesignTimeObject.GetNameDelegate.EndInvoke(IAsyncResult result)
   at Microsoft.DataTransformationServices.PipelineDesignTimeObject.get_Name()
   at Microsoft.DataTransformationServices.PipelineComponentMetadata.get_Name()
   at Microsoft.DataTransformationServices.Design.DtsComponentDesigner.ValidateComponent(Boolean& reinitializeCalled)
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Would help if you gave us a screenshot of the component, as well as any T-SQL or script.

>I want to add all records in a view
Okay.  Views are connected to tables, so let's see the View T-SQL as well, and the table schemas if that's easy to do.  Could be a foreign key problem, modeling problem, tables have lots of triggers that are firing, lots of things.
ASKER CERTIFIED SOLUTION
Avatar of SThaya
SThaya
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial