Is there a way to change fixed width Flat file connection manager to delimited without losing all the column names ?
Is there a way to change fixed width Flat file connection manager to delimited without losing all the column names ?
March 25th, 2015 2:35pm

Unfortunately not as it is a quite dramatic change causing the metadata being refreshed. I would try to open though the package file in a text editor and find them before doing the change, then after you made the change to the FF connector try to reconstitute / replace the autimatically generated columns with the old names.
Free Windows Admin Tool Kit Click here and download it now
March 25th, 2015 3:10pm

I don't think so. Flat file conn manager will refresh the metadata. and would accept the  source colummns remapping. Unfortunately, SSIS is static metadata tool
March 25th, 2015 4:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics