Unanswered: DTS Packages and Image/Binary/Blob data
I am trying to build a DTS pacakage that will create the database structure our application uses for our clients. The biggest problem I am having is when it comes to the reports, which we've stored as Image data in the database. During run time we get chunks to get the report out of the database. Has anyone tried and been successfull as using a DTS package to load binary/image data into a SQL table? My preference would be to use a global variable in the package to hold the location where the files are stored, and have them pulled in to their respective tables & fields when the package runs.
Any one have any ideas?
I've tried several resources, with no luck.