HI Hi, I have a specific requirement for sending SQL server DB mail. In my scenario, the SQL Server query output should be sent as a PDF or Excel...

Please have a read of the following and post back with any questions:

https://www.sqlservercentral.com/steps/ssis-catalog-environments-step-20-of-the-stairway-to-integration-services

If you have deployed the package to SSISDB, create an environment containing a 'sensitive' variable to store the password.

Then configure your project in SSISDB to reference the environment and map...

I don't know the solution to your problem, but I am interested to know why you would install the rather expensive Enterprise edition on your own PC rather than the...

Here is a partial solution which shows you how to separate out the data for each of the entities.

DECLARE @x NVARCHAR(MAX)
    = N'{
 ...

There seem to be four separate entities in that file (Company, Demographics, Claims, Procedures).

Is your aim to import the file into four separate tables? If not, what is your aim?

SQL Agent runs on the server on which it is hosted, no...

Sounds like it might be some sort of contention issue. You could try reducing the max degree of parallelism and see whether that helps.

Did you take a look at the...

Then you must have SELECT statements in your proc.

INSERT ... SELECT

does not output the selected data to the SSMS window.

You mean, the data? Where, exactly, are you 'seeing' this?

Are these packages running in series or parallel? Are they all hitting the same DB?

The error message you posted is not overly helpful.

Usually (as the message itself suggests), a more specific and helpful error can be found before that one. Please take a look...

In the Flat File Destination Editor, is the 'Overwrite data in the file' option checked?

Well done!

Not a lot of upvotes against that post!

Please post back with any findings.