I do not have a solution, though maybe there is a a clumsy workaround.

Use the Transfer All Jobs option, then adapt your existing T-SQL to drop those jobs on the...

To (INNER) join table T1 in database DB1 to table T2, in database DB2, you can use this syntax (assuming you are running the query from the context of DB1)

SELECT...

• This reply was modified 7 years ago by Phil Parkin.

I ran the query using your formatted query but it's just executing (running almost 7 minutes and still running) as looks like because of the CROSS JOIN, it's doing...

If there's a question here, I...

As far as I can see, BD.Morg.loan does not appear anywhere in your query. Are you sure about that error message?

Here is a formatted version of your query, which may...

A reformatted version. Don't know how you can read the one you posted!

SELECT [Event Type] = EventType
      ,[Company Number] = ccro
 ...

I guess I should have checked which forum I was in, before answering 🙂

You've been here long enough to know that providing pictures is not the best way of asking for help. Instead, please provide DDL, sample data in the form of INSERT...

Can you provide sample DDL, INSERT scripts and desired results, please?

If this is a script component source, and you are reading from a file, then there is not yet any concept of tables.

All that you can do here is add...

Thanks Phil, I need to use a Script Component so please can you give any advice on my question as it is stated. I don't mind what type of...

CSV files are not tables. If you are importing from a CSV, you should not need to use a script component source. Instead, use a flat file source.

+1 for everything Steve wrote.

If it works, why change it? There need to be some serious benefits in order to justify this.

• This reply was modified 7 years ago by Phil Parkin.

Where others use variations of "foobar" for things they can't think of a name for, I use variations of "noddy". You're not the...

You must work in Toyland.