Running DTS package through Execute SQL / pkg Task
I have a DTS package called PCK_EMPLOYEE.
Could anyone of you tell me is there any way to execute the PCK_EMPLOYEE using the following tasks ?
1. EXECUTE SQL TASK or
2. EXECUTE PACKAGE TASK
Also could you please let me know the syntax of running the package in command prompt and SQL Analyzer ?