I previously wrote article SQL SERVER – Import CSV File into Database Table Using SSIS. I was asked following question by reader that how to run the same SSIS package from command prompt.
This is really interesting question and very easy one as well. You can execute SSIS Package using command line utility.
C:\>dtexec.exe /F "C:\ImportCSV\Package.dtsx"
When you run above command it will give you start time, end time and total progress of the package as well.
There are various options of the DTEXEC available you can see that using dtexec.exe /?
In future we will see how the SSIS task can be configured in scheduled task.
Reference : Pinal Dave (http://blog.SQLAuthority.com)