SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


how to schedule SSIS package


how to schedule SSIS package

Author
Message
Gabit Jan
Gabit Jan
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 35
Hello guys,

I have created a simple SSIS package which gets data from Oracle and saves the output to file.
But I couldn't schedule this SSIS package thru SQL Agent job.

Can you help in how to manage it.

This is what i have done:
Created such user:
USE [msdb]
GO
CREATE USER [DOMAIN\account] FOR LOGIN [DOMAIN\account]
GO
USE [msdb]
GO
EXEC sp_addrolemember N'SQLAgentOperatorRole', N'DOMAIN\account'
GO
USE [msdb]
GO
EXEC sp_addrolemember N'SQLAgentReaderRole', N'DOMAIN\account'
GO
USE [msdb]
GO
EXEC sp_addrolemember N'SQLAgentUserRole', N'DOMAIN\account'
GO
USE [master]
GO
EXEC sp_addsrvrolemember @loginame = N'DOMAIN\account', @rolename = N'sysadmin'
GO



Created credential and proxy:
USE [master]
GO
CREATE CREDENTIAL [account-CREC] WITH IDENTITY = 'DOMAIN\account',
secret = 'WindowLoginPassword'
GO
USE [msdb]
GO
EXEC sp_add_proxy @proxy_name='MyProxy', @credential_name='account-CREC'
GO
EXEC sp_grant_login_to_proxy @login_name='DOMAIN\account', @proxy_name='MyProxy'
GO
EXEC sp_grant_proxy_to_subsystem @proxy_name='MyProxy', @subsystem_name='SSIS'
GO



on server level added to such groups:
Administrators
SQLServer2005DTSUser$SERVERNAME
SQLServer2005MSSQLUser$SERVERNAME$INSTANCE
SQLServer2005SQLAgentUser$SERVERNAME$INSTANCE



at local policy added to:
Adjust memory-quotas for process
Log on as a batch job



while running the job get the follwoing error:
Message
Executed as user: DOMAIN\account. The process could not be created for step 1
of job 0xBA6BB55729F5314F8FADB8ECF7E16D2F
(reason: A required privilege is not held by the client)


Silverfox
Silverfox
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4066 Visits: 1161
Try this link and see if it helps you

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/dc9fa982-bf27-4a68-a86c-12b4d11a598a

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search