I agree with you on the format should be YYYYMMDD. I will try to make the business stake holder to abide to it.  Thanks! much appreciated.

this expression returns '2018-06-30' which is correct, but how do I convert it to '06302018', which is the format date at the end of the file?

July 9, 2018 at 11:33 am

#1996837

Oh, got it! One more question though (and pardon my ignorance):  Drew hard coded the variable @ARandomSaturday to a Saturday' specific date. My thought is; Does it need to be...

Thanks for the post, but that doesn't exactly help me, as I need the ssis version builder syntax for it.

I figured it out.

I needed to set the data type for column being summed as decimal in the flat file connection manager because the QUANTITY column in the...

I fully agree.  Just as FYI, after selecting "ragged right" you still need to adjust you field lengths and renaming the field names.

Sue,
I opened it in Note++ and indeed was able to better make out the columns and their length, so I went back to ETL and this time I selected...

Hi Everyone,

I checked the directory to the share and I do have access to it.

Sue,

I went ahead with your suggestion, created the .bat file;...