1 .Open command prompt
2 .Use dtexec utility
3. C:\ dtexec /f d:\ssis\myPackage.dtsx /de password999
/f = file dir
/de = decrypt password
If you have both 2005 and 2008 , you have to specify which version to be run.
By default is 2005
This is example for using dtexec of 2008 version
Run command prompt and specified Dtexec path like this
"C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /f d:\ssis\myPackage.dtsx /de password999
Ref site . http://msdn.microsoft.com/en-us/library/ms162810.aspx
Ref site . http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/744957ad-038a-46ba-aa70-0adab03a5f4d/
ไม่มีความคิดเห็น:
แสดงความคิดเห็น