Time out and don't know what to do.

• pbakos 55417

  SSC Enthusiast

  Points: 121

  More actions

  August 3, 2015 at 10:47 am

  #74277

  I am by no means an expert at writing packages and am having a lot of problem with a process that did work and now does not. This is the error that I get when just trying to Preview.

  ===================================

  There was an error displaying the preview. (Microsoft Visual Studio)

  ===================================

  Query timeout expired (Microsoft SQL Server Native Client 10.0)

  ------------------------------

  Program Location:

  at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)

  at System.Data.OleDb.OleDbDataReader.NextResult()

  at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)

  at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)

  at System.Data.OleDb.OleDbCommand.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)

  My test of the data connection works, I can actually return data from a table but I am trying access a view and that is where I get this error. Any help would be greatly appreciated. 😀