August 3, 2015 at 3:20 am
Hi everyone,
I am using ssis 2012 to import data from excel 2007 in to sql server using oledb destination and for transformation using Data conversion as some dates in excel are incorrect....I expect that after I run pkg Correct date data should be loaded in sql table nad incorrect one in file destination....but my incorrect data is not getting loaded in text file but
and all the data is loaded in sql table...
I have used DT_DBDate as datatype in ssis pkg.....
This is working fine when I use Flat File destination....
what is wrong???anybody??/
August 3, 2015 at 3:24 am
Hi
Can you post a screenshot of your ssis data flow please ?
Did you configured well the redirection of rows for failure ?
Mohamed
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:
August 3, 2015 at 3:32 am
sej2008 (8/3/2015)
Hi everyone,I am using ssis 2012 to import data from excel 2007 in to sql server using oledb destination and for transformation using Data conversion as some dates in excel are incorrect....I expect that after I run pkg Correct date data should be loaded in sql table nad incorrect one in file destination....but my incorrect data is not getting loaded in text file but
and all the data is loaded in sql table...
I have used DT_DBDate as datatype in ssis pkg.....
This is working fine when I use Flat File destination....
what is wrong???anybody??/
Try to put yourself in the position of someone reading this for the first time.
Now, can you imagine how difficult it would be to suggest anything useful without seeing some examples of the actual data which is involved?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 7, 2015 at 1:37 am
Resending my query of what flow i have used to transfer erroneous data from excel source to flat file using data conversion transformation.
please go through and let me know...thanks in advance
Excel2007 as data source
data is:namesbirthdate
Rohan09/08/15
Rakesh02/07/15
Reeta33/02/2015
Heena29/33/2015
Tanvi10/10/15
mapped it correctly
used data conversion:
names as [DT_WSTR]
Birthdate as [DT_DATE}
Configure error output error redirect row for both columns
and then mapped it witn two flat file destination
one for correct result output.txt and another for error erroroutput.txt using red precedence constraint
where I get automatically errorcode and errorcolumn columns added.
Now when Run Package runs successfuly but no result shown in errorout.txt file.
all the records populated in output.txt file...this works fine as expected when I use flatfile source...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply