March 31, 2005 at 1:43 pm
I have written several DTS connecting to oracle and sqlserver databases. However, I am trying to connect to a UNIX box to get a flat file and bring it up to SQLServer.
I am not sure what task to use to connect and am not sure if I need to set up an ODBC connection to do this.
I would appreciate any help.
April 1, 2005 at 1:09 am
you can use FTP. Its works with UNIX and Windows environment.
April 1, 2005 at 5:30 am
Do I ne?ed an ODBC connection to use the FTP task? If so, what driver do I use
April 1, 2005 at 8:13 am
No, you do not need an ODBC connection for http://ftp. Just open a cmd window and type http://ftp. If you do no now the syntax for ftp, look it up in help. It's really simple to use. You will 'get' the file from the unix file system and place it to your desire dir on your windows machine. Then you an slice and dice to your hearts content.
There are several ODBC product (Intersolve, OpenLink, DataDirect) that will allow ODBC connect from windows to various Unix flavors. This are third party products that will have to be purchased from a vendor.
Using the ODBC connection you could, more than likely, connect to the flat file directly.
The path realy depends on the frequency of the updates needed and the volume of data.
Noel
April 1, 2005 at 8:16 am
Here is a simple way: Create a get_file.bat file with the following line:
FTP -i -s:get_file.txt (you may have to use a fully qualified name)
Then create get_file.txt with
open UNIX_box (DNS name or IP Address)
login_name
password
lcd D:\Files\Data (cd on SQL Server box)
cd /files_source_directory (cd on UNIX box)
get AROPEN.ASC
bye
Lastly, you run the get_file.bat from DTS.
Most Win/Unix environments can handle this without trouble.
Donhttp://www.biadvantage.com
April 1, 2005 at 12:58 pm
We have Samba installed on our Unix-boxes and put our files on shared folders that can be accesed directly from windows.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply