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) ------------------------------
hi Satya, not really, its a simple package that is gettiing info from SQL Server using ODBC Navision native driver Any advice?
In this case you need to perform detailed loggin of the package to find out where exactly this is failing - http://sqlserver-qa.net/blogs/tools...ging-providers-make-best-use-of-ssis-too.aspx fyi on performing the task.
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.
hi satya, i also set the delayvalidtion to true , but still having the same error, any more clues ... thks