Thank you all for responding to my question.
File based export (DTS, BCP, or SQL BULK INSERT) works great when the client
and the destination database server are on the same machine. Configuring a
shared drive is not an option for us.
Bob Beauchemin's suggestion of using IRowsetFastLoad looks lik
.NETters,
I need to pump huge number of records into a SQL Server database. The
default SQL Server ADO .NET connector doesn't seem to support any bulk copy
operations. I am wondering if I simply overlooked something or if there is a
newer SQL Server ADO .NET connector that can be downloaded.
I se
verStorageFlags.DTSSQLS
tgFlag_UseTrustedConnection,"","","","JTQ520 IMPORT",ref oj);
pack.Execute();
break;
}
return true;
}
catch (Exception ex)
-
From: Moderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Behalf Of Pradeep Tapadiya
Sent: Thursday, February 26, 2004 1:08 PM
To: [EMAIL PROTECTED]
Subject: [ADVANCED-DOTNET] SQL Server bulk copy operation...
NETters,
I need to pump huge number of records into a SQL Server
[EMAIL PROTECTED]
> Subject: [ADVANCED-DOTNET] SQL Server bulk copy operation...
>
>
> .NETters,
>
> I need to pump huge number of records into a SQL Server database. The
> default SQL Server ADO .NET connector doesn't seem to support
> any bulk copy
> operations. I am
d discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Behalf Of Pradeep
Tapadiya
Sent: Thursday, February 26, 2004 11:08 AM
To: [EMAIL PROTECTED]
Subject: [ADVANCED-DOTNET] SQL Server bulk copy operation...
.NETters,
I need to pump huge number of records into a SQL Server database.
