Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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??

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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.

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Actually our input is the delimited file on the disk and therefore MSSQL not allowing to access file from the disk and want the file to be on DB server rather than on disk. That's why I just want to know if there is any way possible through Talend that we do BULK load by accessing input file from local disk.


Anonymous
Not applicable
Author

 My database is on Azure and I have the same issue.

Anonymous
Not applicable
Author

You can use the bcp utility for that and it will be resolved.


Anonymous
Not applicable
Author

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.