sirkinghorse

Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

RE: JSON AUTO, WITHOUT_ARRAY_WRAPPER not returning all the columns

sgmunson - Tuesday, September 18, 2018 6:21 AM
Have you tried adding the INCLUDE_NULL_VALUES option ?
No, I'll google it and see how to...

September 18, 2018 at 6:24 am

#2006103
RE: SSIS Package Execution

Elliott Whitlow - Wednesday, October 14, 2015 5:19 PM
sowmyapasala5 (10/14/2015)
Thanks Elliott Whitlow.Well I am trying to load a folder which contains same...

September 18, 2018 at 6:20 am

#2006101
RE: JSON AUTO, WITHOUT_ARRAY_WRAPPER not returning all the columns

sgmunson - Monday, September 17, 2018 7:42 AM
Are any of those columns having NULL values?
Yes some are.

September 18, 2018 at 12:35 am

#2006078
RE: How do I use IFF statement in the WHERE

andycadley - Wednesday, August 29, 2018 3:49 PM
Dumb moment on my part, try:

August 30, 2018 at 1:39 am

#2003960
RE: How do I use IFF statement in the WHERE

andycadley - Wednesday, August 29, 2018 3:19 PM
Just write it as a piece of conditional logic, i.e.
WHERE (@ExMaxBC = 0...

August 29, 2018 at 3:30 pm

#2003917
RE: There is a data source column with no name.Each data source column must have a name.

Hi
I do get this error but I already have SET NOCOUNT ON

June 26, 2018 at 1:03 am

#1995229
RE: SSIS: How to load a data from a table to a file, into 50 000 batches (50 000 rows at a time)

Batches of 50k, that's the requirements. if I have 200k in the table, they want that in a file, but 50k per file.

June 25, 2018 at 6:32 am

#1995131
RE: SSIS: How to load a data from a table to a file, into 50 000 batches (50 000 rows at a time)

I need to produce a file with 50k records/batch for whatever number of records in the table, the table currently it's at 200k, it could have been 130k, then I...

June 25, 2018 at 5:35 am

#1995121

Viewing 8 posts - 1 through 8 (of 8 total)