I have written some vb based on the code created by SQL Server 2000 which loops via an xml file containing column info and does imports to several different tables in my database. The problem is, I now need to generate the XML file using SQL
I have worked out what most of the information DTS needs to do the import but I don't know what the Flags property of a column is for
Eg oColumn.Flags = 3

Can someone please explain this to me

Also, the integer values of the datatype don't match up with the values used in syscolumns. Does anyone have a list of these and how they map to the SQL datatypes

Thanks a lot...

You can find information about the Flags property of the column object by
looking at BOL

Columns Objects | Column Object (DTS Programming) | Properties

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Gary Ewen" <anonymous (AT) discussions (DOT) microsoft.com> wrote

different tables in my database. The problem is, I now need to generate the
XML file using SQL.
SQL datatypes?