July 1, 2008 at 10:05 am
I am new to BI so be nice please.
Here is an over view of what of the process.
1. Connect to Client FTP Server Download files
So lets say for April I will download SHSEXT080401.ZIP, SHSEXT080402.ZIP, SHSEXT080403.ZIP and so on tell I get the 1st thru 15th files.
2. Move the files to Our Sever which is the Server SQL 2005 Resides but is a remote server also.
3. Merge the 1st thru 15th files into one Zip file called SHS_20080615.zip And Place this file in a different location remote Server 2 (SQL 2005 Server).
Now there is more but for now my issue in one connecting to Remore Server to get files and second is Contecting to remote server where I need to place the file.
July 1, 2008 at 5:56 pm
The server you are running from needs to be able to access the file location on the other 2 servers. You can then write the file path as \\server\(etc.) instead of using a drive letter (C:\(etc.)). I normally put the file path in a variable. In the connection for the file, I use the expressions in the properties window to access the variable.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply