Hi I created a SSIS package and want to be schedule to run from SQL Server Agent cause error. Find the error below Executed as user: QTS\sqladmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 7:42:49 AM Error: 2011-05-30 07:42:53.00 Code: 0xC0047062 Source: Data Flow Task ADO NET Source [243] Description: System.InvalidOperationException: The 'VFPOLEDB.1' provider is not registered on the local machine. at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.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.OleDb.OleDbConnection.Open() at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction) at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction) End Error Error: 2011-05-30 07:42:53.01 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: component "ADO NET Source" (243) failed validation and returned error code 0x80131509. End Error Error: 2011-05-30 07:42:53.01 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2011-05-30 07:42:53.03 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:42:49 AM Finished: 7:42:53 AM Elapsed: 4.015 seconds. The package execution failed. The step failed. Please anyone help me to solve this issue Regards SVA

The 'VFPOLEDB.1' provider is not registered on the local machine. You need to install the FoxPro drivers on the server running the jobJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: http://mrwharty.wordpress.com/ Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Hi SVA It appears that your SSIS package accessed a Visual Fox Pro data source, but that the machine running the SQL Server Agent does not have the relevant driver installed. I don't know anything about Fox Pro, so I cannot suggest which driver to install, but a search seems to indicate the you need to install the vfpoledb provider from Microsoft. HTHCraig Bryden - Please mark correct answers

Version 9 can be found here http://www.microsoft.com/downloads/en/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: http://mrwharty.wordpress.com/ Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Hi, I already installed Microsoft OLE DB Provider for Visual FoxPro 9.0 on server. It is running from SSIS but not from the SQL Server Agent. Please advise anything to be done on SSMS or agent to run it on schedule. Thanks SVA

Are you running on a 64 bit server? If so, you need to tick the "Use 32 bit runtime" option found on the Execution Options tab of the Job Step Properties as the VFP driver is 32bit.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: http://mrwharty.wordpress.com/ Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Yes i am running on 64 bit server, I select the 32 bit runtime in SSIS and in Agent job. Still not working.

Hi I reinstall the driver again with select everyone option in the VFPOLEDB drivers. that will solve this problem Thanks SVA