none
Not finding Flat File Connection Manager.

    Dotaz

  • I have created a SSIS package the copies records from a SQL Server table to an Oracle table.

    I first copy the SQL Server table records to a temp table.  Then I copy the temp table records to the Oracle table.  I check for errors and dump them to a Flat File destination.  I renamed the Flat File Connection Manager to the name of the file.

    This was working fine until someone changed the permissions on the location of the flat file.

    So I corrected the problem of the permissions but now I get this error:

    Error 5 Error loading ScrapERP1V1 (1).dtsx: The connection "Flat File Connection Manager" is not found. This error is thrown by Connections collection when the specific connection element is not found.  XXXXXXXXXXXXXXXXXX (default location of flat file, not the location found in the Package Configuration) 1 1

    When I edit the flat file connection manager I do not get any errors.

    Any ideas what might be causing this error or where to look?

    thanks, fred


    Fred Schmid

    čtvrtek 12. července 2018 13:16

Všechny reakce

  • are you passing a static connectionstring (filepath) or is it sent from a variable or using an expression for the connection?

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    čtvrtek 12. července 2018 13:41
  • I am using a static connectionstring.

    Fred Schmid

    čtvrtek 12. července 2018 14:07
  • Error 5

    Hello Fred,

    system error 5 = Access denied, it still a permission issue


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    čtvrtek 12. července 2018 14:46
  • Where do I check for this permission issue?  I am running this now in BIDS and I have local admin rights to the location(i.e. full permission).

    TITLE: Package Validation Error
    ------------------------------
    Package Validation Error
    ------------------------------
    ADDITIONAL INFORMATION:
    Error at MHS_Scrap_ERP1: The connection "Flat File Connection Manager" is not found. This error is thrown by Connections collection when the specific connection element is not found.
     (Microsoft.DataTransformationServices.VsIntegration)
    ------------------------------
    BUTTONS:
    OK
    ------------------------------

    I tried changing the ConnectionString to an expression but get the same error.  The value produce by the expression I can use in File Explorer to access the flat file.


    Fred Schmid

    čtvrtek 12. července 2018 15:11
  • Hi MES_Analyst,

    Click the Connection Manager and relocate the file, remapping the columns.

    Or re-create a new Connection Manager.

    Check what happens.

    Regards,

    Pirlo Zhang 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    pondělí 16. července 2018 9:34
    Moderátor
  • I am using a static connectionstring.

    Fred Schmid

    looks like flat file connection is corrupted then

    Can you try adding a new flat file connectionstring pointing to your file and set mappings?

    Then try running the package


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    pondělí 16. července 2018 10:58