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...

system243trd (11/9/2015)

---

I have created a package that will insert new rows into destination1 if the AnID does not exist in Source1. This uses a data flow task which contains...

aikman2222 (11/10/2015)

---

Hi Phil,

I have two columns in my source data, Created and Change that I want to check against.

I have succed it with a Stored Procedure:

where

cast(o.created as date) >=...

aikman2222 (11/10/2015)

---

Hi,

Am a newbie in SSIS and need help with following:

Have a load and the last step in the Control Flow I update LastImportDate in a Table

update ParamSettings set

value...

SQL.AP (11/9/2015)

---

I am planning to re-design one of my SSIS processes for performance upgrade.

One package is calling various child packages. I want to remove any physical dependencies and execute...

I just created a very simple script component source.

public override void PreExecute()

{

base.PreExecute();

...

SimonH (11/6/2015)

---

Thanks Phil.

That's the plan,

However

If a company has a warehouse say in Southampton, and they were sending

packages from Manchester say every day/every hour.

The Manchester and Southampton addresses are going...

SimonH (11/6/2015)

---

Hi,

I Have a table which I've de-normalized for my DimDestinationLocations. see Below

How ever due to the amount of potential repeating rows I'm tempted to

load out the distinct address's into...

Nice article, Andy.

I assume that you will be adding some parameters to your 'variables and parameters' package in a later article?

Building variable expressions which use the values of parameters passed...

I appreciate the fact that you took the time to post back with your success story 🙂

And it's great to hear that you were able to build a working solution;...

ArcticEd32 (11/5/2015)

---

Thanks to all for the replies

kaj (11/5/2015)

---

The only thing I can think of that would cause this is if you have an unordered table, where n in one of...

JustMarie (11/5/2015)

---

One company I was at went to project level deployment in 2012. While the use of variables for data connections and parameters and such were really helpful there...

kaj (11/5/2015)

---

The only thing I can think of that would cause this is if you have an unordered table, where n in one of the first rows is too big...