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

pshrvankumar (11/5/2015)

---

Thanks Anthony,Problem was partial solved but I have below table. Please help me with the below puzzle. My table CSAT has below columns.

TRANIDREVISION FileName JobCode...

Welcome!

Based on what you have told us, the answer is yes.

But we cannot tell you exactly how without knowing how the database is structured.

Details of guests, periods of stay and...

Ian C0ckcroft (11/5/2015)

---

Hi guys,

when opening a package i get the error:

Error 5 Error loading 02 04 XLS_GL_Load.dtsx: The connection "NHDQCOG01" is not found. This...