How to schedule a DTSX

Question

How to schedule a DTSX

djciko

SSC Enthusiast

Points: 153
More actions
July 28, 2010 at 6:24 am

#221814

I made a DTSX and i want to schedule it to run every 2 hours during the day.
I am in "NEW JOB STEP" dialog window.
Why i can't see "Sql Server Integration Service Package" from the ComboBox about the TYPE of step ?
Need to install something else ?
Need to do something before ?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

EjSQLme SSCrazy Points: 2172 More actions · Answer 1

SQL Server Integration Services Package is usually the second one from the bottom on the drop down list for Type. If you are not able to see it, then make sure you have an SA access.

djciko SSC Enthusiast Points: 153 More actions · Answer 2

Ok, tomorrow i will check if i had access with an SA account and i will reply.

Thanks.

djciko SSC Enthusiast Points: 153 More actions · Answer 3

It says "non riuscito" - not working the execution of the package.

Do I have to exec it with a particular USER ?

Now is MACHINENAME\SYSTEM

(Yes, i am accessing the DB with an SA account)

EjSQLme SSCrazy Points: 2172 More actions · Answer 4

Log into the server as an Administrator and open the SQL Sever Management Studio using Windows Authentication and see if you still get the same issue.

MostInterestingMan SSCertifiable Points: 6291 More actions · Answer 5

djciko,

Were you about to execute this package? If not, what error message(s) are you still getting?

MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends