Click here to Skip to main content
15,886,362 members
Search within:


How to nest bulk insert procedure within a stored proc?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
ASP.NET
SQL
server
How to nest bulk insert procedure within a stored proc??
Posted
Add a Solution
Comments
nilesh sawardekar 17-Jul-14 2:59am    
bulk insert from specific file format?
Anup Shetty 17-Jul-14 7:36am    
Create PROCEDURE [dbo].[sp_BulkInsert]

@pathName varchar(250)
AS
BEGIN
BULK INSERT dbo.PID
FROM '@pathname'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
CODEPAGE = 'RAW'
)

END

Error:@pathname doesnt exist even though i hv set the path

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Service broker Activation Procedure with BULK INSERT?
Please help I am trying to catch exceptions in a store proc and roll back
stored procedure for inserting xmldata to sqlserver
executing a stored proc.
Executed Nested Stored Procedure
Stored Procedure Nested If else
Executing a Stored Procedure within a stored Procedure
Nested while loop in stored procedures
Use Bulk Insert in SQL for decimal values
Oridinary insert and bulk insert together

Advertise
Privacy
Cookies
Terms of Use
Last Updated 17 Jul 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web02 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900