how to Skip Validation

Question

1.00/5 (1 vote)

See more:

i am having some major permission rights crises.

Task is just to copy a file to another destination and overwriting it.
and orginal file is place at remote source and have to be placed at another remote destination.

now PC A has all required rights to do this task. already used simple File system task to do it it works fine.

now PC B (Server) has (as i come to know) no freaking rights to execute this task.

now issue is file placeing task needs to be done once a specific task is completed that unfourtunatly runs on PC B, i am placeing this task box in that package

esay solution would be to call Vendor an ask him to give same rights as of PC A to PC B
thing is i dont want to, not coz he is a velociraptor and a hit man. :)

Senario Already used are

Number 1: Created File system Task at PC A, saved it in SQL Server Packages(MSDB) and then created Execute Package task at PC B, connection used was SA login of PC A, ERROR: Connection time out

almost same
Number 2: Create File system Task at PC A, saved at letter drive and then created Execute Package task at PC B, File system method was used to locate Package at PC A, ERROR: failed validation.
Because package of PC A is opened in design mode at PC B and then rights issue of placing files i guess.

can i skip validation?
can i create Job at PC A that runs after a completed task on PC B?

Posted 17-Dec-13 10:38am

MAbubakar.Riaz

Updated 17-Dec-13 10:51am

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 17-Dec-13 22:30pm

PCs cannot be granted or denied any rights, only user accounts can. The accounts are not necessarily assigned to a human user, there are accounts for some kinds of services and other entities. The question is not clear.
—SA

MAbubakar.Riaz 5-Jan-14 13:46pm

yes exactly, if this account is an entity like a server how do i grant login rights in SQL to sever named c-lhe-123\administator or its instance i.e 10.60.12.12\sqlserver2005..... and how do i grant it folder accessing rights in windows file system... i think this is my problem....:(

Sergey Alexandrovich Kryukov 5-Jan-14 14:04pm

You should look at the account used by a service. There are some two predefined account, or you can install a server with authenticated account you created. Then, act as administrator and add the permissions to the file system objects. This is not even programming, but a administration work. For installer toolsets, there are steps to adjust file/directory privileges. You have to run installer with elevated privileges anyway.
—SA

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)