Validating Records before imported into Database in SSIS

Asked Apr 17 '18 at 03:05

Active Apr 17 '18 at 03:27

Viewed 26 times

I am using SSIS

I am importing Data from Excel file into SQL Server table.

There are certain records that are in Excel that should not be imported i.e. Sales < 100

How can I add this validation between my Source which is Excel source and my destination which is OLE DB destination. from what I found on google there can be a control between Excel source and my destination which is OLE DB destination that can make the validation and ignore the un-needed records.

edited Apr 17 '18 at 03:27

asked Apr 17 '18 at 03:05

asmgx

7,328
15
82
143

Read into a temp table using `BULK INSERT` and then insert into your actual target table using a where clause. – Tim Biegeleisen Apr 17 '18 at 03:08
This is not my question.. my question is for SSIS not SQL scripting! – asmgx Apr 17 '18 at 03:17
I can't reopen it for some reason, but I have voted to reopen. You should have told us SSIS from the start. – Tim Biegeleisen Apr 17 '18 at 03:23
The question title says SSIS from the beginning ! – asmgx Apr 17 '18 at 03:26
try open it again, you should be able to now – asmgx Apr 17 '18 at 03:41
I already voted, I can't vote again :-( – Tim Biegeleisen Apr 17 '18 at 03:42
you can open it yourself, without voting – asmgx Apr 17 '18 at 03:42
You can add *Conditional Split* transformation after *Source*, and direct rows which satisfy given condition to a specific output. Then direct this output to your destination. – Ferdipux Apr 17 '18 at 06:11
Maybe this is a better duplicate: https://stackoverflow.com/questions/40714258/ssis-filter-out-rows-with-values-starting-in-a-letter – Tab Alleman Apr 17 '18 at 13:43

Validating Records before imported into Database in SSIS

0 Answers0