exporting data to a flat file

  • Good Morning,

        I"m trying to export data to a flat file using the export/import wizard. I want to copy one table to a .txt file. Whenever I try to do it I get the error below. Does anyone know what this means? Any help you can provide would be greatly appreciated. This is an urgent task.

    Below is the error:

    Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Destination - tar_approval_user_config_txt" (55).

    (SQL Server Import and Export Wizard)

  • Hi

     

    This sounds like a known problem with the original release of SQL 2005, see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1.

     

    You may need to install SP1 or SP2 to fix this.  Also make sure that you have installed SSIS onto your PC.

     

    Regards

  • why not just use bcp.exe?

    ---------------------------------------
    elsasoft.org

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply