September 15, 2018 at 1:35 am
Hi friends,
I need to create a SSIS package in which I am reading a flat file (provided monthly with many defined columns) and writing the data to a already defined SQL Server table (with lot of data already in SQL table). In the SQL table design view, I have datatypes including float ,datetime , bigint, varchar (which are already defined and CANNOT be changed)
I need to prevent the insert of any data rows from flat file that already exist in the SQL Server table. How can I achieve this ?
I tried to achieve this using lookup transformation but in Edit mappings I get an error while creating relationships "Cannot map the lookup column because the column is set to a floating point data type" . I am able to create the relationships for all other data types but then there are some data rows in source file which differ from data in sql table in floating point values only and the expectation is that these rows will be inserted.
Is there any other simple way to achieve this ?
Thanks.
September 15, 2018 at 7:29 am
How do you tell if the row already exists? Is there an ID you can use? Otherwise, are you saying that every value had to match? If the latter, you would likely be better loading to a staging table and handling the insert into the productions table using T-SQL.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply