Hopefully your framework allows you to set the max concurrent number of executing packages per job.

I'd suggest playing with that number a bit. Start on the low side and gradually...

That very process was recently described in this thread.

Also, literal dates are best written in 'YYYYMMDD' format, eg, '20791201', to avoid any possible DMY, MDY confusion.

ChrisM@Work (11/12/2015)

---

Ed Wagner (11/12/2015)

---

Sean Lange (11/12/2015)

---

Jack Corbett (11/12/2015)

---

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function,...

nexus2vijay (11/12/2015)

---

Thanks for the revert Bossman.

I'm not a Techie infact. I'm from Teaching field and new to IT industry and getting to know the DB.

If you could help me out...

nexus2vijay (11/12/2015)

---

Hi,

From the attached 4 Tables Schema Diagram

Will the below query Reduce me the ListPrice by 20% if i didn't receive the order for the last 2 years ? Jammed...

OK, version 2.

declare @x varchar(500) = '&StartRow=1&EndRow=1000&LoginID=40&ProjectAssessment=16&ShowColumns=Asset&ShowColumns=Category&ShowColumns=IOL&ShowColumns=Vulnerability%20Exposed&AssetDescription=&';

select @x

,left(replace(right(@x, len(@x) - charindex('&ShowColumns=', @x) - 12), '&ShowColumns=', ','),charindex('&',replace(right(@x, len(@x) - charindex('&ShowColumns=', @x) - 12), '&ShowColumns=', ','))-1)

robert.wiglesworth (11/12/2015)

---

I am working with a table that does not work for me. I want to create a new table with a different structure. Here is an example of how...

You could try this. Might not work in all circumstances though:

declare @x varchar(500) = '&StartRow=1&EndRow=1000&LoginID=40&ProjectAssessment=16&ShowColumns=Asset&ShowColumns=Category&ShowColumns=IOL&ShowColumns=Vulnerability%20Exposed&AssetDescription=&';

select @x

,replace(replace(right(@x, len(@x) - charindex('&ShowColumns=', @x) - 12),...

nexus2vijay (11/12/2015)

---

Hi Friends,

Attached the Schema of a DB with 4 Tables.

1.Query to get the customers with the total sales, who placed an order last year but not this year.

•Column...

If the solution you are considering is as simple as you suggest, there is little point in staging anything. Instead

1) Dataflow task with source Server1.Source1

2) Data source to fully-cached Lookup...

Sure.

Let's assume your source proc is called dbo.proc and it has a parameter called @MaxDate.

Point your OLEDB data source at your source database and in SQL commend text, enter:

exec dbo.Proc...

Assuming that they are both still changing and that these changes need to be reflected in the reporting server, I would keep them separate.

Consider using replication to keep the DBs...

A bit off topic, but why are you casting the dates as varchars?

SQL.AP (11/10/2015)

---

There are various interfaces which are independent, so they would be executed in parallel. However, we've a changing req. and in future there would be more interfaces coming and...