InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 03:58:48 GMT20http://www.sqlservercentral.com/Forums/Topic1089-32-1.aspxThat makes sense. I usually pipe to a file and then grep or findstr for any errors.Steve Jonessteve@dkranch.netMon, 26 Nov 2001 08:41:00 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1089-32-1.aspxSteveHi Steve, I ment something like this:truncate table infile_list set @v_commandline = 'dir /B ' + @v_processeddest + '*.unl'<b>insert into infile_listexec @result = master..xp_cmdshell @v_commandline</b> Where ive sent the output of the xp_cmdshell to a table for later processing.CheersChris Sun, 25 Nov 2001 17:10:00 GMTckempstehttp://www.sqlservercentral.com/Forums/Topic1089-32-1.aspxI avoid putting the actual SQL in the steps because it creates a point of maintenance. I'd rather create a stored proc and change that if needed.ckempste:Not sure what you mean? Is this a BULK INSERT variation?Steve Jonessteve@dkranch.netThu, 18 Oct 2001 09:27:00 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1089-32-1.aspxGood article steve. Perhaps worth while mentioning how you can load up sql*server tables from the results of a external command being executed? I cant remember the exact syntax as its 2am and i had a screaming baby in my ear :) but its a nice trick that i used when having to unzip a heap of files from a dir within t-sql. Wed, 17 Oct 2001 13:06:00 GMTckempstehttp://www.sqlservercentral.com/Forums/Topic1089-32-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/sjones/scriptscheduling.asp>http://www.sqlservercentral.com/columnists/sjones/scriptscheduling.asp</A>Sun, 23 Sep 2001 00:00:00 GMTSteve Jones - SSC Editor