i created ssis package takes in csv file , imports table called "opex_spend" when run query queries multiple iterations of table. table should show 336 rows instead there 1002. ideas why it's doing that? here how set up:
data flow:
flat file source
lookup transformation
ole db destination
here how tables set up:
create table opex_accounts ( account_id int identity (1,1) primary key, opex_name varchar(50), gl_account varchar(50) ) create table opex_spend ( actuals_id int identity (1,1) primary key, account_id int not null, constraint fk_opexid foreign key (account_id) references opex_accounts (account_id), actuals_date varchar(50), transaction_text varchar (50), actuals_amount numeric )
Comments
Post a Comment