Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-18 : 21:35:16
|
JohnR writes "
I want to append my own value when reading in a dts file then add it to all rows as it's imported to the table.
I created a DTS VB File from SQL2k and built a framework around it to import all the files, but I need to indentify the source with this ID.
So i need something like the following, but this doesn't work, [Static_ID] always ends up null.
Set oColumn = oTransformation.SourceColumns.New("Static_ID", 1)
oColumn.Name = "Static_ID"
oColumn.Ordinal = 1
oColumn.Flags = 32
oColumn.Size = 10
oColumn.DataType = 129
oColumn.Precision = 0
oColumn.NumericScale = 0
oColumn.Nullable = False
oColumn.Properties.Item(1).Value = "01234567890"
oTransformation.SourceColumns.Add oColumn" |
|
|
|
|
|
DTS