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)
Can not connect to a flat file
Bill C
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
yoshita
Dr Sneki
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.
style2joy
Sorry.... I have not visited this in a while. I just changed everything I need to do to script.
Cheers,
Forch
Giovanni Costagliola
.... 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.
Forch
Delphi Skyline
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.