Stored Procedure With Bulk Insert Not Working

[fperri]

I am using SQL Server 2005 and SQL Server Management Studio Express.

I'm new to stored procedures and I was creating this one to test out the BULK INSERT sql command. When I execute it says "Command(s) Completed Successfully" but when I open the table there are no records in it. The csv file has two rows in it. The first one is the column names and the second one is the only record in the csv file. So I am looking for one record to show up in my table after executing this but none are being inserted, and I get no errors, any ideas?

Here is my Stored Procedure

USE [Website_Administration]
GO
/****** Object:  StoredProcedure [dbo].[ps_Subscription_Import]    Script Date: 01/07/2008 11:55:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER on
GO
-- =============================================
-- Author:        Franccesca Baker
-- Create date:           01/07/2008
-- Description:    Testing Bulk Import
-- =============================================
ALTER PROCEDURE [dbo].[ps_Subscription_Import] 
 
AS
--Build BULK INSERT Statement
DECLARE @SQL varchar(2000)
 
BEGIN
    SET NOCOUNT ON
 
    SET @SQL = 'BULK INSERT Subscription_Requests FROM "D:\DATA\Test\TestingBulkImport.csv" WITH (FIELDTERMINATOR = ",") '
 
END
Exec(@SQL)
GO

[iburyak]

Is this D drive on your local machine or a server?
Did you try executing the same command from SQL Query Analyzer?

[fperri]

Is this D drive on your local machine or a server?
Did you try executing the same command from SQL Query Analyzer?

The D drive is on the server, and I am running it from SQL Server management studio express. Yes I tried to run just the SQL command and this is what I get


Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 1, column 16 (PONumber).

(0 row(s) affected)

(0 row(s) affected)


I think its because it can't figure out that the line is ending. Column 16 is the last column.