Why change the variable to a temporary table if you're just going to SELECT from it afterwards? Just skip the middle man.

The only other thing is don't INSERT the data into a table variable, and instead just SELECT the dataset. - SHould I just comment out the INSERT part and...

Considering that the above is a multi-line table value function, the syntax for creating the 2 is very similar. Just change FUNCTION to PROCEDURE, remove the RETURNS clause and you're...

I'm actually trying to connect to a file server, not a second SQL Server, but maybe the same principle applies?  Is that what you are thinking?  I will...

I assume you mean by "empty" that they have literally no data in it, including headers (and as result the data flow errors)? If so, isn't the real solution to...

Sounds like a double hop issue to me: Your Host -> SQL Server Host (first hop) -> File Host (second hop). I would speak to your network administrator for assistance...

Seems like you should be grouping on the Rank and Mark as well then; at a guess.

FYI,  syntax like '[' + @Base_Alias + ']' is not safe from injection. A value with just a single ] character in it would easily circumvent your attempt to stop...

A tablix, by default, is only showed once. Without knowing what you've done this impossible to answer specifically, but I'd guess you have a grouping on an object that your...

Why not use a table variable instead? Then you have have any number of tables, each store as a separate row, in your variable? Though, this does still sounds a...

Out of interest why do you want to do this? What are you trying to by dropping all your constraints and then simply recreating them?

Constraints need to be dropped in...

What do you mean by "Dynamically" here? You can define the sources/destinations with expressions, yes, but the data flow part of SSIS has to be well...

What do you mean by "Dynamically" here? You can define the sources/destinations with expressions, yes, but the data flow part of SSIS has to be well defined so unless those...

I created a parameter and gave it a value. Can I use my existing Derived Column to pass the parameter's value into one of my SQL fields? I...

One more thing I changed my expression to (DT_Date)(LEFT(RIGHT(@[User::FileNameDate],14),10)) to convert to a date but it returns format like: 3/31/2021 (?) Are there other ways to convert the...