December 05, 2011

SSMS 2008 and SQL Server Agent Job on a 2005 Instance

A few days ago I got an error that is was driving me crazy. Currently one of my clients is using sql server 2005 and while all the development was done using MS visual studio ( for integration services) to create the package,
the sql server agent job was done using SSMS 2008 instead of SSMS 2005, the job is create with not issues or problems until you try to run the job; the job will fail. Why? Well when creating sql server agent jobs using SSMS 2008 the provider field in the connection string is provider = xx10. it needs to be change to Provider 1.After changing the provider field everything works just fine....way to to MS.

No comments:

Post a Comment

Contact Form

Name

Email *

Message *