Guy Starbuck - All Comments

Code to read Word docs | trouble86.com

Code to read Word docs | trouble86.com — Wed, 02 Nov 2011 22:41:03 GMT

Pingback from Code to read Word docs | trouble86.com

re: SSIS Flat File Export - "Fixed Width" vs "Ragged Right"

George — Fri, 21 Oct 2011 20:00:07 GMT

I having the space issues with Ragged right. It's concatenating my first three and last three columns even when I set the size of the columns. Has anyone experienced this?

re: SSIS Flat File Export - "Fixed Width" vs "Ragged Right"

Brad — Thu, 06 Oct 2011 19:06:13 GMT

Like other comments; thanks for explaining "ragged right." I've spoken of "fixed width" files for years and they've always been what SQL Server is calling "ragged right."

re: Trace Points in Visual Studio 2008

Kevin Earley — Mon, 03 Oct 2011 19:48:43 GMT

Nice gem Guy. How's it been going since you left Stericycle?

-Kevin

re: SSIS Flat File Export - "Fixed Width" vs "Ragged Right"

abc — Wed, 28 Sep 2011 07:20:38 GMT

HHUUUUUUUUUUUUUUUUUUU,KKKKKKKKKK,LLLLLLLLLLLLLLLL

Fixed Length Field Export from SQL Server - Admins Goodies

Fixed Length Field Export from SQL Server - Admins Goodies — Mon, 22 Aug 2011 03:35:21 GMT

Pingback from Fixed Length Field Export from SQL Server - Admins Goodies

re: SSIS Flat File Export - "Fixed Width" vs "Ragged Right"

Greg — Sat, 13 Aug 2011 23:45:02 GMT

I cannot get past an error, which states "cannot write out column for "named column" I took your suggestion and made all fields char with the exception of ints. I can create a flat file using delimited, but I really need the fixed ragged edge. Any suggestions/help would be greatly appreciated.

Greg

re: SSIS Flat File Export - "Fixed Width" vs "Ragged Right"

JohnV — Thu, 23 Jun 2011 16:27:18 GMT

I was able to do it by adding a dummy column (I called CRLF) to the end of the file connection and put the column delimiter to {CR}{LF}. I put an output length of 2, but not sure if it's required.

Be sure to go up to the previous last column and change the InputColumnWidth since it doesn't seem to be an option for the last field in the row.

Best of luck

re: SSIS Flat File Export - "Fixed Width" vs "Ragged Right"

debs — Mon, 20 Jun 2011 15:56:18 GMT

Hi gstarbucks, How do you pad the last column with spaces to maintain a fixed width?

re: SSIS Flat File Export - "Fixed Width" vs "Ragged Right"

gstarbuck — Thu, 02 Jun 2011 20:43:36 GMT

Raj: the data in your last column will not be altered or affected if you use the "Ragged Right" option -- but if you need it to occupy a set number of spaces you may need to pad it with spaces or some other character, to maintain a fixed width.