Where to find list of valid properties which can populate the DTS.Connection-ConnectionProperties collection?
Posted on 2003-11-29
Hello, sorry to bother you with this - and hopefully it is a quick one.
Having trouble trying to track down where Microsoft hides their list of the valid property names which can be set/read for the ConnectionProperties collection of a DTS.Connection object.
I am attempting to setup a VB app which will automatically import a .CSV flat file into a pre-existing SQL2K table. I already have sample code that should get me through, although I am having some trouble with the available properties that can be set on the DTS.Connection object. I would like to access a list of ALL of the possible settings for this object (along with examples, if possible).
Some of the settings I already know are "Row Delimiter", "Column Delimiter", "Data Source" -- although I don't have a clue as to what the possible values are for "File Format", or what "File Type" settings are possible.
As this is urgent (as in I need to complete this project today), I'm assigning this 500 points.
Thanks in advance...