June 12, 2008 at 9:00 am
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...
June 12, 2008 at 11:46 am
Its not clear(Going to its location ???), how r u executing exactly and when r u getting this error ?
-V
June 12, 2008 at 11:54 am
Thanks for the reply...The package is located in C:\SSIS folder....I have both .dtsx file and .dtsConfig file in that folder...when I click .dtsx, it guides me to execute package utility....there I add the configuration file and execute it...
June 13, 2008 at 3:41 am
Are you using config files, and how are you connecting to SQL (windows or SQL authentication?)
June 13, 2008 at 3:48 am
yep...I m using xml configuration files....in windows authentication...
June 13, 2008 at 3:52 am
I would wager that whatever is running the SSIS package (normally the agent), doesnt have sufficient rights to the SQL connection
June 13, 2008 at 4:06 am
I log in as the administrator...can u specify me what rights shoud i have?? and I m not using agent service to run the package...thanks for ur reply....let me check my login rights....
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply