var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DTS Scheduling in SQL 2005
I am trying to create scheduled job for DTS. I have created new DTS in SQL 2005 but not able to create job out of it.
I tried creating Credential and then to create proxy with this:
CREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'yourdomain\myWindowAccount', secret = 'WindowLoginPassword'
Sp_add_proxy @proxy_name='MyProxy', @credential_name='MyCredential'
Sp_grant_login_to_proxy @login_name=' devlogin', @proxy_name='MyProxy'
Sp_grant_proxy_to_subsystem @proxy_name='MyProxy', @subsystem_name='SSIS'
but could not get the job to schedule it. when i try to search for the DTS package(TestRev) it could not find it:
Is there a way that i can just call TSQL statement to run that dam DTS because it is too confusing to create job for DTS.
No, you didn't. DTS is not supported in 2005. Please clarify, and maybe we can answer you question.
Originally Posted by patdev
I mean to SSIS packages and would like to schedule it to run in job,
OK, the job scheduler is a bit confusing, but it is going to be around for a while so you might as well bite the bullet and jump in.
And scheduling a package is not very difficult.
In the job scheduler, name your package and then set the type to "SQL Server Integration Services Package".
Set the package source in the General tab at the bottom of the window. (Not the General tab on the left of the window. I agreed it was a bit confusing...)
i tried that and it says that the specified package could not be loaded from SQL server Database.
I select SQL server and then name of server and then name but not able to locate it.
Where did you save your package? If you saved it to a file, you will need to point to the file name.
I just started playing with SSBIDS
What a gdman pig