Can not open the file

  • Hi I have an issue .File is not loading from the source .Flat file source is the source

    [Flat File Source [656]] Error: Cannot open the datafile "G:\er\inbound\upsirpt\soup\extracted\delimited\*test1.*.dat".

  • I do not think that the wildcard character * is valid in file names - assuming that that is your question?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Yes. how to process this file

  • Smash125 (4/29/2013)


    Yes. how to process this file

    That file does not exist. Remove the wildcard characters and use the real file name.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Use expression to build the complete file name, if you want to make it more dynamic

    [font="Calibri"]Raj[/font]

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

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