
	Home > Microsoft .Net Development Tips > Microsoft SQL Server > A stored procedure to export/import data using BCP

Win Development Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

MICROSOFT SQL SERVER

A stored procedure to export/import data using BCP

Eli Leiba
02.26.2002
Rating: -4.50- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

This is a stored procedure that can be run from a master database to export or import a table to/from a given file path+name from/to a given database.

Reader Feedback

Kumar S. writes: This is really a good stuff and came at the right time -- I was loo

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Microsoft SQL Server
	Using the Visual Studio 2005 DataSet Designer to build a data access layer
	The CTE, the hierarchical query and SQL Server 2005
	SQL Server 2005 recursive functions and the CTE
	Choose the right .NET data provider, optimize application performance
	The fallacy of the data layer -- or, a new architectural model for software designs
	Book excerpt: ADO.NET and SQL Server 2005
	Addressing common SQL Server questions
	Book Excerpt: The .NET Framework and SQL Server 2005
	WinForms development using SQL Server 2005 and Visual Basic 2005
	Configuring ASP.NET 2.0 apps to SQL Server 2005 databases

SQL Server and .NET development

Microsoft releases new CTP of Oslo SDK

Perpetuum unveils database synchronizer for .NET 2.0

The CTE, the hierarchical query and SQL Server 2005

SQL Server 2005 recursive functions and the CTE

SQL Examiner Suite synchronizes data schema, sets

Book excerpt: ADO.NET and SQL Server 2005

DataDirect database drivers now support MySQL

Top .NET tips of 2007 (so far)

Addressing common SQL Server questions

Book Excerpt: The .NET Framework and SQL Server 2005

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

king for a similar job in my project. But do you have any idea how to handle errors in case of bcp failures or errors in bcp?

Rajasekhar S. writes: Could you please tell me whether this utility works with image and text data types?

For More Information

Rate this Tip
To rate tips, you must be a member of SearchWinDevelopment.com. Register now to start rating these tips. Log in if you are already a member.

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Database Programming Solutions - .NET XML, Visual Studio LINQ, ORM .NET

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2000 - 2009, TechTarget \| Read our Privacy Policy