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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.