Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,921 through 10,935 (of 59,095 total)

RE: Audit Trial help

SQL learner22 - Tuesday, October 16, 2018 8:29 AM
I admit I did not follow the standard way of posting Topics to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 9:33 am

#2009899
RE: Are the posted questions getting worse?

drew.allen - Tuesday, October 16, 2018 8:34 AM
Thom A - Tuesday, October 16, 2018 3:25 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 9:02 am

#2009887
RE: EBCDIC file is getting loaded with all special characters in my table

Ah... another avenue is to google for "ebcdic to ascii converter". Some are converters you have to pay for but the following link provides some hope for a free method. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 8:59 am

#2009885
RE: EBCDIC file is getting loaded with all special characters in my table

kashyap4007 - Tuesday, October 16, 2018 8:15 AM
Spoke with them and was told that this is the only format they hold the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 8:47 am

#2009884
RE: Are the posted questions getting worse?

DesNorton - Tuesday, October 16, 2018 3:48 AM
Thom A - Tuesday, October 16, 2018 3:25 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 7:45 am

#2009864
RE: Are the posted questions getting worse?

andycadley - Tuesday, October 16, 2018 4:21 AM
Michael L John - Monday, October 15, 2018 7:03 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 7:44 am

#2009862
RE: Are the posted questions getting worse?

Brandie Tarvin - Tuesday, October 16, 2018 4:38 AM
Sigh.
Why oh why oh why do users not understand their own requirements? I've had...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 7:41 am

#2009861
RE: Are the posted questions getting worse?

Brandie Tarvin - Tuesday, October 16, 2018 6:02 AM
Hee. If you had told me 2 years ago that I would be interested...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 7:34 am

#2009859
RE: Are the posted questions getting worse?

@Thom A
I dunno, Thom... I won't help the fellow you just helped (the one with the Blue shirt) because...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 1:37 am

#2009815
RE: Read Length of first Row and Header Row Delimiter through SSIS Script Task

Nah.... do what I do... don't even bother SSIS for this.
I created files for your two sample tables being sure that the first one's lines was terminated with LF only and the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 16, 2018 at 1:11 am

#2009813
RE: Read Length of first Row and Header Row Delimiter through SSIS Script Task

Sorry... I don't have a "test dtsx package", Rocky. I would have done all of this using BULK INSERT all from a stored procedure including reading the file names. I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 15, 2018 at 9:42 pm

#2009803
RE: Read Length of first Row and Header Row Delimiter through SSIS Script Task

If the answer to the last question above is "Yes... I already have these all mapped out in SSIS", there no need to throw all that work away. Just make...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 15, 2018 at 8:54 pm

#2009798
RE: Read Length of first Row and Header Row Delimiter through SSIS Script Task

One more piece of info, please.... do this files have the exact same fields in exactly the same order but are simply different in field width? And both are supposed...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 15, 2018 at 8:28 pm

#2009795
RE: Read Length of first Row and Header Row Delimiter through SSIS Script Task

rocky_498 - Monday, October 15, 2018 8:09 PM
To access BCP file will be a little bit challenge for me to convience IT.
After...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 15, 2018 at 8:26 pm

#2009794
RE: Troubleshooting Deadlock, Victim holding on to shared lock

Have you looked as the stored procedures to see if there's a BEGIN TRAN anywhere?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 15, 2018 at 8:22 pm

#2009793

Viewing 15 posts - 10,921 through 10,935 (of 59,095 total)