Your link gets...

Even if the format is NOT fixed, you can use the Tally Table-based string splitter function from this very site (authored by Jeff Moden in an Article with...

Scott,

You didn't say why the max row for the first group was not summing the two rows...   you just say it's the max row so it maintains the value from...

I get the following error message when trying to create an "environment" within a folder in the SSIS Catalog:

Msg 15581, Level 16, State 7, Line 17

Please create...

Even if the format is NOT fixed, you can use the Tally Table-based string splitter function from this very site (authored by Jeff Moden in an Article with a title...

Just curious - is the SQL Browser service active?

Okay, that explains a great deal.   However...

If you are going to have a product represented by a SKU, and that product is simple if it's unique, meaning that there are...

• This reply was modified 5 years, 7 months ago by sgmunson. Reason: Forgot to include the Price column... DUH !!!

Ok, but I think there's a fundamental mismatch between the way one would normally design a table structure, and what you appear to be doing here, although I can certainly...

Hi ratbak, thanks for your advice, and it works. However, it works if its a truncation error. How can I capture if my source is varchar and destination is...

First thing is, are you looking to avoid SSIS altogether?   I ask because setting up SSIS to export data from a stored procedure into Excel is relatively easy to do. ...

• This reply was modified 5 years, 7 months ago by sgmunson. Reason: Forgot to add the Flat File Connection Manager requirement.... DUH !

In SQL Server 2019, this value can be provided by scripting out the addition of the reference, which you create in SSMS (the reference, that is), and rather than clicking...

Wow... talk about dumb things.... turns out you actually have to cast the NULL function, which already contains an explicit data type, to the DT_STR data type for the expression...

Honestly, I have to wonder what the end objective is here.  If anyone thinks that they can just dictate a specific bus seat for a specific child or...

If you query the table to get the row count, your query will be the one that gets measured for logical reads.   I'm pretty sure you need to use Jeff...

Honestly, I have to wonder what the end objective is here.  If anyone thinks that they can just dictate a specific bus seat for a specific child or set of...