Thursday, March 22, 2012

Can not connect to a flat file

Hi all....

With Visual Studio, I have created a new "Integration Services Project".

As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"

When I do so, I get this error:

The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)

Thanks!

Forch

at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)

.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.

I have tried to remove and re-install Integrated services, but I have had no luck.

Sad

Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||

Hi Scott,

Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help

Any refernce would be helpful.

Thanks in Advance

Phani Kiran K

|||

Hi Forch,

I too have exact problem. Can you remember the solution you had for this problem?

Any reference would be helpful.

Thanks in Advance,

Phani Kiran K.

|||

Sorry.... I have not visited this in a while. I just changed everything I need to do to script.

Cheers,

Forch

|||

Hi

This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine

Regards,

Phani.

No comments:

Post a Comment