|
Home > Archive > BizTalk Server General > May 2004 > SQL Adapter & Stored Proc Parameter Limitations
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Adapter & Stored Proc Parameter Limitations
|
|
| FunkMaster 2004-05-30, 10:46 am |
| 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 i
nto 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.
| |
| Ziga Jakhel 2004-05-30, 10:46 am |
| 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.
| |
| FunkMaster 2004-05-30, 10:46 am |
| Thanks Sigmund - I will try what you suggested.
|
|
|
|
|