Can this be done?

Question

Can this be done?

jonathanm 4432

SSChasing Mays

Points: 619
More actions
July 21, 2015 at 7:37 am

#319123

Hi all,
I have a situation. I was wondering if there is a way to copy files from a network to an ip site where you would need to log in at. What I am trying to do is make a SP that would take all .csv files from the network drive and place them in the other ip address folder however you would need to use the login information. Does anyone know if this can be done? If so, can you give me an example. My info is below:
Copy all .csv files from \\myfolder\web_data\Weblinc Sent to \\16.10.1.11\import where the user name is test and the pw is 12345

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Powershell should have a method. It's not really something that you'd do within a database.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

jonathanm 4432 SSChasing Mays Points: 619 More actions · Answer 2

Never used powershell. Is it something that is easily learned and can be done?

djj SSCoach Points: 18831 More actions · Answer 3

Powershell is not too bad to learn, as I managed to do some with it.:-)

As indicated file movement is not something a database is designed for so the Powershell would be one way of doing it.

amurjani SSC Eights! Points: 872 More actions · Answer 4

amurjani

SSC Eights!

Points: 872

July 21, 2015 at 8:03 am

#1813854

SSIS is another way

Alan Burstein SSC Guru Points: 61141 More actions · Answer 5

jonathanm 4432 (7/21/2015)
Never used powershell. Is it something that is easily learned and can be done?

Check out Stairway to Powershell[/url]

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001