 | |
DTS from UNIX
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS from UNIX -
09-11-2003
, 04:43 AM
#2
| |||
| |||
|
|
Does anyone know the best way to transfer a large text file directly from a directory in a UNIX server into SQL Server 2000. The main issue here is not to transfer to the Win2k o/s but directly into SQL Server. So a straight direct transfer. Cheers. |
#3
| |||
| |||
|
|
-----Original Message----- If you create a mount point on the Unix box (which I believe is the same as a share in windows) and then have NFS loaded onto the Windows box you may be able to see it. Don't work much with Unix so this is untested. -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Faruk" <Faruk.agoro (AT) csplc (DOT) com> wrote in message news:05fc01c37849$2e130510$a301280a (AT) phx (DOT) gbl... Does anyone know the best way to transfer a large text file directly from a directory in a UNIX server into SQL Server 2000. The main issue here is not to transfer to the Win2k o/s but directly into SQL Server. So a straight direct transfer. Cheers. . |
#4
| |||
| |||
|
|
Thanks for the update. When you say NFS do you mean NTFS? -----Original Message----- If you create a mount point on the Unix box (which I believe is the same as a share in windows) and then have NFS loaded onto the Windows box you may be able to see it. Don't work much with Unix so this is untested. -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Faruk" <Faruk.agoro (AT) csplc (DOT) com> wrote in message news:05fc01c37849$2e130510$a301280a (AT) phx (DOT) gbl... Does anyone know the best way to transfer a large text file directly from a directory in a UNIX server into SQL Server 2000. The main issue here is not to transfer to the Win2k o/s but directly into SQL Server. So a straight direct transfer. Cheers. . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.