Thank you for your suggestions. I will look into them.

I finally had a google-search that didn't show me examples how to add variables to a skript-task

http://www.pawlowski.cz/2012/06/manipulating-ssis-packages-powershell/

He seems to use powershell...

Did you look into this Topic?

http://www.sqlservercentral.com/Forums/FindPost1150136.aspx

another link in this topic is to a how to

http://www.sqlcoffee.com/Tips0013.htm

They are using ODBC-Connection to the DB2-DB.

Be advised that on a 64-bit...

Do you connect to a DB2 Database?

Port 1433 is usually MSSQL

In the Linked-Server Wizard you should select MS OLE...

can you post some details of your link server config?

Hi Andre,

SSIS is checking the meta data of you columns.

You would do an implicit conversion from INT to Numeric.

This could lead to dataloss that cannot be controlled by SSIS.

That...

If I do Full Backup I come back to my initial idea with the partitioned views to carve out the old data from my dayly backup.

Hi Grant,

I looked into the filegroup backup and found this limitation

Under the simple recovery model, read/write files must all be backed up together. This helps make sure that the database...

Hi Adi,

thanks for your input.

I would use the view for read only. Writing is done directly into the tables via the ETL that can decided which table is fitting for...

Am I suggesting something totally absurd?

Yes, in my test the file was on the same system. That's how it should stay.

However if the network-path does not come with disadvantages then I can use it...

So after two weeks of monitoring I can tell you, that RCSI had no significant performance impact on my system.

I even had the situation that the job importing was overlapping...

I am running a classic DWH so yes, I am just modifying the tables once a day, reading multiple times.

I will see how this setting is changing my regular imports...

Thank you for your advice.

So I guess if I am willing to "buy" all the disadvantages when enabling snapshot, I can just as well use RCSI so I do not...

Thx for the clarification Gila,

After that article I get what is really happening with snapshot-isolation.

I guess the only disadvantage is performance if you have a long statement on a heavilly...

=IIf(

IsNothing(Sum(Fields!divisor.Value)) Or Sum(Fields!divisor.Value) = 0.0,

"",

Sum(Fields!value.Value) / IIf(IsNothing(Sum(Fields!divisor.Value)) Or Sum(Fields!divisor.Value) = 0.0, 1, Sum(Fields!divisor.Value))

)

I just wanted to add a fact:

If you have a division, that...