SqlContext.Pipe.SendResultsStart(record);
            string[] stringFiles = Directory.GetFiles(strDirectoryName.ToString(), "*.*", bSubDirectories ? SearchOption.AllDirectories : SearchOption.TopDirectoryOnly);

            foreach (string stringFile in stringFiles)
            {
                try
                {
                    stringFileName = stringFile;
                    FileInfo objFileSize = new FileInfo(stringFileName);
                    lFileSize = objFileSize.Length;
                    nFileSize = (int)(lFileSize / 1000);
                    record.SetString(0, stringFileName);
                    record.SetInt32(1, nFileSize);
                    SqlContext.Pipe.SendResultsRow(record);
                    SqlContext.Pipe.Send(@"File:" + stringFile);
                }
               catch (Exception xx)
                {
                    //SqlContext.Pipe.Send(xx.Message + Environment.NewLine + stringFile);
                }
            }
            SqlContext.Pipe.SendResultsEnd();
            SqlContext.Pipe.Send(@"*** End");