April 27, 2011 at 9:53 pm
How to schedule DTS Package in SQL Server 2008.Pls advise
April 28, 2011 at 9:29 am
Put the package execution in a SQL Agent job step. When you create the new step choose 'SQL Server Integration Services Package' as the type.
Greg
April 28, 2011 at 9:36 am
you should have to upgrade DTS packages on SSIS and then check how you can schedule this package on SQL Server 2008 as attachment shown
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 30, 2011 at 4:17 pm
To schedule a DTS Package as a SQL Server Agent Job
1. Select a Job step of type Operating System (cmdExec)
2. Then enter the following command
DTSRun /N"DTS_Pckg_Name" /S<servername> /E -- Windows Authentication
OR
DTSRun /N"DTS_Pckg_Name" /S<ServerName> /U<UserName> /P<Password> --- SQL Authentication
To Decrypt the Name of the Package available in SQL 2000 Agent Job , open a CMD prompt and paste the DTSRun Command from the Job like this
DTSRun /~Z5x9898C2EC98.... /!X /!C and press Enter
Open a Notepad and right click and paste.. You will get the package name which was previously encrypted so that you can use that package name in the DTSRun Command.
3. Schedule and save the Job or Run it.
Thank You,
Best Regards,
SQLBuddy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply