SSIS Flat File Connection Issue

  • Hi Guys

    I am having some trouble here. I have a package that should pick up a .csv package daily, however when I check the log from the SQL Job Activity Monitor I get the message:

    The connection manager "IncomingFile" is an incorrect type. The required type is "OLEDB". The type available to the component is "FLATFILE".

    Someone suggested that I should use a ADO.NET destination instead of a OLEDB destination. This solved the exact same issue on the output to a .csv, but the issue remains on the input. The package runs successfully, but doesn't do anything at all.

    Also running this manually from BIDS the package runs without incident and does the import.

    Any assistance in this regards will be greatly appreciated

    Regards

  • Which component did you use in the data flow as a source?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi Koen

    I used a Flat File source component.

    Thank you for your reply

  • coetzeehuman (3/25/2015)


    Hi Koen

    I used a Flat File source component.

    Thank you for your reply

    And I guess you used a flat file connection manager?

    Strange.

    What happens if you rebuild the data flow from scratch? (and redeploy the package to the server)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi Koen

    I found the underlying problem.

    I have a loop checking a remote server, and picking up the files from there, this is where the problem lies. The executing user doesn't have permission on the folder, so when the loop checks there is essentially no file, and it finishes up, but the flat file components sit within the loop, so the "file" it is looking at doesn't fit with the component.

    Thank you for your assistance, and my apologies for the misdirection.

  • coetzeehuman (3/25/2015)


    Hi Koen

    I found the underlying problem.

    I have a loop checking a remote server, and picking up the files from there, this is where the problem lies. The executing user doesn't have permission on the folder, so when the loop checks there is essentially no file, and it finishes up, but the flat file components sit within the loop, so the "file" it is looking at doesn't fit with the component.

    Thank you for your assistance, and my apologies for the misdirection.

    OK, glad you solved the issue and thanks for posting back.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 6 posts - 1 through 5 (of 5 total)

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