Showing posts with label square. Show all posts
Showing posts with label square. Show all posts

Sunday, March 11, 2012

Bug in the SSIS?

When viewing the flat file through the viewer , certain rows showing up as a small black square where there is a line feed and these rows are getting concatenated and being counted as one row.

Anybody knows why this is happening?

Thanks

Karthika

Make sure you have the correct row delimiter chosen. Unix files, for instance, typically only have a LF as the row delimiter. Windows files typically have a CR/LF as the row delimiter. Try choosing different values.

Tuesday, February 14, 2012

Break on Running Total

I am trying to create Packing List(s) based on an individual sales order.

Each Packing List page must be based upon the number of square feet.

I have set up a detail line with
Pieces, Width, Length and a running total of square feet (Pieces*width*length)

When the Running Total Square Feet > 400 then I need to go to a new page and reset the Running Total Square Feet and continue to print the remaining detail, until it again reaches 400 square feet.

I'm close, but I am having trouble. Can anyone help?

Note: Its MAS 90, if that makes a difference.What did you try and what problem are you facing?