HELP!!!!! Error Thrown by Connections Collection SSIS Package

[bmann]

Hello,

I keep getting error thrown by connections collection when the specific element is not found in my ssis package. I recreated my connection managers and still the same problem. Problem points to SQLTask:Connection="{293CC3EC-C94E-4F99-8FFA-DE627F0C821C}". Here is the problem in XML below:


S:Name="DisableEventHandlers">0</DTSroperty><DTS:ObjectData><SQLTask:SqlTaskData SQLTask:Connection="{293CC3EC-C94E-4F99-8FFA-DE627F0C821C}" SQLTask:TimeOut="0" SQLTask:IsStoredProc="False" SQLTask:BypassPrepare="True" SQLTask:SqlStmtSourceType="DirectInput" SQLTask:SqlStatementSource="select count(*) from dbo.temp_t_Entity" SQLTask:CodePage="1252" SQLTask:ResultType="ResultSetType_SingleRow" xmlns:SQLTask="

http://www.microsoft.com/sqlserver/dts/tasks/sqltask"><SQLTask:ResultBinding

SQLTask:ResultName="0" SQLTasktsVariableName="User::InitialRemote_Temp_t_EntityCount"/></SQLTask:SqlTaskData></DTS:ObjectData></DTS:Executable>
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="3">

 

[bmann]

Hello,

I keep getting error thrown by connections collection when the specific element is not found in my ssis package. I recreated my connection managers and still the same problem. Problem points to SQLTask:Connection="{293CC3EC-C94E-4F99-8FFA-DE627F0C821C}". Here is the problem in XML below:


<DTSroperty DTS:Name="DisableEventHandlers">0</DTSroperty><DTS:ObjectData><SQLTask:SqlTaskData SQLTask:Connection="{293CC3EC-C94E-4F99-8FFA-DE627F0C821C}" SQLTask:TimeOut="0" SQLTask:IsStoredProc="False" SQLTask:BypassPrepare="True" SQLTask:SqlStmtSourceType="DirectInput" SQLTask:SqlStatementSource="select count(*) from dbo.temp_t_Entity" SQLTask:CodePage="1252" SQLTask:ResultType="ResultSetType_SingleRow" xmlns:SQLTask="

http://www.microsoft.com/sqlserver/dts/tasks/sqltask"><SQLTask:ResultBinding

SQLTask:ResultName="0" SQLTasktsVariableName="User::InitialRemote_Temp_t_EntityCount"/></SQLTask:SqlTaskData></DTS:ObjectData></DTS:Executable>

 

[SQLScholar]

Do you know where this piece of code is from?

select count(*) from dbo.temp_t_Entity

If so go find the task thats assigned to it and check the connection that its using is valid.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[SQLScholar]

And you may get better results for your question in the SSIS forum.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------