How to do bulk import Using C#+sql server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

How to do bulk import Using C#+sql server 2005

Author

Topic

imgajin
Starting Member

5 Posts

Posted - 2010-10-24 : 10:46:50

Hi ,
I am using C# + sql server 2005 . data have fixedlegnth .txt file.
table structure

CREATE TABLE [dbo].[TB](
[code] [nvarchar](3) NULL,
[name] [nvarchar](6) NULL,
[ts] [nvarchar](4) NULL,
[city] [nvarchar](6) NULL
) ON [PRIMARY]

sample data like this;
123xxxxxxaaaaxxxxxx

How to bulk inport this data. Please give idea.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-25 : 13:10:39

http://msdn.microsoft.com/en-us/library/ms188365.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources