Post reply

Need to load file from and manipulate with Unix

  • April 26, 2007 at 8:59 am

    #175947

    Hi,

    I need to load a file from Unix system. Is there such capability in SSIS or other SQL Server parts ? What I actually need is to find a way how to copy it from Unix to Windows, and then I can simply BCP it in. After file loading I also have to remove it from the source, is there a way to run Unix command from SQL Server, like our xp_cmdshell ?

    Thanks

  • April 26, 2007 at 9:40 am

    #702656

    I would recommend to create/schedule a script on unix system to copy the file to network share that SSIS can access then delete it from the source.

    Good day,

    Bulent

  • April 26, 2007 at 11:16 am

    #702709

    In my situation, the process must be synchronous, and it must be controlled from the SQL Server side. After 1st table is loaded SQL Server must send a command to delete it from a network share and start dumping 2nd table from Progress database running on Unix, and so on.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply