• Hmmm, -w works for me. Please check the command line you are issuing to xp_cmdshell.

    You can try this simple command line as a proof-of-concept.

    bcp "select top 10 object_id, name from master.sys.tables;" queryout "C:\1.txt" -t";" -T -w

    Re: SSIS, I would recommend anything from Brian Knight. You are on 2005 so here is a good book:

    Professional SQL Server 2005 Integration Services. I am actually reading the reprise of the same book geared towards 2012.

    Even though you are on 2005 I think it's worth learning 2012. Most of the concepts are the same so will still be backward compatible into 2005 development. Here is a good training book to go along with the textbook-style book above:

    Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato