Viewing 15 posts - 1 through 15 (of 122 total)
I've extensively worked on financial calculations, and based on my experience I would not suggest using the WHILE loop for the amortization calculation if the number of transactions to be...
September 3, 2021 at 1:52 pm
I recommend the following steps:
September 3, 2021 at 1:27 pm
Do you know the number of files (smaller files) to be created out of the table? Or it's dynamic?
September 1, 2021 at 5:24 pm
I think Phil is trying to point out to check if both 32 bit and 64 bit of the Microsoft.ACE.OLEDB driver is installed or not? Please validate this once.
June 22, 2021 at 2:35 pm
Try SINGLE_BLOB instead of SINGLE_CLOB. Microsoft official documentation on OPENROWSET says
We recommend that you import XML data only using the SINGLE_BLOB option, rather than SINGLE_CLOB and SINGLE_NCLOB, because only...
May 29, 2021 at 9:40 pm
I agree with the suggestions from Brian. Also, I was wondering Table Compression can help to save space. I've noticed up-to 80-85% of storage space savings with Table Compression. It...
March 7, 2021 at 10:14 pm
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...
September 11, 2020 at 12:00 pm
What is your current Index Rebuild strategy and how frequently and in what % the fragmentation is happening?
August 27, 2020 at 5:51 am
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...
August 25, 2020 at 2:08 pm
SELECT Original,Cleaned = REPLACE(Original,';#',', ')FROM #ReplaceCharacters;
August 25, 2020 at 1:36 pm
Quick search on SSIS Dynamic Configuration, found these useful.
Using Package Configuration
Using Script Task
August 25, 2020 at 1:23 pm
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...
August 25, 2020 at 1:18 pm
You can use Script task to implement decision tree and to route the files accordingly.
August 25, 2020 at 1:00 pm
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...
August 25, 2020 at 12:55 pm
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...
August 25, 2020 at 11:31 am