I have connected to a MySQL database using the ODBC connector and the Connect package activity and am able to use the Execute Non Query activity to insert regular data types like text/string and integer, but I cannot figure out how to insert a pdf or word document as a BLOB data type into the database.
I would also like to be able to extract the BLOB data type back into the form it was originally in (pdf/word doc) eventually as well.
Any help would be greatly appreciated!