Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
SQL-DMO Reference
Methods (SQL-DMO)
E (SQL-DMO Methods)
EnableAgentOffload Method
EnableFullTextCatalogs Method
EnableMergeSubscription Method
EnableTransSubscription Method
EnumAccountInfo Method
EnumAgentErrorRecords Method
EnumAgentParameters Method
EnumAgentProfiles Method
EnumAlerts Method
EnumAllSubscriptions Method
EnumAllSubsetFilters Method
EnumAlternatePublishers Method
EnumAvailableMedia Method
EnumCandidateKeys Method
EnumCollations Method
EnumColumns Method
EnumConflictTables Method
EnumCustomResolvers Method
EnumDatabaseMappings Method
EnumDatabaseRoleMember Method
EnumDataSourceNames Method
EnumDependencies Method
EnumDirectories Method
EnumDistributionAgentSessionDetails Method
EnumDistributionAgentSessionDetails2 Method
EnumDistributionAgentSessions Method
EnumDistributionAgentSessions2 Method
EnumDistributionAgentViews Method
EnumDistributionAgentViews2 Method
EnumErrorLogs Method
EnumFileGroups Method
EnumFiles Method (Database)
EnumFiles Method (FileGroup)
EnumFixedDatabaseRolePermission Method
EnumFullTextLanguages Method
EnumGeneratedSubsetFilters Method
EnumHistory Method
EnumIdentityRangeInfo Method
EnumInitialAccesses Method
EnumJobHistory Method
EnumJobInfo Method
EnumJobNotifications Method
EnumJobs Method
EnumLastStatisticsUpdates Method
EnumLocks Method
EnumLoginMappings Method
EnumLogReaderAgentSessionDetails Method
EnumLogReaderAgentSessionDetails2 Method
EnumLogReaderAgentSessions Method
EnumLogReaderAgentSessions2 Method
EnumLogReaderAgentView Method
EnumLogReaderAgentViews Method
EnumMatchingSPs Method
EnumMergeAgentSessionDetails Method
EnumMergeAgentSessionDetails2 Method
EnumMergeAgentSessions Method
EnumMergeAgentSessions2 Method
EnumMergeAgentViews Method
EnumMergeAgentViews2 Method
EnumMiscellaneousAgentViews Method
EnumNotifications Method
EnumNTDomainGroups Method
EnumNTGroups Method
EnumObjects Method
EnumOutputs Method
EnumParameters Method
EnumProcesses Method
EnumPublicationAccesses Method
EnumPublicationArticles Method
EnumPublicationReferences Method
EnumPublications Method
EnumPublications2 Method
EnumQueueReaderAgentSessionDetails Method
EnumQueueReaderAgentSessions Method
EnumQueueReaderAgentView Method
EnumQueueReaderAgentViews Method
EnumReferencedKeys Method
EnumReferencedTables Method
EnumReferencingKeys Method
EnumReferencingTables Method
EnumServerAttributes Method
EnumServerRoleMember Method
EnumServerRolePermission Method
EnumSnapshotAgentSessionDetails Method
EnumSnapshotAgentSessionDetails2 Method
EnumSnapshotAgentSessions Method
EnumSnapshotAgentSessions2 Method
EnumSnapshotAgentView Method
EnumSnapshotAgentViews Method
EnumStatistics Method
EnumSubscriptions Method
EnumSubscriptionViews Method
EnumSubscriptionViews2 Method
EnumSubSystems Method
EnumTables Method
EnumTargetServers Method
EnumThirdPartyPublications Method
EnumThirdPartyPublications2 Method
EnumThirdPartyVendorNames Method
EnumUsers Method
EnumVersionInfo Method
ExecuteImmediate Method (Database, SQLServer)
ExecuteImmediate Method (LinkedServer, RemoteServer)
ExecuteWithResults Method
ExecuteWithResultsAndMessages Method
ExecuteWithResultsAndMessages2 Method
ExportData Method
Expand Minimize
This topic has not yet been rated - Rate this topic

ExportData Method

SQL Server 2008 R2

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 ExportData method uses the indicated BulkCopy object to copy data from a Microsoft SQL Server database to the data file specified by the BulkCopy object.

Copy 

object
.ExportData(
BulkCopy
)
as Long
object

Expression that evaluates to an object in the Applies To list.

BulkCopy

BulkCopy object that controls data export.

Copy 
HRESULT ExportData(
LPSQLDMOBULKCOPY Bcp,
LPLONG plRowsExported = NULL);

A long integer that indicates the number of rows written to the data file.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.