If "business day" = "weekday" then call it that in your code. "business day" implies you're accounting for things like holidays or other events proprietary to your business.

This is a basic logging requirement...

Database grants, revokes and denies are logged so with Log Shipping they are applied to the Secondary. Replication allows you to have mismatched permissions and even mismatched schemas and data...

Polymorphist (1/11/2016)

---

Just an update, I tried removing the Powershell layer and just running the .exe file itself from SSIS, I get the following error:

[Execute Process Task] Error: In Executing "C:\MyFolder\my.exe"...

PS May I ask what it is these PowerShell scripts do and why you need to kick them off from a T-SQL context and who or what will be calling...

A couple options:

1. Setup a SQL Agent Job to run each of your PowerShell scripts and start the jobs from within your proc using msdb.dbo.sp_start_job which will start the job...

I love what TVPs bring to the party especially when coupled with .NET since you can seamlessly pass an ADO.NET DataTable to a stored proc, how great. Performance with a...

Why not just archive the...

Phil Parkin (1/11/2016)

---

Orlando Colamatteo (1/11/2016)

---

Phil Parkin (1/11/2016)

---

Orlando Colamatteo (1/11/2016)

---

For SSIS I was thinking more along the lines of this:

1. Execute SQL Task gets all IDs needing to go into the...

Yet another option that still uses SSIS but that puts more focus into the T-SQL selection logic is to generate a resultset where the data is already interleaved that contains...

Alvin Ramard (1/11/2016)

---

If using SSIS, I think it would be easier to first dump the headers and details into separate files then using a script task to merge the two...

Phil Parkin (1/11/2016)

---

Orlando Colamatteo (1/11/2016)

---

For SSIS I was thinking more along the lines of this:

1. Execute SQL Task gets all IDs needing to go into the file and stores in...

For SSIS I was thinking more along the lines of this:

1. Execute SQL Task gets all IDs needing to go into the file and stores in SSIS variable of type...

I think you are on a good track. Inwould start out watching your memory usage really closely to make sure you leave enough for the OS to do file streaming...

This group-concat SQLCLR aggregate generally outperforms the XML techniques available in T-SQL:

http://groupconcat.codeplex.com

The code on the site has test scripts comparing it to the XML techniques if you want to try...