Hi:
I have following SQL Server stored procedure that executes a simple Bulk Insert without any problem.
CREATE PROCEDURE PROCTEST AS
BULK INSERT TEST
FROM ‘\server1\public\Purchasing\Uploads\TestFile.csv’
WITH
(
FIRSTROW=2,
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’,
KEEPNULLS
)
*********************************************************<<<
Whenever I run this procedure from Query Analyzer, it runs fine and imports the csv content into the Test table.
I need to run this from a php program… I’m using following code (but IS NOT WORKING):
$sqlRunProc = " EXEC SERVER1.MyDB.dbo.PROCTEST";
$statement = $conn->query($sqlRunProc);
***********************************************************<<<
I will appreciate any advice/suggestions.