Viewing 15 posts - 4,891 through 4,905 (of 13,876 total)
November 20, 2017 at 12:07 pm
Are you using a Fixed Width flat file destination in SSIS? You should be able to define all of your column widths there, without the need for any fancy REPLICATE...
November 20, 2017 at 10:51 am
November 20, 2017 at 9:38 am
This is possible and does not require any scripting, just a technique known as 'recordset shredding'. Take a read here, if you'd like to know more.
It assigns...
November 19, 2017 at 1:28 pm
November 17, 2017 at 11:48 am
November 17, 2017 at 10:47 am
Thom A - Friday, November 17, 2017 10:05 AMWrap the ISNULL around your SUM instead.
Or even add another:SELECT
'$'...
November 17, 2017 at 10:21 am
You know it's a Friday when a general office announcement e-mail is sent out and everyone hits Reply To All to send congratulations.
Humbug.
November 17, 2017 at 7:33 am
Thanks for all the replies gents.
The full flow of information is as follows :
1. Read...
November 17, 2017 at 6:50 am
November 17, 2017 at 5:46 am
If you are running in your...
November 17, 2017 at 5:40 am
November 16, 2017 at 1:16 pm
November 16, 2017 at 10:41 am
November 16, 2017 at 5:49 am
Viewing 15 posts - 4,891 through 4,905 (of 13,876 total)