barry.andreasen (12/16/2015)

---

Sorry,...

g.britton (12/16/2015)

---

Alvin Ramard (12/15/2015)

---

Phil Parkin (12/15/2015)

---

g.britton (12/15/2015)

---

Of course. however...

barry.andreasen (12/16/2015)

---

I am coming up to speed on SSIS packages for use in a product solution that I am involved with. We have defined a number of packages that...

I...

Nothing is wrong.

You are partitioning by row number, which is unique in the source data - making the partition redundant. If you sum a column which contains a NULL and...

Eshika (12/15/2015)

---

Thank you for your response,

I have a package and it is one of the 3 deployed packages in a folder. Do I need other two packages as well to...

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!