I've been struggling to find a solution to this.
I have been provided with a database within a server run by our IT department. I have full write access to that dB but no other rights on the server.
I'd like to use the AdventureWorks dB to learn SSIS, but obviously can't create the database from the .mdf file.
Is there another method I can use to create the relevant table and copy the AW data directly into my existing dB?