The dtexec command
prompt utility is used to configure and execute SQL Server Integration
Services packages. The dtexec utility provides access to all
the package configuration and execution features, such as connections,
properties, variables, logging, and progress indicators.
Here I am
creating one package and calling that package in command line.
I am creating
a File task package.
Make source
and destination connection.
Build the
package.
Now open the command
prompt.
Come to
package directory.
Navigate the
package existing directory.
Now write the
command to execute the package.
Press enter
A: start time
B: Progress
C: source
(control type)
D: status
E: Package
execution time
F: Package execution
finished time
G: Elapsed
Time (Time taken to complete the package execution)
Now see the
output
Before package
execution
After package execution.
Files are
copied on the destination folder.
Hope this is will
be helpful for you.
No comments:
Post a Comment
If you have any doubt, please let me know.