SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Database Engine Administration Programming
SQL-DMO
SQL-DMO Reference
Properties (SQL-DMO)
D (SQL-DMO Properties)
Database Property
DatabaseFileGroups Property
DatabaseFiles Property
DatabaseName Property
DatabaseUserName Property
DataFile Property
DataFilePath Property
DataFileSize Property
DataFileType Property
DataFolder Property
DataSource Property
DataSpaceUsage Property
DataSpaceUsed Property
Datatype Property
DateCreated Property
DateFindOperand Property
DateJobCreated Property
DateJobLastModified Property
DateLastModified Property
Day Property
Days Property
DboLogin Property
DBOUseOnly Property
DBOwner Property
DBReadOnly Property
Default Property (Column, UserDefinedDatatype)
Default Property (FileGroup)
DefaultCursor Property
DefaultDomain Property
DefaultLogin Property
DefaultOwner Property
DefaultPath Property
DelayBetweenResponses Property
DeleteCommand Property
DeleteLevel Property
DenyNTLogin Property
DestDatabase Property
DestinationObjectName Property
DestinationOwnerName Property
DestLogin Property
DestPassword Property
DestServer Property
DestTranslateChar Property
DestUseTrustedConnection Property
DeviceNumber Property
Devices Property
DistributionAgent Property
DistributionCleanupTaskName Property
DistributionDatabase Property
DistributionJobID Property
DistributionServer Property
DistributionWorkingDirectory Property
Distributor Property
DistributorAvailable Property
DistributorInstalled Property
DistributorLocal Property
DropDestObjectsFirst Property
DropLogins Property
DTSPackageLocation Property
DTSPackageName Property
DTSPackagePassword Property
DynamicFilterHostName Property
DynamicFilterLogin Property
DynamicFilters Property
DynamicReconfigure Property
DynamicSnapshotJobId Property
DynamicSnapshotLocation Property
Expand Minimize
This topic has not yet been rated - Rate this topic

DTSPackageName Property

SQL Server 2005

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The DTSPackageName property specifies a Data Transformation Services (DTS) package name to use during a replication operation.

Copy 

object
.DTSPackageName [= value]
object

An expression that evaluates to an object in the Applies To list

value

A string that specifies the name of the DTS package

String

Read/write

Copy 
HRESULT GetDTSPackageName(SQLDMO_LPBSTR pRetVal);
HRESULT SetDTSPackageName(SQLDMO_LPCSTR NewValue);

The DTSPackageName property specifies a DTS package name that Distribution Agent processes before data changes are applied at the Subscriber.

Prior to setting DTSPackageName, set AllowDTS to TRUE when configuring a TransPublication object. Next, set the DTSPackagePassword property (if the package is password protected), and then set the DTSPackageLocation property.

ms133978.note(en-US,SQL.90).gifNote:
If an application calls DTSPackageName on an instance of Microsoft SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.