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.

No comments:

Post a Comment