Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
COURSE of the MONTH
14 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Import csv file, trouble with the file name when given as parameter.
Posted on 2015-02-02
Hello,
I have this Stored Procedure:
Above doesn't work, I get this error:
Msg 4860, Level 16, State 1, Procedure spImport852Daily, Line 10
Cannot bulk load. The file "' + @fName + '" does not exist.
If I replace the @fName with a path to the file (c:\import.csv) then it works perfectly.
What am I doing wrong?
tnx
~j
I have this Stored Procedure:
USE [MyDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spImport852Daily]
@fName nvarchar(100)
AS
BEGIN
SET NOCOUNT ON;
BULK INSERT dbo.tbl852Daily
FROM ''' + @fName + '''
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
END
GO
Above doesn't work, I get this error:
Msg 4860, Level 16, State 1, Procedure spImport852Daily, Line 10
Cannot bulk load. The file "' + @fName + '" does not exist.
If I replace the @fName with a path to the file (c:\import.csv) then it works perfectly.
What am I doing wrong?
tnx
~j
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Since the filename is a parameter, you would have to use dynamic SQL to execute this.
A quick and dirty way would be something like this:
A quick and dirty way would be something like this:
ALTER PROCEDURE [dbo].[spImport852Daily]
@fName nvarchar(100)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @sql VARCHAR(4000)
SET @sql = 'BULK INSERT dbo.tbl852Daily FROM ''' + @fName + ''' WITH ( FIELDTERMINATOR = '','', ROWTERMINATOR = ''\n'' )'
EXEC(@sql)
END
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses
Course of the Month14 days, 14 hours left to enroll
771 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.