Guys,

Isn't using Configuration Type "SQL Server"

any better than XML?

It's so easy to query,update, delete,insert

Configuration values with SQL Server.

The trouble happens only when you

rename the existing SSIS Task which Properties are...

ALZDBA,

I think when you choose "Include Client Statistics"

in QA it does the same thing as

But the important question is:

How to read the results?

What...

Looks like ALZDBA version

is the best when you compare the speed:

Total execution time250

Wait time on server replies0

My version:

Total execution time 343

Wait time on...

Guys,

I found what the problem was.

The query was running too long because

a heavy insert was being done in REVENUE_FACT at that moment from some SSIS package.

I switched to Production server...

I installed Integrated Services on my local pc and the error is gone now.

But I still don't understand from this example

at http://www.sqlis.com/27.aspx

this:

How come that Script Task has

but instead...

I tried this example:

http://www.sqlis.com/27.aspx

and got an error:

SSIS package "Caller.dtsx" starting.

Executing ExecutePackageTask: C:\SSIS\Master\Master\Called.dtsx

Information: 0x40016042 at Called: The package is attempting to configure from the parent variable "MyExecutePackageVariable".

Information: 0x40016042 at...

Venkat,

I went to

http://www.sqlis.com/27.aspx

and tried to follow their sample but it did not work for me.

They say you can specify the scope as -call the called package-

but Scope field...

Alvin,

I thought about calling the same INITIALIZATION

step in all packages. But in my case I would need to have

a sequence container with 5-6

Execute SQL tasks that populate

variables. That seems to...

have a master package which holds the values of connections and values

Have all other packages as child packages with the same name

the child package variable can be configured from master...

Here is my solution to the problem.

I create varCounter variable equals 1.

I have "Foreach Loop Container"

and map Result Set to "var_IterationValue" variable.

Inside "Foreach Loop" I have Script Task:

Public Class ScriptMain

...

Thanks SSC Rookie,

http://www.codeproject.com/KB/database/foreachadossis.aspx

is a very good example.

It gives you an idea how "Foreach Loop" task can be used.

But I still don't know how to loop through the result...

I thought instead of 4 "Execute SQL" tasks

I can just have 2:

"Execute SQL" and 1 Loop

I need to learn how to work with Loop task.

I know I can call another package but

the external package 2 knows nothing about my variables in package 1.

So how do I return values from package 2?

My question is:

"I...

Frank,

You wrote

But CIS_ACCOUNT doesn't have CUST_AGRMT_NUM column ?..

I found the answer to one of my questions:

To update to NULL if empty, you need to use Expression in Derived Coluns:

Jesus!

What takes seconds...