Excluding columns using XML file

si_he

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

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

Brian Donahue

Hello,

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