January 22, 2010 at 7:39 am
My package was created in VS2008, Why ? To see if there are any new features that would be beneficial to be included in the package.
But the SQL Server that is used for data connection is SQL 2005 servers.Package executes well with no errors upon execution in VS 2008 but when trying to save package using the 'Save package as' on VS to SQL it gives the following
TITLE: Microsoft Visual Studio
------------------------------
Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.
ADDITIONAL INFORMATION:
Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.
I save it to file system and create a SQL job for execution while defining the location to file system
BUt the job never runs and no errors were found in any logs [SQL ,Windows]
Even when right clicking on the SQL job > Start job.I get the following error
TITLE: Start Jobs - SErver1
Execution of job 'Perf' failed. See the history log for details.
------------------------------
BUTTONS:
OK
------------------------------
Again no errors are found, no sign of job execution in any logs [SQL,Windows]
Logging is enabled on package to write to SQL & Windows log upon task failed / error
Can someone confirm if a package created in VS 2008 cannot/ can be executed as a SQL job on SQL 2005 ?
Thank You
January 23, 2010 at 4:53 am
You are using BIDS 2008 to create SSIS 2008 packages to deploy to a SQL Server 2005 SSIS server and that will not work. The only product in BIDS 2008 that you can configure to deploy to a SQL Server 2005 server is Analysis Services (SSAS).
You will need to get the SQL Server 2005 installation disks and install BIDS 2005 and create your packages from scratch since they can only be upgraded.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
January 25, 2010 at 7:38 am
Yes, I found it out the hard way.Started working on creation of package in VS 2005 instead.Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply