December 24, 2008 at 4:09 pm
Hi all,
(SSIS SQL 2008)
The situation is that I am trying to extract information via ODBC from a system we have.
I have the drivers installed on my machine and have added DSNs for each system. In SSIS I have added them in the server explorer and can view all the details through this.
To extract the information I have added the DSN as .Net Providers\Odbc Data Providers which when tested via the Test Connection Button was successful.
I have then added a Data Flow Task within which I have added a ADONet Data Source. Here is where my problems begin...
I set Connection Manager in the Connection Managers tab and the enter a simple SELECT * FROM in the sqlCommand custom property.
and when click Preview I get the following error Message (Below)and I cant see any columns in the section
===================================
There was an error displaying the preview. (Microsoft Visual Studio)
===================================
------------------------------
Program Location:
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at Microsoft.DataTransformationServices.Design.PipelineUtils.ShowDataPreview(String sqlStatement, DbConnection connection, Control parentWindow, IServiceProvider serviceProvider, IDTSExternalMetadataColumnCollection100 externalColumns)
at Microsoft.DataTransformationServices.Design.PipelineUtils.ShowDataPreview(String sqlStatement, ConnectionManager connectionManager, Control parentWindow, IServiceProvider serviceProvider, IDTSExternalMetadataColumnCollection100 externalColumns)
at Microsoft.DataTransformationServices.DataFlowUI.DataFlowConnectionPage.previewButton_Click(Object sender, EventArgs e)
April 18, 2011 at 11:22 am
Hi,
Have you had any luck resolving this issue as I have a similar problem.
Cheers
eric
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply