Friday, July 27, 2012 1:55 PM
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
Friday, July 27, 2012 2:02 PM
here is a post that would help you:
You would have to create a "Script Task" and add / modify the code to it.
Hope this helps.
Friday, July 27, 2012 2:03 PM
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.
Friday, July 27, 2012 2:12 PMSounds similar to this
Friday, July 27, 2012 2:42 PM@ Tab AllemanWhere do I click on connection manager? and how would I set up the usernmae and password?
Friday, July 27, 2012 3:05 PM
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.
Friday, July 27, 2012 3:13 PMDo 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.
Friday, July 27, 2012 3:24 PMYou do this when you are building an SSIS package in BIDS.
Friday, July 27, 2012 3:36 PM
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 credentialsAfter that I want to create a job within the SQL Server Agent to process it on a dialy basis
Friday, July 27, 2012 8:11 PMany help on this
Monday, July 30, 2012 2:50 PM
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.
Monday, July 30, 2012 3:50 PM
(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