Hello @ScottPletcher and @SSC Guru I am really sorry to say but don't even know how to do it and also, I really thought that the way I've explained,...

And please post SQL code in a code block.

Nice solution, Jeff.

Copy the results of your PRINT @sql into a new SSMS window & work it out from there, it should be easy to spot.

I wrote an article a while ago which may be of interest. It shows how to decompose the DTSX XML into something usable.

https://www.sqlservercentral.com/articles/ssis-variable-and-parameter-analysis

Searching the dtsx files in source control is your best best. The package XML is encrypted in SSISDB, do don't waste your time on that.

Add the schema to your table-name list.

I would manually update the file from a folder, and this list of tables won't change. The alert will run daily maybe every x hours..

We had an issue where...

The standard trick is to import the header row as if it were data and then discard it in the data flow (use a Conditional Split to do this).

Also add...

Sorry, I've been doing this stuff for so many years that I have no idea about suitable training resources for you.

Sounds like triggers are your best bet. What sort of alert do you have in mind?

If a user modifies 5,000 rows, do you want 5,000 alerts generated?

If thousands of alerts...

In answer to your last question, the best you can do is

a) Describe what you are trying to achieve and what you want help with

b) Provide sample data in the...

• This reply was modified 2 years, 11 months ago by Phil Parkin.

Well, maybe it's time you learned a bit more. My script is straightforward and does the following things:

1. If a temporary table called #t1 exists, drop (delete) it
2. Create a...

If you open the link, there is a PDF option as well.

Is there anyway to import PDF file data...

Generate your own would appear to be the next resort.