Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2000
Microsoft SQL Server 2000
SQL Server 2000 Books Online
Building SQL Server Applications
DTS Programming
DTS Programming Reference
Properties
ActiveXScript Property
AddGlobalVariables Property
AllowIdentityInserts Property
AMSymbol Property
AppendIfFileExists Property
Assignments Property
AutoCommitTransaction Property
BatchCompleteFunctionEntry Property
BatchSize Property
Catalog Property
CCLine Property
CharacterCount Property
CharacterStart Property
CheckConstraints Property
ClassID Property
CloseConnection Property
Codepage Property
ColumnID Property
CommandProperties Property
CommandTimeout Property
CommitSuccess Property
Computer Property
Connected Property
ConnectImmediate Property
ConnectionID Property
ConnectionProperties Property
ConnectionTimeout Property
CopyAllObjects Property
CopyData Property
CopySchema Property
Count Property
CreationDate Property
CreatorComputerName Property
CreatorName Property
CustomTask Property
CustomTaskID Property
DataFile Property
DataFileNonOverwritable Property
DataFileType Property
DataPumpOptions Property
DataSource Property
DataType Property
Day?LongName Property
Day?ShortName Property
DeleteQuery Property
DeleteQueryColumns Property
Description Property
DesignerSettings Property
DestinationColumnDefinitions Property
DestinationColumns Property
DestinationCommandProperties Property
DestinationConnectionID Property
DestinationDatabase Property
DestinationLogin Property
DestinationObjectName Property
DestinationPassword Property
DestinationPropertyID Property
DestinationServer Property
DestinationSQLStatement Property
DestinationTableName Property
DestinationUseTrustedConnection Property
DestSite Property
DestTranslateChar Property
DestUseTransaction Property
DisableStep Property
DropDestinationObjectsFirst Property
DTSMessageLineageID Property
DTSMessagePackageID Property
DTSMessageVersionID Property
EOF Property
ErrorCode Property
ErrorDescription Property
ErrorHelpContext Property
ErrorHelpFile Property
ErrorIfFileExists Property
ErrorIfFileNotFound Property
ErrorIfReceiveMessageTimeout Property
ErrorSource Property
ExceptionFileColumnDelimiter Property
ExceptionFileName Property
ExceptionFileOptions Property
ExceptionFileRowDelimiter Property
ExceptionFileTextQualifier Property
ExecuteInMainThread Property
ExecutionDate Property
ExecutionResult Property
ExecutionStatus Property
ExecutionTime Property
ExplicitGlobalVariables Property
FailOnError Property
FailPackageOnError Property
FailPackageOnLogFailure Property
FailPackageOnTimeout Property
FastLoadOptions Property
FetchBufferSize Property
FieldTerminator Property
FileAttachments Property
FileColumnName Property
FileName Property
FilePath Property
FinishTime Property
FirstRow Property
Flags Property
ForceBlobsInMemory Property
ForceSourceBlobsBuffered Property
FormatFile Property
FunctionEntry Property
FunctionName Property
Get Property
IconFile Property
IconIndex Property
ID Property
ImplementationFileName Property
ImplementationFileVersionString Property
IncludeDependencies Property
IncludeLogins Property
IncludeUsers Property
InMemoryBlobSize Property
InputFormat Property
InputGlobalVariableNames Property
InsertCommitSize Property
InsertFailureFunctionEntry Property
InsertQuery Property
InsertQueryColumns Property
InsertSuccessFunctionEntry Property
InTransaction Property
InUse Property
IsDefaultValue Property
IsNTService Property
IsOwner Property
IsPackageDSORowset Property
IsVersionEncrypted Property
JITDebug Property
JoinTransactionIfPresent Property
KeepIdentity Property
KeepNulls Property
Language Property
LastOwnerTaskName Property
LastRow Property
LineageFullID Property
LineageOptions Property
LineageShortID Property
LogDate Property
LogFileName Property
LogServerFlags Property
LogServerName Property
LogServerPassword Property
LogServerUserName Property
LogToSQLServer Property
LowerCaseString Property
MaxCacheRows Property
MaxConcurrentSteps Property
MaximumErrorCount Property
MaximumErrors Property
MessageDataFile Property
MessageGlobalVariables Property
MessageString Property
MessageText Property
MessageType Property
Month??LongName Property
Month??ShortName Property
Name Property
NestedExecutionLevel Property
NonOverwritable Property
Nullable Property
NumericScale Property
NumRetriesOnSource Property
OEMFile Property
Operator Property
Ordinal Property
OutputAsRecordset Property
OutputFormat Property
OutputGlobalVariableNames Property
Owner Property
PackageCreationDate Property
PackageDataSize Property
PackageID Property
PackageName Property
PackagePassword Property
PackagePriorityClass Property
PackageType Property
Parent Property
ParseName Property
Password Property
PMSymbol Property
PostSourceDataFunctionEntry Property
PrecedenceBasis Property
Precision Property
PreSourceDataFunctionEntry Property
ProcessCommandLine Property
Profile Property
ProgressCount Property
ProgressRowCount Property
PropertyID Property
PropertySet Property
ProviderID Property
PumpCompleteFunctionEntry Property
Query Property
QueuePath Property
ReceiveMessageTimeout Property
ReceiveMessageType Property
RelativePriority Property
RemoveFromQueue Property
RepositoryDatabaseName Property
RepositoryMetadataOptions Property
Reusable Property
RollbackFailure Property
RowsComplete Property
RowsInError Property
RowTerminator Property
SaveDataFileName Property
SaveMailInSentItemsFolder Property
ScriptFileDirectory Property
ScriptLanguage Property
ScriptOption Property
ScriptOptionEx Property
SequenceID Property
ServerName Property
ServerPassword Property
ServerUserName Property
Set Property
ShortYear2000Cutoff Property
Size Property
SortedData Property
SourceColumns Property
SourceCommandProperties Property
SourceConnectionID Property
SourceConstantValue Property
SourceDatabase Property
SourceDataFileFileName Property
SourceEnvironmentVariable Property
SourceFilename Property
SourceGlobalVariable Property
SourceIniFileFileName Property
SourceIniFileKey Property
SourceIniFileSection Property
SourceLocation Property
SourceLogin Property
SourceObjectName Property
SourcePassword Property
SourcePassword (DTSFTPTask) Property
SourceQueryConnectionID Property
SourceQuerySQL Property
SourceServer Property
SourceSite Property
SourceSQLStatement Property
SourceTranslateChar Property
SourceType Property
SourceUsername Property
SourceUseTrustedConnection Property
SQLStatement Property
StartTime Property
StepExecutionID Property
StepExecutionResult Property
StepExecutionStatus Property
StepName Property
StringCompareType Property
StringCompareValue Property
Subject Property
SuccessReturnCode Property
TableLock Property
TaskName Property
TaskType Property
TerminateProcessAfterTimeout Property
Text Property
Timeout Property
ToLine Property
TransactionIsolationLevel Property
TransformationSetOptions Property
TransformFailureFunctionEntry Property
TransformFlags Property
TransformPhases Property
TransformServer Property
TransformServerID Property
TransformServerParameter Property
TransformServerProperties Property
TrimEmbeddedWhiteSpace Property
TrimLeadingWhiteSpace Property
TrimTrailingWhiteSpace Property
Type Property
UDLPath Property
UnicodeFile Property
UpdateQuery Property
UpdateQueryColumns Property
UpperCaseString Property
UseCache Property
UseCollation Property
UseFastLoad Property
UseOLEDBServiceComponents Property
UseRepository Property
UserID Property
UserQuery Property
UserQueryColumns Property
UseTransaction Property
UseTransaction (DTSMQMessage) Property
UseTrustedConnection Property
Value Property
VersionID Property
VersionSaveDate Property
WaitForAcknowledgement Property
WriteCompletionStatusToNTEventLog Property
Expand Minimize
This topic has not yet been rated - Rate this topic

ProviderID Property

SQL Server 2000

The ProviderID property returns the program ID of the OLE DB provider.

Applies To
Connection Object Connection2 Object

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.