How would being trigger from SQL Server help? Understanding this will help determine the best course of action. And do you mean "triggered" in the sense that the process...

What is your current Index Rebuild strategy and how frequently and in what % the fragmentation is happening?

Ohh got it.

I suspect it's not possible. A Flat File Source/Destination is tightly coupled with it's Connection Manager.

However, you can have single package with all 6 files and based on...

Try this.

 SELECT Original
,Cleaned = REPLACE(Original,';#',', ')
FROM #ReplaceCharacters
;

Quick search on SSIS Dynamic Configuration, found these useful.

Using Package Configuration

https://blogs.lessthandot.com/index.php/datamgmt/datadesign/making-ssis-dynamic-configuration-manage/#:~:text=Making%20SSIS%20Dynamic%3A%20Configuration%20Management,-by%20Ted%20Krueger&text=Every%20task%20that%20is%20out,become%20dynamic%20in%20this%20way.

Using Script Task

https://www.mssqltips.com/sqlservertip/1443/integration-services-script-task-to-dynamically-build-package-variables/

You can use Configuration file to store your configurations (including flat file path or other connection string) and then use Script Task to apply decision tree. Right click on the...

You can use Script task to implement decision tree and to route the files accordingly.

queries on ID are typically for a single record, rarely for a small group of ID's mentioned in a list.

nobody is ever interested in records with ID's within a...

I'm not sure specifically what the OP meant by "records [presumably meaning rows] for only the columns that have data in them".

Does that mean rows with NO null columns...

Does it means column...

1. Is it now over-indexed?  All of the rowstore indexes would be used in typical queries, if there wasn't a Clustered Columnstore index, but are they necessary given the Clustered...

Hi Jeff & Steve,

I wrote an article in 2016 on "Work around to scalar functions". I've mentioned 3 workarounds with example.

This was my first article! I hope you would find...

• This reply was modified 4 years, 7 months ago by  Brahmanand Shukla. Reason: Resolved typos

Hi Steve,

Recently wrote an article on Stuff() function. I hope you will find it inline with your expectation!

https://sqlservercarpenter.com/2020/02/04/demystifying-stuff-function/

You can try SELECT * INTO and then rename the table with sp_rename and also create constraints and indexes.

Backup policy can be leveraged more specifically for Point In Time Recovery. It can be also used for DR where the RTO applies but if your Database Size is huge...