you can check the following links

[SSIS] OnPipelineRowsSent event

SSIS Logging Data Model[/url]

While reading your question, i noticed that you might have done a typeo in your Grace Marks required columns

For Scenario 1: 001 11 40 38 (2)

but for...

When you closest, What exactly you mean by that ?

In your sample output you have shown 01-02-2016 and your input date is 01-05-2016. That means as per your requirement...

This is not a good practice at all. I assume in your c# code, rows getting inserted directly, instead of using a Stored Procedures. Usually these kind of things happens...

I have seen your logic changing the value based upon a flag that is fine nothing wrong in it.

I have also attached a sample package to show you can execute...

xanthos (6/16/2016)

---

Thanks.

I need to have the default set as soon as I open the package otherwise my data flows that use the connection come up with warnings.

The variable is used...

Your problem is that you need to have a default value for your variable. Right?

If the answer is Yes then you can achieve it very easily. doing the following:

1. open...

after reading the question subject. My assumption is he haven't taken any...

Let me rephrase, If you have used Expression on any variable, if you try to change the value of that variable even on design time, the...

There is nothing wrong SSIS doing, Following is the understanding.

If you are Setting a variable with expression. then if you want to change the value of that variable you need...

Quick suggestion: you can add 6 days and you will get the end date as well.

SELECT [date] as StartDate, DATEADD(dd,6,[date]) as EndDate

FROM CTE_DatesTable

OPTION (MAXRECURSION 0);

good question. Thanks for sharing

it would be very helpful if you could provide some sample data and your desired output.

I just gave the answer then realize STUFF function was not even used in a code. I would call this an abstract level question 😛

Nice question.