Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something new.
Today I discovered that in order to use the “Import / Export Wizard” we don’t even have to open management studio.
Just type “dtswizard” into the run box or at the command prompt – regardless of if it is a Powershell prompt or a DOS prompt (its in the Path!)
Pretty cool – although obviously you’ll have to populate the entire wizard yourself.
Well, that’s all from me folks.
Have a great day.