January 15, 2013 at 2:09 am
I have a problem to call file from another server with dtsx, any one know this?
January 15, 2013 at 2:17 am
What are you trying to do?
Import flat files from Server1 into a database on Server2?
If so ensure that you have setup the correct file shares, use UNC paths in your SSIS package and ensure that the nessesary security has been applied to the share so that the SQL Agent or the proxy account used to run the SSIS package has access.
January 15, 2013 at 2:20 am
yes but this transfer is using ssis and processed to database directly.
January 15, 2013 at 2:23 am
As detailed, create a file share on Server1, ensure that the nessesary permissions are set on the file share, then use a UNC path to access the server like the below in your flat file connection manager.
\\Server1\ShareName\FlatFile.txt
If you have multple flat files to import use a for each loop, passing in the file name as a variable and using an expression to the flat file connection manager so that the path changes dynamically with each file read from the share.
January 17, 2014 at 1:42 am
Helpful information provided I'm very delighted to see this post..many thanks for presenting all of us great information.Great walk-through. I appreciate this kind of write-up.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply