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)
Hi Pinal! How are you! Long time no see! Hope everything is fine.
I’m writing to you ’cause I noticed you mentioned DTExec. I’ve wrote an alternative version called DTLoggedExec that has some additional features that the original one and make life simpler to BI Developers.
It’s available on CodePlex, along with the source code, here:
http://dtloggedexec.codeplex.com/
Enjoy!
[...] to run the same SSIS package from command prompt. In response to the same I have written article SQL SERVER – Running SSIS Package From Command Line. Within few minutes of the blog post, I received email from another blog reader asking if this can [...]
Thanks pinal & Thank you Davide Mauri for shring the info.
How do I execute an SSIS package from SSMS client?.