Hi Fernando,

I believe if the csv file is missing the column completely (i.e. it is
not just null), you will need to completely reset your column
mappings. While this is possible at runtime in DTS, I have not done
it for a number of years and don't have the required script at hand.
If I remember correctly, to get this working you need to delete all
existing mappings (loop through the collection) and then remap them.
This causes DTS to re-evaluate the source file and hopefully will map
the columns correctly.

Another (and probably more reliable) method is to insert all the data
from the CSV into a single column in a staging table and to split the
data into the correct columns once you are able to determine the
column structure. There should be numerous examples of how to do this
in DTS - google "DTS ragged-right file".

Good luck!
J

Hi Fernando,

I believe if the csv file is missing the column completely (i.e. it is
not just null), you will need to completely reset your column
mappings. While this is possible at runtime in DTS, I have not done
it for a number of years and don't have the required script at hand.
If I remember correctly, to get this working you need to delete all
existing mappings (loop through the collection) and then remap them.
This causes DTS to re-evaluate the source file and hopefully will map
the columns correctly.

Another (and probably more reliable) method is to insert all the data
from the CSV into a single column in a staging table and to split the
data into the correct columns once you are able to determine the
column structure. There should be numerous examples of how to do this
in DTS - google "DTS ragged-right file".

Good luck!
J

Hi Fernando,

I believe if the csv file is missing the column completely (i.e. it is
not just null), you will need to completely reset your column
mappings. While this is possible at runtime in DTS, I have not done
it for a number of years and don't have the required script at hand.
If I remember correctly, to get this working you need to delete all
existing mappings (loop through the collection) and then remap them.
This causes DTS to re-evaluate the source file and hopefully will map
the columns correctly.

Another (and probably more reliable) method is to insert all the data
from the CSV into a single column in a staging table and to split the
data into the correct columns once you are able to determine the
column structure. There should be numerous examples of how to do this
in DTS - google "DTS ragged-right file".

Good luck!
J

Hi Fernando,

I believe if the csv file is missing the column completely (i.e. it is
not just null), you will need to completely reset your column
mappings. While this is possible at runtime in DTS, I have not done
it for a number of years and don't have the required script at hand.
If I remember correctly, to get this working you need to delete all
existing mappings (loop through the collection) and then remap them.
This causes DTS to re-evaluate the source file and hopefully will map
the columns correctly.

Another (and probably more reliable) method is to insert all the data
from the CSV into a single column in a staging table and to split the
data into the correct columns once you are able to determine the
column structure. There should be numerous examples of how to do this
in DTS - google "DTS ragged-right file".

Good luck!
J

Hi Fernando,

I believe if the csv file is missing the column completely (i.e. it is
not just null), you will need to completely reset your column
mappings. While this is possible at runtime in DTS, I have not done
it for a number of years and don't have the required script at hand.
If I remember correctly, to get this working you need to delete all
existing mappings (loop through the collection) and then remap them.
This causes DTS to re-evaluate the source file and hopefully will map
the columns correctly.

Another (and probably more reliable) method is to insert all the data
from the CSV into a single column in a staging table and to split the
data into the correct columns once you are able to determine the
column structure. There should be numerous examples of how to do this
in DTS - google "DTS ragged-right file".

Good luck!
J