I usually stay away from expressions when I assign values to variables.  I generally use a SQL Task, once you figure it out, I find it easier to maintain.
Also...

I am surprised no one here mentioned Error Handling like try catch.
Print statements and logging errors will help.
There has to something different when you are running in ssms...

   DECLARE @crlf CHAR(4)
    DECLARE @v_SQL varchar(MAX) = ''
    SET @crlf = CHAR(10) + CHAR(13)

    SELECT @v_SQL = @v_SQL + 'DELETE FROM dbo.Some_Table' + ' ' + @crlf   ...

Thanks for your confirmation, I did stumble upon the answer knee deep in the documentation.

I have to get one record, get a xml node that contains the total records, then...

Try this:

WHERE roofyearbuilt <= YEAR(DATEADD(yy,-17,GETDATE()))

I saw someone post the idea of a script task and think this option is your best route.

I did this a few times, I just imported the data into one...

While I agree with Jeff that working with Excel using SSIS has a lot of drawbacks, I have done what you are attempting.

You can start writing the rows to the...

Hello,

In the project Properties, on the Debugging tab, ensure the Run64BitRunTime is set to false.

I agree with all that data conversions should happen in SQL, import all as varchar. I worked with a programmer whom tried determining data types in SSIS and ncoa'd...

SELECT column_A,

column_B,

SUM(Column_4)

...

Don't know if this is the cause but when you are working with excel go to the Project Properties--->Debugging and set Run64BitRunTime to False

Not to sound like an advertisement for redgate...(I don't work for this site or redgate)

But Redgate has a great tool in SQL Compare which would be perfect for what you...

In regards to my previous post, we have the jobs tied to a pager which the developers take turns monitoring.

So when the processing step checks fails, we are alerted and...

We have a job that runs for hours and have another Job that runs this code at a certain time to alert us that the job is running late or...

Here is a simple way, create a step called Check Schedule

DECLARE @FirstDayofMonth date

SET @FirstDayofMonth = DATEADD(month, DATEDIFF(month, 0, getdate()), 0)

--print @FirstDayofMonth

IF @FirstDayofMonth <> CAST(GETDATE() AS DATE)

BEGIN

RAISERROR ('Not...