SQL Server Performance

Package Validation Error

Discussion in 'SQL Server 2005 Integration Services' started by Akthar, May 26, 2009.

  1. Akthar New Member

    Hi team,
    i am having the following error when executing an SSIS package. The package uses Microsoft Navision Native ODBC connection. The control Flow does not execute as a whole, BUT when executing the data flow task INDIVIDUALLY IT WORKS FINE.
    Any Advice guys
    TITLE: Package Validation Error
    ------------------------------

    Package Validation Error

    ------------------------------
    ADDITIONAL INFORMATION:

    Error at Populate mis_CustLedgerEntry [DataReader Source [683]]: System.Data.Odbc.OdbcException
    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
    at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
    at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    at System.Data.Odbc.OdbcConnection.Open()
    at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction)
    at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
    at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
    at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)
    Error at Populate xxxEntry [DTS.Pipeline]: component "DataReader Source" (683) failed validation and returned error code 0x80131937.

    Error at Populate xxxEntry [DTS.Pipeline]: One or more component failed validation.

    Error at Populate xxxEntry: There were errors during task validation.

    (Microsoft.DataTransformationServices.VsIntegration)

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


  2. satya Moderator

    Are you trying to encrypt the package?
  3. Akthar New Member

    hi Satya,
    not really, its a simple package that is gettiing info from SQL Server using ODBC Navision native driver
    Any advice?
  4. satya Moderator

  5. satya Moderator

    Ok, as I revisited the Q that you are using Navison driver to connect and in thsi case check whether:
    DelayValidation = True
    has been set on data flow task. Also I would like to ask to check on that Vendor's resource to see whether compatible drivers are available.
  6. Akthar New Member

    hi satya,
    i also set the delayvalidtion to true , but still having the same error,
    any more clues ... thks

Share This Page