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?
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.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy