Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,976 through 3,990 (of 59,098 total)

Reply To: Accessing variables dynamically

Pete Bishop wrote:
Any ideas?
Yep, but no one using SSIS seems to like it. Why not just use stored procedures without SSIS?
--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)

February 7, 2022 at 7:29 pm

#3981183
Reply To: Store invoke-sqlcmd result in PowerShell variable and use it for comparison

I can't help here but I have to tell you that putting passwords into clear text is a really bad idea. They really need to be "trusted" connections based on...
--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)

February 6, 2022 at 9:01 pm

#3980987
Reply To: SSIS SFTP using WinSCP

Ah, got it. Thank you. Heh.... yep. Been there and done that myself.
--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)

February 6, 2022 at 8:57 pm

#3980986
Reply To: Comparing nvarchar with string has started generating weird conversion error

It always happens that way with such "no one made any changes" such things. 😀
It would be nice if you could post the actual code you're talking about so we...
--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)

February 6, 2022 at 5:18 pm

#3980977
Reply To: SSIS SFTP using WinSCP

water490 wrote:
i figured out the issue. ignore post.
Two way street here... Can you tell us, please?
--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)

February 6, 2022 at 3:54 pm

#3980966
Reply To: Comparing nvarchar with string has started generating weird conversion error

shaunos wrote:
Has anyone seen anything behaviour like this before?
Yes... and every time someone claims that something has been running for years and no one has made a change, someone has...
--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)

February 6, 2022 at 2:52 pm

#3980963
Reply To: CPU

I'd help on the hardware side of things but I'm not a hardware kind of guy anymore. I did see that your choices may be even more complex because there's...
--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)

February 6, 2022 at 2:38 pm

#3980961
Reply To: CPU

water490 wrote:
Hi everyone
I am in the market for a new computer. I have been comparing various Xeon processors and I am a bit confused by a few things. Intel lists...
--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)

February 5, 2022 at 7:55 pm

#3980906
Reply To: Saving changes is not permitted

Also, you should save yourself some time. USE the search engines for nearly instant answers especially when it comes to such error messages. This one only required the few words...
--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)

February 5, 2022 at 7:53 pm

#3980905
Reply To: What am I doing to get this message?

skeleton567 wrote:
Jeff Moden wrote:
I only get that error occasionally. It may have to do with whether or not someone posted while you were typing or waiting. Ok... just remembered who I'm...
--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)

February 5, 2022 at 7:50 pm

#3980904
Reply To: Saving changes is not permitted

To add to what Frederico posted, here's how you change the setting...
In SSMS, click on {Tools}{Oprionts} in the menu. Scroll down to {Designers} and expand it. Then click on {Table...
--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)

February 5, 2022 at 7:40 pm

#3980902
Reply To: The Great Developer Resignation

skeleton567 wrote:
To Doc, and all of you folks-
Remember this: One day you are going to walk out that door, or some other door, for the last time. The stuff you...
--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)

February 5, 2022 at 7:33 pm

#3980900
Reply To: The Great Developer Resignation

sailtovictory wrote:
I signed up just to comment here.
First, welcome aboard and glad to "meet" ya!
On the rest of it, man, those are always tough realizations. You first have to decide...
--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)

February 4, 2022 at 7:12 pm

#3980782
Reply To: What am I doing to get this message?

I only get that error occasionally. It may have to do with whether or not someone posted while you were typing or waiting.
There are been times where no matter how...
--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)

February 4, 2022 at 6:30 pm

#3980778
Reply To: SSIS Permission - Write File to Shared Folder on Another Server

will299 wrote:
Good one keep it up
Really? What was good about this thread? I could be wrong but I'm thinking that you're just doing a SPAM test. If I am wrong...
--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)

February 4, 2022 at 6:23 pm

#3980774

Viewing 15 posts - 3,976 through 3,990 (of 59,098 total)