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 4 years, 2 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 4 years, 2 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...

Just an fyi, but this problem was the why behind two other posts, as I had been thinking that the only way to make the Execute SQL Task work with...

For the solution to this, see the following post:

https://www.sqlservercentral.com/forums/topic/ssis-expression-task-does-it-even-work

I spent a LOT of time searching online and struggled mightily to overcome the errors introduced by just one misinterpretation of...

Glad it was helpful, homebrew...  It was a real bear of a problem, and very difficult to find the information online that was needed to quickly solve it.   Only rarely...

okay folks, here was the entire issue:

1.) I had misinterpreted some of what I saw online, and ended up setting the property "ExecValueVariable" to the variable I had wanted to...

Well folks, this one sure was interesting....  it now appears that setting the ExecValueVariable to anything other than "<none>" causes it to fail, although it may be that setting it...

• This reply was modified 4 years, 3 months ago by  sgmunson. Reason: Adding a picture for additional clarity