
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Regarding BULK INSERT to MSSQL DB
We are trying to do BULK Insert into MSSQL DB via talend. As the file is on our disk and not on DB server therefore MSSQL not been able to access the file. Please suggest any way by which we can bulk insert our data via Talend without moving the file to DB server??
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use the bcp utility for that and it will be resolved. You can easily find the sample bcp command over the internet and then use your own configuration. We resolved this issue in same way.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
What's your input source? Can you bulk insert your data into MSSQL DB by using talend bulk component?
Please take a look at this component TalendHelpCenter:tMSSqlOutputBulkExec which allows gains in performance during Insert operations to a Microsoft SQL Server database.
Here is also a related scenario about:TalendHelpCenter: Scenario: Inserting data in bulk in MySQL database.
Best regards
Sabrina

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My database is on Azure and I have the same issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use the bcp utility for that and it will be resolved. You can easily find the sample bcp command over the internet and then use your own configuration. We resolved this issue in same way.
