Anyone?  I can't believe the SSIS package logs don't allow me to see the connection strings for the source and target tables at the time the job was run.

I hope this is applicable...

There are a lot of good examples here:  https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/wide-world-importers

Clone the repository, open the solution, and review the SSIS packages, and the...

Hi All,

More input on this...

I ended up using a lot of synonyms based on this:  https://www.sqlservercentral.com/Forums/1916222/How-do-I-code-a-threelevel-table-name-in-SSDT-that-will-honour-environment-settings-in-deployed-job.  I'm following Jeff Moden's and Steve Jone's advice.

No:  1) I've changed Plain Text in the settings, 2) your example is a .sql file, mine is a .dtsx package.

Also, I've done a performance comparison of DelimitedSplit8K vs. DelimitedSplit8K_LEAD, given my use case and minor code changes noted in previous posts above.

DelimitedSplit8K:

SET STATISTICS...

I have previously modified my copy of Jeff's code to only return non-blank items, and return them stripped of leading and trailing spaces.

Here is an excerpt of my...