-1
I have the following situation: I make a Flat File (Simple File) import from a *.CSV file to a table in the database. Using SSIS in Visual Studio. However, each day the file I receive has the order of the columns changed. Thus, the "email" field, for example, may end up receiving information from the "phone". How do I make sure that regardless of the order that comes, the import identifies the correct columns?
Exemplo:
Ordem das colunas no Dia 01: Email, Nome, Telefone
Ordem das colunas no Dia 02: Telefone, Email, Nome
The text file (CSV format) has initial line with the headers that identify the contents of each column?
– José Diz
Yes. The first line is the header.
– catholiveira