x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 42 subscribers
  • Views 3632 views
  • Users 0 members are here
Browse Forums
Announcements
68
topics
93
replies
Customization and Integration
262
topics
822
replies
Financials, Projects, and Administration
382
topics
843
replies
General Discussion
327
topics
836
replies
Installation and Technical Issues
335
topics
1k
replies
Manufacturing, Distribution, and Applications
341
topics
696
replies
Reporting and Analytics
124
topics
481
replies
Wilbs

How to Install SQL Component "FlatFileProvider"?

SUGGESTED
Posted By

In Data Import Manager > Maintain Source Connection, I'm creating a new connection to a comma-delimited file.  I'm selecting "Flat Text File" as the type.  I'm getting the following error when I try to save it:

Unable to preview the text file contents.  A required SQL Server component has not been installed ("FlatFileProvider").  See Data Import Manager Installation and Configuration help.

This is SQL Server 2008.  I started up the installation again and installed all previously uninstalled components, but the error persists.

Anyone?

Thanks!!

  • 0

    The Data Import Manager uses SSIS (SQL Server Integration Services) which is where the flat file provider is used. So first check to ensure that SSIS is up and running.  If it is running, have yourself or one of your IT people try to create a simple SSIS package that imports from a flat file to see if it works correctly.

  • 0 in reply to LouDavis
    SUGGESTED
    Sage has a complete knowledge base article on this subject as follows:

    Error: "Unable to preview the text file contents. A required SQL Server component has not been installed (FlatFileProvider)..."
    Products
    Sage 500 ERP


    Description

    Getting the following error in Data Import Manager (DIM):
    Unable to preview the text file contents. A required SQL Server
    component has not been installed (FlatFileProvider). See Data Import
    Manager Installation and Configuration help.


    Disclaimer
    Operating System Warning
    This solution requires advanced knowledge of your computer's operating system. Contact your system administrator for assistance. Modifying your Windows Registry incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Always create a backup of your data before proceeding with advanced solutions.

    Resolution

    Data Import Manager uses SSIS (SQL Server Integration Services), which is where the flat file provider is used.

    First, check to ensure that SSIS is up and running
    If it is running, have yourself or one of your IT people try to create a simple SSIS package that imports from a flat file to see if it works correctly


    On the workstation experiencing the reported error, install the Microsoft Backward Compatibility Components. (Review the Install.pdf, chapter Data Import Manager & Configuration page 186. The Install.pdf is typically installed on Sage 500 client workstation under C:\Program Files (x86)\Sage Software\Sage MAS 500 Client\User Guides) The Microsoft Backward Compatibility Component install is included in the Sage 500 ERP downloads on the Customer / Partner support Portal. Use the link named Download Sage 500 ERP 2014 Support.
    Extract the download and look there under Support\Microsoft\SQL Server 2008 and 2012 for a folder named Backward Compatibility Components
    Run the appropriate msi install package (x64 for 64bit machines, ia64 for Itanium based machines, regular msi for x86 based machines)
    Once the installation is complete, logout and back into the Sage 500 ERP application and try to reproduce the error.

*Community Hub is the new name for Sage City