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

Try this

if object_id('tempdb..#data', 'U') is not null

drop table #data;

create table #data

(

EQID int

,Revis int

,Filename varchar(20)

,JobCode int

,JobQual...

Do you get any error or warning messages?

komal145 (11/4/2015)

---

hi,

I have a script task that reads the variable named"result" ( the stored procedure is ran in execute sql task and stores the result in this variable) and...