Gang, I am currently outputting data into text files using BCP and "exec xp_cmdshell". The other day a peer of mine saw my code and said that this was 'ancient technology'. Funny thing is, he didn't bother to tell me what I should be using instead. I know I could probably be using SSIS but for this specific purpose I wanted to keep it within my TSQL code.
Can anyone tell me what the latest and greatest method is for outputting directly to text files?... I'd like to stay current with the rest of the world.
Can anyone tell me what the latest and greatest method is for outputting directly to text files?... I'd like to stay current with the rest of the world.
Comment