sql - Query Showing Multiple Iterations of Table -


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:

  1. flat file source

  2. lookup transformation

  3. 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