Hi

I have a code like
********************************
Dim loColumn As DTS.Colum
loColumn = loTransformation.SourceColumns.New("Col001",14

loColumn.Name = "Col001
loColumn.Ordinal =
loColumn.Flags = 3
loColumn.Size = 25
loColumn.DataType = 12
loColumn.Precision =
loColumn.NumericScale =
loColumn.Nullable = Tru
*********************************

What should I specify in DataType Property for Varchar, numeric, boolean and double datatypes of SQLServer 2000 as I have different columns with diff. datatypes

any help is greatly appreciated...

Thanks
SV

In message <50E69743-560F-44F4-82CD-7FCB8AFC74A7 (AT) microsoft (DOT) com>, SVP
<anonymous (AT) discussions (DOT) microsoft.com> writes
If you check out Books Online, or here online
(http://msdn.microsoft.com/library/de.../en-us/dtsprog
/dtsppropde_00dv.asp) it tells you what the reference is for these
values.

Here is the ADO reference mentioned, focus on those with DBTYPE_* in the
description as this is alternative reference above.

http://msdn.microsoft.com/library/de...en-us/ado270/h
tm/mdcstdatatypeenum.asp

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

The links work, just make sure you are using the whole link as most
newsreaders will break the link across lines and any embedded link
rendering will not account for this.


In message <648EFCE3-15DD-416D-9217-2597297B0194 (AT) microsoft (DOT) com>, SVP
<anonymous (AT) discussions (DOT) microsoft.com> writes
If you check out Books Online, or here online
(http://msdn.microsoft.com/library/de...brary/en-us/dt
sprog
/dtsppropde_00dv.asp) it tells you what the reference is for these
values.

Here is the ADO reference mentioned, focus on those with DBTYPE_*
in the
description as this is alternative reference above.

http://msdn.microsoft.com/library/de...rary/en-us/ado
270/h
tm/mdcstdatatypeenum.asp

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server
professionals
http://www.sqlpass.org



--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org