Here is an example of the structure of the ISNULL in SSIS:
ISNULL(ha_charges) || ha_charges == " " || ha_charges == "" ? "0" : ha_charges
which can be...

Found the solution here at SSC from Fraggle back in 4/4/2012:

Actually, I figured it out. The error was more helpful than original thought.

Error: The wrapper was unable to set the...

I changed the Result Set Name to be 0 and changed the query to be

SELECT SUBSTRING(MAX(InvoiceDate), 1, 2)

FROM ...

I just tried setting a breakpoint on the Execute SQL task, there is nothing in the locals window...shouldn't the variable be showing up here?

I remember interviewing at a large chemical plant and noticing that the drives for their brand new Hp-3000 twins were down as I was given a tour of the data...

I sometimes see posts that make me wonder if the written text would have been spoken when face to face. And, this applies to most electronic communication, emails, texts,...

You're right.

If an extract is requested for the date range 2016-09-01 through 2016-09-30 ON 2016-10-01, the data will have 2016 as the [Acct Year] and will end up...

Thanks, Phil.

[Acct Year] is determined in the T-SQL stored procedure that runs and loads the table being extracted. So that data coming in when this runs today has either 2015...

with qTally as (

select

n = row_number() over (order by (select null)) - 1

from

(values (1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))dt(n)

), EOM13 as (

select

CalendarDate = dateadd(second, -1, dateadd(month,datediff(month,0,getdate()) -...