Link to home
Start Free TrialLog in
Avatar of Akshay Bhole
Akshay Bhole

asked on

SSIS 2012 Script Task failed

I have created SSIS package in VS 2012 and SQL server 2012, it is working properly V.S. on the local machine
but  I am facing One issue when I am executing my package using a batch file on Server  
I got one error as
Error: 2018-08-30 07:37:43.57
Code: 0x00000001
Source: Script Task
Description: Exception has been thrown by the target of an invocation.
End Error

Can you please  provide a solution how to fix this issue
Avatar of neehar gollapudi
neehar gollapudi
Flag of United States of America image

What does the SSIS package do?
Check for the following
Are you using your account or a server account or a proxy account?
Are you running the batch file from a network folder and do you have the right permissions?
Also Check the file paths( you may have to use the actual server name instead of the drive letter.
Hi,
what's the code in the script task?
are you reading any parameters or values that are server specific?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.