variable valueRemote path

Question

Post reply

variable valueRemote path

chinni-652949

Default port

Points: 1425
More actions
August 14, 2008 at 10:01 am

#123035

Can we provide a value like remote path to a variable (string)
eg:\\bas02ndke3l\public\resultset.out
i used pacth like c:file\resultset.out , but i want the file from a remote path....
thanks for the help

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SrikanthSv Ten Centuries Points: 1197 More actions · Answer 1

90 percent i'm sure it doesn't work

probably give a try and check the results

Regards
Venkat
http://sqlblogging.blogspot.com[/url]

Mukti SSCrazy Points: 2826 More actions · Answer 2

Are you using this variable to set connection string to a file connection? (I didn't understand your question properly, What exaclty is the issue?)

If you are trying to do this..it should be perfectly ok to do that. Use Expressions to set the ConnectionString.

chinni-652949 Default port Points: 1425 More actions · Answer 3

instead of getting the .out file from C:\path i would like pull that from \\b23jksl0sdhnw\data.....i would like to provide this path.We declare a string and assign this path to the variable when we need to use in a sql script task.Is this possible?

the package is failing when i give this path....its showing error like path not found

thanks

Crispin Proctor SSCoach Points: 18161 More actions · Answer 4

I suspect, the path is not found then...

Firstly, the value of the variable means nothing to the variable. It's a string. You can put what you like in it.

As for your package failing, what is the error? Is it failing when run from agent? If so, does the account that agent is running under have permission to read / write to the path?

If you are using it in an expression, a "\" is an escape character. You need to double them up.

example: \\\\myserver\\myshar\\myfolder.

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

chinni-652949 Default port Points: 1425 More actions · Answer 5

no its not working even if i give double '/'

character

\\\hbdk34nb66ml\\folder\\data

Mukti SSCrazy Points: 2826 More actions · Answer 6

I am still not sure if you are using this variable to set connection string of the file or you are just using this variable to build your xm_cmdshell command.

Either case this should work fine give the account under which you are running the package has access to this network folder.