Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  SSIS Problems

Author  Topic  sinva Starting Member 23 Posts Posted - 2010-05-23 : 08:56:25 Dear All, I am having a big problem: When I am using nested loop in an Execute SQL Task, there is an error showing exception hresult:0x80040e14 "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly, however the nested loop runs properly when I am using Toad. How could I overcome this problem? Thanks for all help and suggestions. My Execute SQL Task settings are as follows: ResultSet: Single Row ConnectionType: OLE DB SQLSourceType: Direct Input IsQueryStoredProcedure: False BypassPrepare: True