Steve Wang 2006


I am running into some issue that i have found any good clue on this forum... although have seen a few threads dicussions. I have a master package which invokes a dozen of child packages.

1) If I only open master package inside IDE, I am keeping getting the following error when i run the master packages inside Visual Studio 2005 IDE.

The connection type "FLATFILE" specified for connection manager "XXXXX Flat File Destination Connection Manager" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name

2) If I opened up all child packages inside IDE, the master package run fine most of time.

Any suggestions





Re: Package execution stability ?

Phil Brammer


Are you using a connection type of "flat file" or just the "file" connection manager type






Re: Package execution stability ?

Steve Wang 2006

See below please







Re: Package execution stability ?

Steve Wang 2006

It is a flat file type: Here is the error details:

Code Snippet

Error: 0xC0014005 at : The connection type "FLATFILE" specified for connection manager "Load Ready Output Connection Manager" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

Error: 0xC0010018 at : Error loading value "-1Load Ready Output Connection Manager{3A5E4ACC-9BF" from node "DTS:ConnectionManager".

Error: 0xC00220DE at Process Provider Data: Error 0xC0010014 while loading package file "C:\SSIS\newDas\Provider.dtsx". One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.

But I also get this Error in the same time.

Code Snippet

Error: 0xC0014005 at : The connection type "OLEDB" specified for connection manager "Target Database Connection" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

Error: 0xC0010018 at : Error loading value "-1Target Database Connection{CBD29A65-2BBC-4BB6-AED" from node "DTS:ConnectionManager".

Error: 0xC00220DE at Process BenefitPlan Data: Error 0xC0010014 while loading package file "C:\SSIS\newDas\BenefitPlan.dtsx". One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.

SO IT SEEMS THAT THE CONNECTION TYPE IS NOT RECOGNIZED FOR SOME WEIRD REASONS BEHIND....

Help..........






Re: Package execution stability ?

Ovidiu Burlacu

Try to look at this thread and see if the answer solves your problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx PageIndex=4&SiteID=1&PostID=363238&PageID=1

Thanks,

Ovidiu Burlacu






Re: Package execution stability ?

Steve Wang 2006

Thanks. Unfortunately, the link did NOT fix my problem.

I followed Mike's suggestion by creating the application and a non-administrative account. I did not see any incorrect registry key dosplayed. Help !!!






Re: Package execution stability ?

Phil Brammer

What version of SSIS do you have RTM SP1 SP2

Seems like something is corrupt. Any changes to the system recently





Re: Package execution stability ?

Steve Wang 2006

I have tried packages on various machines (RTM on Windows 2003, SP2 on Windows xp Pro ) and the error is repeatable on any machines.

Here is the version info for SSIS from "About" on Visual Studio 2005.

Microsoft SQL Server Integration Services Designer Version 9.00.3042.00






Re: Package execution stability ?

Phil Brammer

Microsoft follow-up:

I can create a simple package (OLE DB Source -> Flat File Destination) and recreate this error by opening the resulting .dtsx file in my favorite text editor. When doing so, searching by CaSE and replacing "FLATFILE" with "FLATFILE2" yields the same error message as Steve has indicated. Obviously, FLATFILE2 is not a valid connection manager type. So, with that said, where is the validation occurring to determine if the connection manager type is valid or not And what can Steve do about it





Re: Package execution stability ?

Steve Wang 2006

Thanks Phil for attention.

Here is complete info from package log in attempt to get help here. Any help will be greatly appreciated.

Code Snippet

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
PackageStart,MyComputerNameG,DomanName\MyUserAccount,OMXLoadTransformSequencer,{FC99AFBF-316F-458B-B989-30EC8DC97A45},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:04:56 PM,7/17/2007 3:04:56 PM,0,0x,Beginning of package execution.

OnError,MyComputerNameG,DomanName\MyUserAccount,Process Member Data,{874B05D3-3ED9-453A-BEF5-2595710C0B04},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:17 PM,7/17/2007 3:05:17 PM,-1073659899,0x,The connection type "FLATFILE" specified for connection manager "MembersWithUpdates" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

OnError,MyComputerNameG,DomanName\MyUserAccount,OMXLoadTransformSequencer,{FC99AFBF-316F-458B-B989-30EC8DC97A45},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:17 PM,7/17/2007 3:05:17 PM,-1073659899,0x,The connection type "FLATFILE" specified for connection manager "MembersWithUpdates" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

OnError,MyComputerNameG,DomanName\MyUserAccount,Process Member Data,{874B05D3-3ED9-453A-BEF5-2595710C0B04},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:17 PM,7/17/2007 3:05:17 PM,-1073676264,0x,Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="DelayValidation">-1</DTS:Property><DTS:Property DTS:Name="ObjectName">MembersWithUpdates</DTS:Property><DTS:Property DTS:Name="DTSID">{D6867FEB-27D8-4576-80CB-A53449" from node "DTS:ConnectionManager".

OnError,MyComputerNameG,DomanName\MyUserAccount,OMXLoadTransformSequencer,{FC99AFBF-316F-458B-B989-30EC8DC97A45},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:17 PM,7/17/2007 3:05:17 PM,-1073676264,0x,Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="DelayValidation">-1</DTS:Property><DTS:Property DTS:Name="ObjectName">MembersWithUpdates</DTS:Property><DTS:Property DTS:Name="DTSID">{D6867FEB-27D8-4576-80CB-A53449" from node "DTS:ConnectionManager".

OnError,MyComputerNameG,DomanName\MyUserAccount,Process Member Data,{874B05D3-3ED9-453A-BEF5-2595710C0B04},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:17 PM,7/17/2007 3:05:17 PM,-1073602338,0x,Error 0xC0010014 while loading package file "C:\SSIS\DasLoader\Member.dtsx". One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.
.

OnError,MyComputerNameG,DomanName\MyUserAccount,OMXLoadTransformSequencer,{FC99AFBF-316F-458B-B989-30EC8DC97A45},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:17 PM,7/17/2007 3:05:17 PM,-1073602338,0x,Error 0xC0010014 while loading package file "C:\SSIS\DasLoader\Member.dtsx". One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.
.

OnTaskFailed,MyComputerNameG,DomanName\MyUserAccount,Process Member Data,{874B05D3-3ED9-453A-BEF5-2595710C0B04},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:17 PM,7/17/2007 3:05:17 PM,0,0x,(null)
PackageStart,MyComputerNameG,DomanName\MyUserAccount,BenefitPlan,{48289F86-1429-44B0-B5F7-295F31B6F39E},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:22 PM,7/17/2007 3:05:22 PM,0,0x,Beginning of package execution.

PackageStart,MyComputerNameG,DomanName\MyUserAccount,CustomInformationCodeLookup,{C4C5D8F8-CD26-4C94-ADB4-D40607F67D70},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:29 PM,7/17/2007 3:05:29 PM,0,0x,Beginning of package execution.

PackageStart,MyComputerNameG,DomanName\MyUserAccount,Provider,{6F1B4233-8A08-4688-827F-FB98DC7F975F},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:30 PM,7/17/2007 3:05:30 PM,0,0x,Beginning of package execution.

PackageEnd,MyComputerNameG,DomanName\MyUserAccount,CustomInformationCodeLookup,{C4C5D8F8-CD26-4C94-ADB4-D40607F67D70},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:31 PM,7/17/2007 3:05:31 PM,0,0x,End of package execution.

PackageEnd,MyComputerNameG,DomanName\MyUserAccount,BenefitPlan,{48289F86-1429-44B0-B5F7-295F31B6F39E},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:36 PM,7/17/2007 3:05:36 PM,0,0x,End of package execution.

PackageEnd,MyComputerNameG,DomanName\MyUserAccount,Provider,{6F1B4233-8A08-4688-827F-FB98DC7F975F},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:47 PM,7/17/2007 3:05:47 PM,0,0x,End of package execution.

PackageEnd,MyComputerNameG,DomanName\MyUserAccount,OMXLoadTransformSequencer,{FC99AFBF-316F-458B-B989-30EC8DC97A45},{83B517B1-622A-4015-A99E-64944A225E09},7/17/2007 3:05:47 PM,7/17/2007 3:05:47 PM,0,0x,End of package execution.






Re: Package execution stability ?

Saurabh Kulkarni

Hi Steve,

Just came across this page in Microsoft support site. See if this helps you.

http://support.microsoft.com/kb/913817/en-us

Regards

Saurabh





Re: Package execution stability ?

Phil Brammer

Saurabh Kulkarni wrote:

Hi Steve,

Just came across this page in Microsoft support site. See if this helps you.

http://support.microsoft.com/kb/913817/en-us

Regards

Saurabh

He's followed the steps in that KB article already and no "bad" registry keys were identified.






Re: Package execution stability ?

Phil Brammer

[Microsoft follow-up]
again.

Come on guys.





Re: Package execution stability ?

Jeff Bernhardt - MSFT

something looks funny with this text from the error message:

Error loading value "-1Load Ready Output Connection Manager{3A5E4ACC-9BF" from node

almost as if the xml parsing has gone bad. the guid is chopped off and the string starts with -1.

do you have any objects with odd characters in the names. characters that could mess up a parser like < > " , - etc.






Re: Package execution stability ?

Steve Wang 2006

Thanks for Microsoft's help coming out...

No, I checked packages and do not have/see any objects that contains weird name etc. Please take a look at my longer posting above.

The observation is that all of packages run successfully sometimes, while failed on the other times. It is not stable. I repeatedly re-run my packages above yesterday without any failure. But today it starts to fail occasionally.

If the packages contains object names with special characters, the packages should always fail.

I would be very willing to send you via email the four small and simple packages.

Steve