search

aminosoftware / lysine

documentation and releases for the Lysine data conversion tool by aminoSoftware
0 stars 0 forks source link

while using Lysine 1.3.0.4300, i am not able to see Available External Column in Advance Editor #48

Open abhikadamRP opened 2 years ago

abhikadamRP commented 2 years ago

AminoIssue

I have created the connection manager with EBCDIC file. also mentioned all the column with specified width. When i have attached the connection manager to Amino File Source in advance editor, i am not able to see the AVAILABLE EXTERNAL COLUMNS. It are blank. Can any one please help me on the issue.

benharrell commented 2 years ago

Hi, the external columns are not populated in Lysine. They should be an optional part of SSIS, do you have a need for them?

abhikadamRP commented 2 years ago

Actualy after mapping the source to OLEDB destination. i am getting below error.

[SSIS.Pipeline] Error: Cannot find the connection manager with ID "{4A43099A-9F32-42A4-9636-40FF5FACF84F}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "EBCDIC File Source.Connections[EBCDIC Connection]" in the connection manager collection of "EBCDIC File Source". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.

So after diging into it i found that the EBCDIC CONNECTION MANAGER columns are not been displaying in EBCDIC file source AVAILABLE EXTERNAL COLUMN. So i thought it may be compulsury.

Can you please help me with above.

paltman commented 2 years ago

We have narrowed this down to an installation issue and are currently trying to determine root cause.

abhikadamRP commented 2 years ago

Ohh, Ok. So after fixing the installation issue, will be able to resolve the above error. ?