November 26, 2013 at 8:26 am
Much simpler fix for me.
Modify plan, edit backup task, don't change anything but select the OK button, save plan.
December 6, 2013 at 2:36 pm
inevercheckthis2002 (11/26/2013)Much simpler fix for me.Modify plan, edit backup task, don't change anything but select the OK button, save plan.http://www.sqldbadiaries.com/2010/09/19/backup-job-failes-with-error-the-package-execution-returned-dtser_failure-1/
exactly in my case, though I run the sp_configure 'Allow Updates', 0
June 29, 2015 at 12:03 pm
Thanks a ton! your solution fixed my problem with DBCC job that was failing for a while now.
July 29, 2022 at 11:50 am
Under General Configuration Properties in visual studio to target your version of SQL Server . you can find the sql server version in SSMS 'SELECT @@version' .
finally this worked for me.
July 29, 2022 at 11:59 am
Under General Configuration Properties in visual studio to target your version of SQL Server . you can find the sql server version in SSMS 'SELECT @@version' . finally this worked for me.f
This is a question about SQL Server 2005, TargetServerVersion was a feature added in SSIS 2016; long after SQL server 2005 was out of support.
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.Larnu.uk
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply