Issue with control files in Infopackage

[former_member565547]

Hello,

I migrated a dataflow from 3.x datasource to 7.x. The infopackage of this datasource is getting the data from a control file. But After migration the data that is extracted by the infopack is completely different. Instead of extracting the csv file contents it is extracting only the control file contents

this is my control file:

for example if the content of my csv file is:

1234567890,10,9999999999,,,15,01/01/2005

1234567891,20,9999999999,,,30,01/01/2005

1234567892,30,9999999999,,,0,01/01/2005

1234567893,10,9999999999,,,5,01/01/2005

The PSA data extracted by the infopack is:

Can you plz tell me where exactly is the problem?

[Former Member]

Hi,

Seems like there is some incorrect setting in the IP.

Check the IP settings for source file path, data seperator and other entries.

Br,

Arpit

[former_member182470]

Hi,

During the migration process, your infopackage settings(All Tabs) would have got changed. Please check the file path and load example data.

Keep the separator as comma

Regards,

Suman

[Former Member]

Hi,

Please let us know from AL11 Infopackage fetching file or from Local work station?

If it is from AL11 to pick the file you may have written some code at Info-package level. If this is your case please check the Code and the path.

Check the file path and check Data-format setting it should be CSV .

Please check this.

[former_member565547]

Hi Aakash,

Its AL11 file and I checked the code written at the IP level and everything looks good.

[former_member565547]

can anyone help me out with this issue?

[RamanKorrapati]

Hi,

About control file am not familiar.

please check info pack options which we provide while load this kind of data. like comma, delemeter options and source file path.

Thanks