Why not use a stored procedure? Would give you the flexibility to sort any way you want, and you can name the procedure something that indicates how the data is...

Not sure why you're repeating what you said. Looks to me like the example OP posted is definitely NOT a correctly built CSV file. You're certainly correct that this would...

If I had to do this, the first thing I'd try to figure out is how to detect the issue, regardless of the final implementation. How can you possibly know...

It most certainly...

I agree with your points, but I think you missed what that quote is really saying.

It's not really about "naming" things per se, it's a comment about how a name...

Sounds like your devs don't know how to use your ORM properly. That's a shame. ORMs semm to often be touted as a "silver bullet" to solve all your database...

Been a developer for 25+ years...I'm no longer optimistic.

IF you have an SSIS server per environment AND you are sure you'll NEVER need to change the parameters in the future (yeah, right) AND you never need to go...

We only have one server with one catalogue.

We use it to override settings that may come from deployments. New project -> Configure -> Link to environment. You may...

Yeah, but you can set the project to "build" but not to "deploy" in the solution's configuration in Visual Studio. That's what I generally do,. I want to "build" the...

I experienced a lot of problems with SSIS complaining about being unable to convert data. All I wanted to do was export my table to Excel, and the only way...

I didn't say "import", I said "export". 🙂

I'm glad you haven't had any issues, I wish my experience was equally "trivial", and introducing a conversion widget in your flow isn't...

Microsoft Excel, that's why....

def func1(p1):
    print(p1)


def func2(p1, p2):
    print(p1, p2)


def func_handler(func, *args):
    func(*args)


func_handler(func1, 1)
func_handler(func2, 1, 2)

I'm not sure what you're really...

I'm not sure what my point really was, but I guess it wasn't really arguing about where to put the semicolon. My issue is more with the lack of consistency...