Hi Steve,

It's not feasible to run the package in both SSIS packages, it'll slow down the performance. It takes around 10-30mins to finish the package(for around 8k records). Is...

Hi Lutz,

View table seems like not practical in my case.

In my stored proc, it used to calculate the value

1. by its own table's columns

2. update the cost column. Scenario: if...

Thanks for sharing...

It's manufacturing industry, probably will goes up to millions or even billions.

I think trigger will cause the worst performance compared to recalculate both sides. But, would like...

Hi,

Yes, i need to store it in both tables.

I may test it out by include the stored procedure into these 2 SSIS projects. Yet, is there any other...

Okay, let's we talk about the tables now.

1. 2 tables : one is Sales table, the other one is Production Cost table

The relationship between these 2 tables are:

From...

Hi,

Sorry for confusing.

Okay, I mean that the column fields in Sales is required some value from Production table to do the calculation. And now, the calculation is processed...

Hi all,

thank you for your advise!

I'm able to solve it out by using Import & Export wizard ,and with the variable to set the DateTime as part of...

Hi RB,

I'm able to create variable with the expression you mentioned. Yet, facing error when run the package, do you have any idea on this? Please advise.

Thanks!

TITLE:...

Hi RB,

Thanks for your response! Yet, would need your guide on this.

From the Import & Export wizard, the excel connection will be in Data Flow,right?

In the excel...

Hi Steveb,

It's not able to over-write the existing file when run the package for second time. And, is there a way to rename to file with date-timestamp?

Please advise.

Thank you!