How can we help you today? How can we help you today?

Excluding columns using XML file

I'm trying to create an XML file with all the relevant tables included. However, one of the table has an image data type that I need to exclude.

The following snippet is from the XML file I'm using:

<commandline>
<columns>table_name:col1, col2, col3, ...</columns>

The error returned is:
Error: No such column or columns in table '[dbo].[table_name_*]:col1, col2 etc etc

Tables table_name_* should not be included. How do I include only the columns specified in the <columns> field for the table_name table and no other?

Thanks
si_he
0

Comments

2 comments

Sort by
  • si_he
    No problem, sorted it myself.

    Changed this:

    <columns>table_name:col1, col2, col3, ...</columns>

    To this:

    <columns>table_name$:col1, col2, col3, ...</columns>

    Forgot that $ signifies the end in a regular expression.

    Thanks
    si_he
    0
  • Brian Donahue
    Hello,

    Excellent! I need to document this somewhere I think. :-)
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.