Another option would be to use 2 sources in the data flow - add a merge or merge join and output the results to the destination.  Each input source to...

  Alter Function dbo.WorkingMonthDates (
        @inputDate date)
Returns Table With schemabinding 
     As 
 Return 

...

You can simplify the code by moving the first of the month calculation to a CROSS APPLY:

Declare @monthsBack int = 4;

 --==== Return a DATETIME data type
...

Two similar methods - one returns a DATE data type and the other returns a DATETIME:

Declare @monthsBack int = 4;

 --==== Return a DATETIME data type
 Select...

Was the server renamed after SQL Server was installed?

I am not using the bulk option right now, as I am loading directly from Oracle. I will try it to, but the big question is: How do you...

The difference with using files is that you don't have to tie up both servers the entire time it's running.  Generate your extract on oracle, oracle is done, move...

i need to do it daily, that is why i was trying to so the ssma but the oracle database in on linux and you do need to install...

You can use Powershell to access SSRS - you can start here: https://www.mssqltips.com/sqlservertip/4738/powershell-commands-for-sql-server-reporting-services/

I have an SSIS run frequently every hour in a day to load data from other sources and update data. I would like to set up something like this:...

If the 'second' script is this:

update nlcog.gis.caddo_assessor_info

lotno=ltrim(substring(geog1,10,4),

owner =(Name||' '||Name2),

prop_address=ltrim(street_number||' '||initcap(street_name),

mail_address=initcap(address1||' '||city||' '||state||' '||zip),

short_geog=substring(geog1,1,9);

Then the only changes needed is for string concatenation.  In SQL Server you can do...

The problem occurs when you utilize cluster shared volumes - the secondary node needs to have the...

If I am understanding correctly, you want to match by position - the values in your username list with values in the email list.

Email List: (a1@email.com, a2@email.com, a3@email.com)

User List: (User1,...

Just another note:

This method will 'fail' if an explicit transaction is started - and then rolled back.  Anything written to the table during the open transaction would be rolled back.

The...

I can't provide 'detailed' steps - but I will provide an outline.  You will need to research for further details:

1. Add the new DR node to the cluster - without...