SSIS – Accessing variables from script components

 In SSIS there are are two different types of script components.  The Control Flow script, and the Data Flow script.  These 2 use different ways of accessing package variables, which was a bit confusing the first time I used teh Data Flow script component.

In the Control Flow script component you access package variables in a similar way to how DTS used to do it.

Dts.Variables("User::FromDate").Value.ToString

 However, trying this in the DataFlow script component only cause some compilation errors and nothing more.

After doing some searching, I eventually found the simple solution that was staring me in the face all along, I just never tried it.

Me.ReadOnlyVariables("User::FileName").Value.ToString()

In both cases you still have to tell the component which variables you're passing in on the property page.
 

Job description of a parent

 

PARENT

 

 Job Description

This is hysterical. If it had been presented this way,
I don't believe any of us would have done it!!!!

POSITION :
Mom, Mommy, Mama, Ma
Dad, Daddy, Dada, Pa, Pop

JOB DESCRIPTION :

Long term, team players needed, for challenging
permanent work in an
often chaotic environment.
Candidates must possess excellent communication
and organizational skills and be willing to work
variable hours, which will include evenings and weekend s
and frequen t 24 hour shifts on call.
Some overnight travel required, including trips to
primitive camping sites on rainy weekends and

endless sports tournaments in far away cities!
Travel expenses not reimbursed.
Extensive courier duties also required.

RESPONSIBILITIES :

The rest of your life.
Must be willing to be hated, at least temporarily,
until someone needs $5.
Must be willing to bite tongue repeatedly.
Also, must possess the physical stamina of a
pack mule
and be able to go from zero to 60 mph in three seconds flat
in case, this time, the screams from
the backyard are not someone just crying wolf.
Must be willing to face stimulating technical challenges,
such as small gadget repair, mysteriou sly sluggish toilets
and stuck zippers.
Must screen phone calls, maintain calendars and
coordinate production of multiple homework projects.
Must have ability to plan and organize social gatherings
for clients of all ages and mental outlooks.
Must be willing to be indispensable one minute,
an embarrassment the next.
Must handle assembly and product safety testing of a
half million cheap, plastic toys, and battery operated devices.
Must always hope for the best but be prepared for the worst.
Must assume final, complete accountability for
the quality of the end product.
Responsibilities also include floor maintenance and
janitorial work throughout the facility.

POSSIBILITY FOR ADVANCEMENT & PROMOTION :

None.
Your job is to remain in the same position for years, without complaining,constantly retraining and updating your skills,
so that those in your charge can ultimately surpass you

PREVIOUS EXPERIENCE :

None required unfortunately.
On-the-job training offered on a continually exhausting basis.

WAGES AND COMPENSATION :

Get this!   You pay them!
Offering frequent raises and bonuses.
A balloon payment is due when they turn 18 because
of the assumption that college will help them
become financially independent.
When you die, you give them whatever is left.
The oddest thing about this reverse-salary scheme is that
you actually enjoy it and wish you could only do more.

BENEFITS :

While no health or dental insurance, no pension,
no tuition reimbursement, no paid holidays and
no stock options are offered;
this job supplies limitless opportunities for personal growth, unconditionallove,
and free hugs and kisses for life if you play your cards right.



Forward this on to all the
PARENTS youknow, in appreciation for everything they do on a daily basis,
letting them know they are appreciated
for the fabulous job they do…
or f orward with love
to anyone thinking of applying for the job.

 

** AND A FOOTNOTE **

 

THERE IS NO RETIREMENT — EVER!!! **

If you are fortunate enough you willbecome grandparents

AND YOU MAY HAVE TO RAISE THEM TOO!!!

 

This is getting ridiculous

Our government's inability to do anything right is seriously costing the tax payer!

Jackie Selebi's case has been postponed to April next year, because the state is not ready.  With his contract just being renewed, it means we continue paying him a fat salary while he's on permanent leave.  That's utter BS.

Robert McBride's court costs were funded by the municipality, his employer.  Show me one company in this country who will fund the employee's court case against them…

There needs to be drastic policy changes in this country, and soon.  If someone is suspended on suspicion of fraud, their salary needs to be suspended as well.  Should that person then be proven innocent, they are entitled to a full back payment of their salary, but should they be guilty, they're entitled to nothing.  If a person goes to court for suspicion, he should fund his own defence, once again, when proven innocent, I don't mind if they then refund the full cost.

There are too many people, most of them appointed by the current administration, that are suspended on full salary for fraud and corruption charges.  I don't see why we should be funding their lavish lifestyles while there's a cloud of suspicion over them.

For that matter, I think anybody in public office should not be getting a salary while in office.  Their basic needs should be paid for by the state, and based on performance, they get a lump sum at the end, with the public having some say in the matter.  And that could even be tax free in my mind, if the person performed their duties well, in the public's interest, they deserve that.

If we had this payment scheme in place for the current administration, I don't believe many of them would have walked away with a payment at the end of their term.

In the business world if you're not happy with a supplier's service, you withhold payment until the service improves, or you find a better supplier.  Unfortunately in this case my payment for services is in the form of taxes, which I have no choice of withholding, my employer pays it to the collector.  So that leaves me with the option of finding a new supplier, in this case another government, in another country…
 

The final word on nutrition

After anexhaustive review of the research literature, here's the final word onnutrition and health.:

1.Japanese eat very little fat and suffer fewer heart attacks than us.
2.Mexicans eat a lot of fat and suffer fewer heart attacks than us.
3. Chinesedrink very little red wine and suffer fewer heart attacks than us.
4.Italians drink excessive amounts of red wine and suffer fewer heart attacksthan us.
5. Germansdrink beer and eat lots of sausages and fats and suffer fewer heart attacksthan us.
6. TheFrench eat foie-gras, full fat cheese and drink red wine and suffer fewer heartattacks than us. 

CONCLUSION:Eat and drink what you like. Speaking English is apparently what kills you.