edit: added some more info
I am trying to set up a job to run a SSIS package in SQL 2005, the SQL 2005 is installed on a Windows server 2003 machine.
start Edit
I have the Management studio (I am working from) installed on windows XP (fully up today with the SPs). I have the installed on this machine the integrated Services, I do not know if they have been installed on the Windows 2003 machine that has the DB.
end Edit
The job is failing with the following error message:
Expand|Select|Wrap|Line Numbers
- Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Data Conversion 1" (117). ... The package execution fa... The step failed.
Some background:
The Package
The Package it's self has the job to Pull all the data from a table between specified dates, in this case, last weeks data. it then exports the results to an Access Database.
when I create the package, if I do the "run it now" option it works, it runs with out error and successfully exports the data.
I then created the same package with all the same options except this time I saved it to the file system.
The Job
My next step is to set up the job, I set this up to pick the package and run it, once a week at a specified time.
I save the new job and then manual ask it to run(for a test)
when the job runs it errors with the above mentioned error message.
for all of this I am using the System Admin user to create and deploy this job/package.
any suggestions would be greatly appreciated as remote desktoping to work on the weekends to manually create and run the package is not how I want to spend my weekends.
Thanks