Nice one, Alan. Much tidier.

Eshika (12/15/2015)

---

I have to deploy a package to the existing folder in SSIS Catalog, I have not done this before, Can you please help..

I have tried to export the package...

I am assuming that you have a reason for not adding suitable database references, to make the errors and warnings disappear?

Here is a rather hacky solution using Jeff Moden's DelimitedSplit8K function:

DECLARE @x XML = '<?xml version="1.0" encoding="UTF-8"?>

<StaffingOrder>

<OrderId validFrom="12/31/2015" validTo="12/31/2015">

<IdValue>JNJNJP00040440</IdValue>

<Status>Submitted</Status>

...

As the FST is basically a 'black box',...

Looks good to me.

Have you tried adding a breakpoint on the File System Task & verifying that all of the various variables are looking OK?

Is there anything 'unusual' about the...

sql.queries (12/14/2015)

---

Thanks.

Would the 'group by' solution, grouping all results from MyTable2, be a better solution than the correlated query?

It is not an OLTP database and the query is executed frequently,...

You could try left-joining to a CTE:

with t2Counts as (select t2.col1, ctcol1 = count(t2.*) from MyTable2 t2 group by t2.col1)

select

col1,

col2,

col3_no = IsNull(t2Counts.ctcol1,0),

col4_no =...

deleted!

msbi.ravindhar (12/13/2015)

---

I have been asked to do a task which is import data from one table and loop through that data with another table and fetch the matching result using...

Not long before the weekend!

As far as I know, there is no standard SSIS task which does this. Are you using third-party tools?

You should be able...

If you are open to using SSIS, most definitely.

Except for one thing. If you have an ISO language table, there is no need to invent an int PK - use the ISO code instead.

Yes, exactly right.