Hi we will be using a talend template shortly to abstract the schema definition of spreadsheets such that we can plug and play different excel layouts into a general talend etl "program" that lands that data into different configurable sql destinations.
i believe the template is a flat file with one entry for every column. and in the absence of from and to positions, defaults to describing a comma separated input schema.
if this makes sense so far, does ssis have a similar abstract tool/component/capability? one that can facilitate reuse of a generic pkg for ingesting different input formats and land the data in a table whose name is supplied as a variable?
Not that I know of.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 12, 2024 at 2:31 pm
Just wanted to add that SSIS lets you use code (scripting in C# if I remember right), so if the functionality is missing in native SSIS, you can build your own thing with your own logic to make SSIS do practically anything.
One big catch though with SSIS is that you need to have memory and CPU available for it. SSIS operates outside of SQL Server, and as such needs it's own memory and CPU. If you host it on the same server as SQL Server, it shares the license. If you host it on it's own box, you need a SQL license for that box.
But as a nice and easy to reuse thing to use, I am not aware of anything either unless you consider copy-pasting the code between SSIS packages as "reusable".
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply