I believe that SQL Server 2000 has a limitation of 1,024 stored procedure pa
rameters. If I have an XML document that contains over 1,024 data elements b
eing picking up in a file receive folder and read into Biztalk and I want to
 map and insert that data i
nto an databse via a stored procedure using the SQL Adapter, how can I get a
round the 1,024 parameter limit? Does anyone have any suggestion on how this
 could be done?

Thanks for your reply.

[ Post a follow-up to this message ]

You could process the XML document via OPENXML. You can pass the doc as a
text parameter.

Hope this helps.

Regards,

Sigmund


"FunkMaster" <anonymous@discussions.microsoft.com> wrote in message
news:51013D9C-C798-4352-B8A6-4F28905C7BC0@microsoft.com...
> I believe that SQL Server 2000 has a limitation of 1,024 stored procedure
parameters. If I have an XML document that contains over 1,024 data elements
being picking up in a file receive folder and read into Biztalk and I want
to map and insert that data into an databse via a stored procedure using the
SQL Adapter, how can I get around the 1,024 parameter limit? Does anyone
have any suggestion on how this could be done?
>
> Thanks for your reply.

[ Post a follow-up to this message ]

Thanks Sigmund - I will try what you suggested.

[ Post a follow-up to this message ]