July 21, 2020 at 4:11 pm
Has anyone created an SSIS package which grabs data from one or more files stored on Box.com?
I would be interested in hearing how you got on. Did you get the Box API working from a script task? Any issues adding DLLs to the GAC?
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.
July 21, 2020 at 4:26 pm
One solution (not mine) was using the Box API:
https://community.box.com/t5/Platform-and-Development-Forum/Using-the-box-api-in-SSIS/td-p/68823
Thank link has the general process as well as some code to help with it.
I personally have not done this as I do not have a need for box integration into SSIS at my workpalce.
July 21, 2020 at 4:46 pm
Brian, that's a very helpful link, thank you!
Interesting technique too ... I never knew that there was any way round using non-native assemblies in SSIS, other than installing them in the GAC.
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply