November 1, 2018 at 9:44 pm
Hi Guys,
I am new to the SSIS world and creating a simple package to load data from Flat File OLE DB connection to OLEDB SQL Server Destination. I am running into a weird issue that my Data Flow Task successfully finishes processing all 14 Mil records but when I run the count query on the table , it shows only 12 Mil records. The package execution does not show any errors. I am ignoring all errors during this process. I have not run the package 4 times with now success. It is loading the same number of records all the time, I even delted and recreate the connections with no success. Help please!!!
Thanks
November 2, 2018 at 10:14 am
Regarding "I am ignoring all errors during this process"
May an error cropped up and a full batchsize was not imported? (bulk vs individual loads)
November 5, 2018 at 1:25 pm
Once upon a time, I had a similar issue. My solution was to transform several field formats because SSIS seems to have some kind of 255 character limit similar to Excel for text values.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply