If you are using SQL Server 2000 then you can use XML to pass the data in

Making an assumption that your inbound XML looks like this:

<ids>

     <id>1001</id>

     <id>347</id>

     <id>109</id>

     <id>203</id>

    ...