CODEWITHSUNDEEP
sql-serverpentahobulkinsertbcpsqlbulkcopy
Syafiq Hisham
Syafiq Hisham

Reputation: 11

MSSQL Bulk Loader using pentaho data integration

I am currently using pentaho data integration and i need to use MSSQL Bulk Loader Job entry to insert record from a file that is in my local to the remote server. Seems like it is not working.

I currently get this error:

Cannot bulk load because file "\sharing\datasync\data\orders.csv" could not be open. Operating system error code 5(Access is denied)

Will need an advice on the execution for the flow as i myself am kinda new in using Bulk insert/bcp

Upvotes: 0

Views: 2036

Answers (1)

Vasanth Thanjavur
Vasanth Thanjavur

Reputation: 11

Import and export the data using BULK insert and BULK import to process the data

Example

BULK INSERT AdventureWorks2012.Sales.SalesOrderDetail  
   FROM '\\computer2\salesforce\dailyorders\neworders.txt';  
GO

Refer: https://learn.microsoft.com/en-us/sql/relational-databases/import-export/import-bulk-data-by-using-bulk-insert-or-openrowset-bulk-sql-server?view=sql-server-2017

Upvotes: 1

Related Questions