I've recently upgraded from SQL 2000 to SQL 2005 and installed the latest service pack for SQL 2005.
The issue I'm having is that I created a simple package to move data from a flat file to a SQL table. I've also imported the package into the File System, and it runs fine. I would like to schedule this package as a job.
I created a new job and added a step (i.e. "Step1"). I clicked the Type dropdown looking for the subsystem "SQL Server Integration Service Package", but it isnt' there.
Can someone point me in the right direction as to where I can enable or install this subsystem? Your help would be greatly appreciated.