OK, is it fair to assume that you cannot, or should not, modify the design of either of these two databases?

Is it one-way traffic (ie, from A to B but...

Are the databases on the same SQL Server instance?

Does the movement of data need to be instant, or is a lag acceptable?

Do you have any particular software tools in mind...

If your question is as simple as "can data be moved from one database to another in SQL Server?" the answer is yes and there are numerous ways of doing...

However, it's worth noting that FOR XML PATH has some advantages in specific cases, such as handling complex string concatenation, concatenating multiple data points, and managing special characters more...

As for SSIS, I really do not understand why some smart people believe it does better job than other methods, good old bulk insert for example. MS SQL never...

Without sample data and DDL it's not easy to provide working code.

But in pseudo-code, something like this

select sum(iif(date in last month), value, 0)

That's good advice from Frederico.

Sorts in SSIS are to be avoided if possible, as they are blocking components and perform very much worse than in-database sorts.

If your tables reside on...

You could build the pivot dynamically in T-SQL (sample link), but getting that out of SSIS and into Excel is extremely tricky, because SSIS likes to know its columns...

It's been a while since I've had to do this, so I just created a dummy package to work it out again.

Here are the steps that I took:

1. In your...

Are you confirming that you have done as I suggested and that the same error occurs?

If you don't need NAME at all, take it out of the data flow by going into the data source advanced editor / column mappings and setting Output Column to...

OK, those errors are actually pretty helpful.

There must be one or more occurrences of the column NAME in file

ADAP.O#Adaptimmune Therapeutics ADR Representing 6 Ord Shs (D).csv

where the data is longer...

• This reply was modified 1 years, 9 months ago by Phil Parkin. Reason: Fix typo

Were you logged in as a SQL Server user or a Windows user when you tried this?

Are the 'could not find' objects still present? Eg, Is_Valid_Name should be here:

I'm trying to run through SQL Agent job. Only issue is coming in the packages where transformations like Multicast, conditional Spilt etc. are being used.

When run directly through Visual...

Can people please use the {} Code tags when posting code, as it makes it so much easier to read.

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
 ...