Azure SQL Bulk extract-- BCP absolute path
Hi,
I am using a Azure SQL bulk extract snap and it is asking me to mention the BCP absolute path. I am not aware of this. Can anybody pls help me out?
Forum Discussion
@swright Can check in attached pipeline, this is the generic way to do so. For your cases I am not sure about the content type zip is correct or not. If you know the content type correctly, just use in file writer with extension then it should work. soapAPIZIPResponse_Community_2020_11_06.slp (14.1 KB)
Your solution looks good but I’ve been unable to get a readable file using it. I assume that I don’t have the right content type. I’ve tried “zip” and it doesn’t work so something must be wrong. What are good ways to determine what file type I should use?
Thanks!
