June 8, 2011 at 3:14 am
Hi all,
I have a serious problem with 1 of my packages, and can't figure out what is causing the problem.
I have a package, with 1 simple data flow task.
The data flow task is very simple:
1. OLE DB Source: load data from a SQL Server table (using the 'Table or View' data access mode)
2. Derived Column: add a simple column to the records, always with default value 'N'
3. OLE DB Destination: insert the records into a SQL Server table, with following settings:
- Data access mode = 'Table or view - fast load'
- Table Lock is checked (other checkboxes are unchecked)
- Rows per batch: 10000
- Maximum insert commit size: 10000
Now, what is happening: in my source table (step 1), I have 11.515.557 records.
When the package is finished, it inserted only 11.515.373 records, so there are 184 records which haven't been inserted.
I can't figure out why it doesn't insert all the records, so any help or suggestions are welcome!
We are using a SQL Server 2008 R2 environment.
Thanx!
June 8, 2011 at 3:44 am
First update: I've tested the same package on my local machine, and there all records were correctly inserted.
Can it be something with the server which is running the package?
It is a Windows 2008 Enterprise Server...
June 8, 2011 at 5:52 am
Never mind, my SSIS was referencing the wrong table, and my query to check was referencing the table it should be loading.
So in fact, there never was a problem, it was just my mistake...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply