I think the problem with the fixed width format will have to be addressed by the Sql Server SSIS team. I just use the ragged right format since it works...

Thank you. I found the same answer through some research and trial and error. Hopefully this will be resolved in a future version of SSIS.

Thanks,

Michael

Thank you very much for taking the time to help. I very much appreciate it. I had come across that article shortly after I posted my inquiry here. It is...

Perfect! Thank you. That works fine...but wouldn't it be nice to know how it is supposed to work?! I appreciate everyone's input and helpful suggestions.

Thanks,

Michael

Thank you, I was not aware there were two formats for fixed width. I will try to figure out the configuration for the second format. Regarding the concatenating of the...

Thank you for your reply and suggestion. I am using a fixed width output format that consists of one column 133 characters in length. I can not seem to get...

Hi Carolyn,

If the quantity for the mail code always refers to an order (ie, postcards for instance are not mailed out with one of the mail codes for example) then...

Thanks Steve. I should have mentioned that I use the partition manager to set the aggregations for each partition. I recall now that I a few days ago I found...

That's it! That is what I remember now that you mentioned the correct syntax. Thanks Steve! I will test this tomorrow morning...

Thanks, Steve!

Michael

Which service pack are you running? Seems to me this was an issue that was resolved in either SP2 or SP3...Are you talking about the query timeout setting?

Michael

Thanks Steve and how is everything down under these days? Seems I remember you could do something like:

WHERE ([Call Date].[Year].[2003].[Month].[11].[Day].[1]:[Call Date].[Year].[2004].[Month].[1].[Day].[30])

Does that ring...

Did you ever get this figured out? I am having an issue that results in the same error message when I try to open any DTS package in design view...

Thank you, Shawn. I will check the perf mon counters for the memory to see what is going on for certain. From all the documentation I have come across, it...

Thank you, Shawn. I will check the perf mon counters for the memory to see what is going on for certain. From all the documentation I have come across, it...

Is there another way you can post the graphs? They don't show as currently posted...

Michael