Hi,
I have an SSIS package ..it has 2 sql script tasks and 1 transfer sql server object task....It works fine in BIDS...but when I was trying to execute it by going to its location with .dtsx file...It gives me the following error
Error: Validation method on the task failed and returned error code 0x80131501(failed to connect to the server ) The validate method must succeed and indicate the result using out parameter.
Does anyone know how to solve this issue?? any help would be appreciated...