Monday, March 19, 2012

how to create a script to execute a package?

hello,

I am loading data from one DB to another. I wish to load them every day at night. I know to do that, I must write a script. But how to do it? I don't know. Could someone help me?

thanks in advance

Let se I got it right.

If you have a package or set of packages; you can use SQL Server agent to create a Job that rons on a scheduled basis. Why would you need an script?

|||

The easiest way to create a script is to use DTEXECUI.EXE to build the necessary command-line parameters for DTEXEC.EXE. You can then copy this into a batch file and schedule it using whatever tool you want.

With this said, Rafael is right - using SQL Server Agent is probably the simplest way to execute your packages on a schedule.

No comments:

Post a Comment