SSIS Scheduled Job

SSIS and Import/Export
1

I have experience with simple SSIS packages. I have installed them on scheduled jobs a couple of times and I don't remember clearly the process. It was fairly simple. I will research/google this topic but while doing so, are there any additional tips that I should keep in mind when I set this up, such as window credentials?

I don't remember one of the challenges that we had in the past but we had to do something when we were implementing on the server.

2

You can use sql agent job to schedule SSIS package.

1 Like
3

Thanks Ahmeds

Is that the normal and recommended approach? I think that is what we used.

Are there other methods to schedule an SSIS package beside SQL Agent Job and Task Scheduler?

Thanks

4

Well anything that can run an executable on a schedule can do it, but I'd definitely go with a SQL Agent Job if I were you. It has a specific task type for SSIS packages with UI for configuring things (it's not the nicest UI in the world, but marginally better than the cryptic dtsexec command line settings)

1 Like
5

Thanks for the confirmation Andy.