Are you sure about that?

When you create SSISDB, you are presented with this screen:

After you complete this screen, the master key is created for you.

If you still...

Run the package in debug mode to determine exactly when the error is generated. Also to be 100% certain that the connection string being assembled is in the right form.

As long as it's not marked as 'sensitive'.

Try running this in SSISDB as you'll see for yourself:

SELECT * FROM [internal].[environment_variables]

Did you also recreate the Master Key? Without it, you won't get very far, as some of that db is encrypted.

Not possible, as far as I know. It's not the first time this question has been asked!

You can modify the default order in which the packages are displayed by modifying...

I presume you've considered pushing the data into a staging table first and then pivoting from that?

I would expect it to be faster than the SSIS component, and your column-naming...

Have you considered just skipping the first row?

Contact the web site admins and ask them, maybe?

Why not script out the entire thing in VB? What does your macro do?

As I can't see your tables...

As you have not provided any DDL, I had to make a guess.

drop table if exists #x;

create table #x
(
    Ident varchar(20)
  , Name...

As you've not even provided your query, I'm not sure how you expect anyone to help you change it!

Also, this is a presentation issue. SSRS will easily do this for...

You could use SSDT to run a schema compare. This can be an automated process, if required.

I think you may have misunderstood me. Look at these columns, for example:

,Entry_summary_date

,Supplier

,Destination

,Part_num

,Manuf_id

,HTS_num

How can anyone look at this...

i should  get  a few thousand rows back, but when i try pull in Duty Rates, i get hundreds of thousands. Thoughts?

Thought #1: Your join is not working as you...

This post appears to be a duplicate of

https://www.sqlservercentral.com/forums/topic/mail-when-value-of-field-or-paramater

Which already contains suggestions (and some outstanding questions) as to how you might approach this.