Hi all;
I am still new to SSIS. I have an SSIS service that does an ETL process for me utilizing a flat file (csv). In sql server I created a table with the following columns below
my csv file only contains columns desc_info and desc_type. My question though is, how do populate the date_load and source_info column in the SSIS package. Is there a way to add addition columns and map it. Thanks in advance.
I am still new to SSIS. I have an SSIS service that does an ETL process for me utilizing a flat file (csv). In sql server I created a table with the following columns below
SQL:
create table testme
(
id int identity (1, 1)
,date_load datetime
,source_info varchar(10)
,desc_info varchar(20)
,desc_type varchar(20)
)
my csv file only contains columns desc_info and desc_type. My question though is, how do populate the date_load and source_info column in the SSIS package. Is there a way to add addition columns and map it. Thanks in advance.
Last edited by a moderator: