| Author |
SQL adapter schema
|
|
| ramani viswanathan 2005-03-28, 6:12 pm |
| Hi
Is there a way to generate schema from sql adapter using FOR XML AUTO
ELEMENTS. I need the schema with with columns as elements instead of
attributes.
Thanks
Ramani
| |
| Jon Flanders[DevelopMentor] 2005-03-28, 6:12 pm |
| I've done that successfully - but you have to do it using a stored procedure
instead of a sql statement.
--
Jon Flanders [DevelopMentor]
http://staff.develop.com/jfland/
http://www.develop.com/courses/biztalk
"ramani viswanathan" <ramaniviswanathan@discussions.microsoft.com> wrote in
message news:F3D28BB6-F373-46BA-BCBC-7FBAA8274596@microsoft.com...
> Hi
>
> Is there a way to generate schema from sql adapter using FOR XML AUTO
> ELEMENTS. I need the schema with with columns as elements instead of
> attributes.
>
> Thanks
> Ramani
| |
| ramani viswanathan 2005-03-28, 6:12 pm |
| Jon
I tried this approach and the resulting schema shows the sp name as record,
but no column names are shown in the schema. Is there anything I am missing?
Thanks
Ramani
"Jon Flanders[DevelopMentor]" wrote:
> I've done that successfully - but you have to do it using a stored procedure
> instead of a sql statement.
>
> --
> Jon Flanders [DevelopMentor]
> http://staff.develop.com/jfland/
> http://www.develop.com/courses/biztalk
> "ramani viswanathan" <ramaniviswanathan@discussions.microsoft.com> wrote in
> message news:F3D28BB6-F373-46BA-BCBC-7FBAA8274596@microsoft.com...
>
>
>
| |
| Jon Flanders[DevelopMentor] 2005-03-28, 6:12 pm |
| The first time you ran the wizard against the stored procedure did you
specify the XMLData predicate?
--
Jon Flanders [DevelopMentor]
http://staff.develop.com/jfland/
http://www.develop.com/courses/biztalk
"ramani viswanathan" <ramaniviswanathan@discussions.microsoft.com> wrote in
message news:8307F995-861F-4B66-B0AA-A71526AC1DB5@microsoft.com...[vbcol=seagreen]
> Jon
>
> I tried this approach and the resulting schema shows the sp name as
> record,
> but no column names are shown in the schema. Is there anything I am
> missing?
>
> Thanks
> Ramani
>
> "Jon Flanders[DevelopMentor]" wrote:
>
| |
| ramani viswanathan 2005-03-28, 6:12 pm |
| Now I specified the XMLData predicate and it generated the schema with the
column names. Couple of things about this schema:-
1. the column names are created with type record with simplecontent.
2. these columns are created under response node of the schema.
Can I use the above schema as destination to be mapped via mapper? since the
columns are created under response node, where will SQL server return the
success status, once the record is inserted in the table?
Thanks
Ramani
"Jon Flanders[DevelopMentor]" wrote:
> The first time you ran the wizard against the stored procedure did you
> specify the XMLData predicate?
>
> --
> Jon Flanders [DevelopMentor]
> http://staff.develop.com/jfland/
> http://www.develop.com/courses/biztalk
> "ramani viswanathan" <ramaniviswanathan@discussions.microsoft.com> wrote in
> message news:8307F995-861F-4B66-B0AA-A71526AC1DB5@microsoft.com...
>
>
>
|
|
|
|