Post reply

Export query to tab delimited file.

  • November 29, 2011 at 8:52 am

    #1414152

    Thanks Dev! That sounds an easier option. I will have a play and let you know how I get on

    Many thanks for you time

  • November 29, 2011 at 10:09 am

    #1414233

    Dev, I have been looking at the Import and Export tool and it is creating the right format. I am now going to put a schedule on it and exce my ftp put in and rename.

    Thanks for you help on this.

  • November 30, 2011 at 1:17 am

    #1414474

    kyle.doouss (11/29/2011)

    Dev, I have been looking at the Import and Export tool and it is creating the right format. I am now going to put a schedule on it and exce my ftp put in and rename.

    Thanks for you help on this.

    No need of thanks buddy. It’s you who explored all the options (xp_cmdshell, BCP, Format Files, SSIS and Export Import Wizard).

    Nice Job! Keep it up.:-)

Viewing 3 posts - 16 through 18 (of 18 total)

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