exporting data to flat PATH

Question

not sure this question should be here.

I'm trying to create a fully qualfying path so that I can drop a flat file into a location on a different server. I have credentials to do it. but I'm not sure how to set up my path/string .

Does anyone know how to do this

example \\100.00.555.00\UE\Im\UE-Document\Watch\Test.txt username password credentials

Answer 1

here is a post that would help you:

http://stackoverflow.com/questions/766033/copy-file-to-remote-computer-using-remote-admin-credentials

You would have to create a "Script Task" and add / modify the code to it.

Hope this helps.

Answer 2

Put your path into a package variable.

A flat file destination gets assigned a connection manager.   Click on the connection manager, and in the properties window, find "Expressions" and click on the + sign.   Assign the "FilePath" property to the variable you created. 

---

-Tab Alleman

Answer 3

Sounds similar to this

---

http://btsbee.wordpress.com/

Answer 4

@ Tab AllemanWhere do I click on connection manager? and how would I set up the usernmae and password?

Answer 5

On my screen, the connection managers are at the bottom of the screen.   When you click on one, the properties appear in the lower-right corner, under the solution explorer.

username and password would be in the "Connection String" property of the connection manager, which can also be assigned to a variable in the "Expressions" property.

---

-Tab Alleman

Answer 6

Do I have to log into Integration Services? Right know I'm logged into the database engine and setting up my export and then setting up a job.

Answer 7

You do this when you are building an SSIS package in BIDS.

---

-Tab Alleman

Answer 8

I connect to my database engine not the intergration services.

Next I go my database and I create a task to export.

within the process of setting up the task I put in a query that creates results for the export.

Then I set the destination of the flat file.

the destination would be something like this \\100.00.555.00\UE\Im\UE-Document\Watch\Test.txt username password credentials

After that I want to create a job within the SQL Server Agent to process it on a dialy basis

Answer 9

any help on this

Answer 10

the destination would be something like this \\100.00.555.00\UE\Im\UE-Document\Watch\Test.txt username password credentials

I have never heard of creating a file path like this with the username password in it.  

The way I would do this is to put the file path in a variable the way I described above.

Then when you create the job, have the job run as the username/password that you want to use.   Then those credential will automatically be used to access the file.   That is the only way I know to do what you want.   If there is another way involving putting the credentials at the end of the path, I have never heard of it.

---

-Tab Alleman

Answer 11

(even though i strongly suggest to use the above solution that I suggested)

You can do something like the following:

net use \\Development\myfolder mypassword /user:Administrator
copy newfile.c \\development\myfolder

http://stackoverflow.com/questions/10313/can-i-copy-files-to-a-network-place-from-a-script-or-the-command-line