Forgot to add this for reference earlier: http://msdn.microsoft.com/en-us/library/dd758814%28v=sql.100%29.aspx "Valid Starting Partition Offsets" has some justification for the 1M offset.