Use SQL from the Command Line

More often than not an execute SQL task in SSIS will do the trick. If not, then the data flow will accomplish whatever objective is set out. Occasionally those can become cumbersome in a package to accomplish something simple. In those cases using...