by Bret_Halford <bret@[EMAIL PROTECTED]
>
Jul 14, 2008 at 10:07 AM
On Jul 9, 5:32=A0am, "neerajrathi2 via DBMonster.com" <u37674@[EMAIL PROTECTED]
>
wrote:
> Hello,
> We use bcp to populate data in tables. Tables have partition for each
wee=
k.
> Problem is sometime by error we get Future's data. So while bcp throws
er=
ror
> that
> "one or more Rows do not belong to any partitions" and then it aborts
bcp
> command.
> because of none of records in file get loaded.
>
> My question is there any way to stop this so that bcp will ignore that
re=
cord
> but process other records.
> I tired -m option of bcp but got same result.
>
> Thanks in advance.
Have you considered adding a partition for future data so the data has
a place to go?
You could run a job after the bcp to delete that data.
-bret
