SQL agent ssis package issue Script Task
-
Hello,
i am trying to get an ssis package to work, the real problem is on the script task. I run it manually on my own personal machine locally, and the SSIS package visual studio 2015 runs fine. I even deleted and recreate the script task twice. i made sure the job is running a domain account that has all access as mine does, including the server has access to all folder paths and permissions, i tested it. i am running SQL server 2016 sp1, below is the error message i get when running SQL agent:
Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 10:57:52 AM Error: 2018-11-16 10:57:53.24 Code: 0xC001F02A Source: UpdateManager Description: Cannot create a task from XML for task "Script Task -- Check # of File in Folder", type "Microsoft.ScriptTask" due to error 0x80070057 "The parameter is incorrect.". End Error Error: 2018-11-16 10:57:53.25 Code: 0xC0010018 Source: Script Task -- Check # of File in Folder Description: Failed to load task "Script Task -- Check # of File in Folder", type "". The contact information for this task is "". End Error Error: 2018-11-16 10:57:53.29 Code: 0xC0010026 Source: Script Task -- Check # of File in Folder Description: The task has failed to load. The contact information for this task is "". End Error Error: 2018-11-16 10:57:53.29 Code: 0xC0024107 Source: Script Task -- Check # of File in Folder Description: There were errors during task validation. End Error Error: 2018-11-16 10:57:53.29 Code: 0xC0010025 Source: UpdateManager Description: The package cannot execute because it contains tasks that failed to load. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:57:52 AM Finished: 10:57:53 AM Elapsed: 0.344 seconds. The package execution failed. The step failed.
i am sadly not sure why its not working :(, again this is only for the script task, i am using C#.
thanks advance
-
good morning, thank you Fred for the input, i did try to apply, but the hotfix says it doesnt apply to the server, plus i have SP2 on SQL and the SP3 for windows 2012 server. please any other input would be helpful, i am sadly stuck and not sure what else to check or try
-
I encountered script task error a while back - turned out the issue was not with script task at all but the package deployment target version pointing to SQL Server 2017 instead of 2016 - check in Project - Properties - Configuration Properties
Thanks
-
thank you @Taps, i tried to switch it from SQL server 2016 to 2014... didn't work, still same error, then i tried to switch it back to 2016, still same error. i would have thought that would be the case since its SQL server 2016 SP2... thank you again for your input, let me know if there is anything else i should try
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply