You got at least one response 🙂

What do you mean with "not correct"?

Why don't you use (n)varchar(max) for the column?

Another option is to use the filestream feature.

Depends on the transactions you are doing and on the recovery model.

What is the recovery model?

Seems like an issue loading the assemblies needed for VB.

Did you try a repair of BIDS? (bit of a long shot, I know)

I think this is the universe telling you...

Very important thing to know: the RentalFeeAmount, how is this calculated? How is this used?

If it is a normal measure - additive and all that - option 1 is flat...

+1 for surrogate keys into the fact table.

Very useful if you update facts.

Even if you only insert rows, it can be useful to have a surrogate key, for example to...

I...

+1 on this one

Unfortunately I can't see the screenshots (probably blocked by firewall), but I have installed multiple versions of SQL Server side by side without an issue.

It should be no problem to...

You can start the executions of packages also through a stored procedure. You can dump the value of the SSIS catalog executionID to a parameter in the package and...

twin.devil (4/24/2014)

Just a thought really, In addition to Koen respone if your source is sql server, you can perform this convert on database...

It seems your caps lock is broken.

This thread lists some solutions to find the object that is referencing your function:

http://stackoverflow.com/questions/3681291/find-all-references-to-an-object-in-an-sql-server-database

Find it and alter the code so that it stops referencing...

What exactly do you want to log withing the stored procedures?

Maybe you can execute them with Execute SQL Tasks?

Remember we cannot see what you can see/think.

It is not entirely clear what you want to achieve.

What do you mean with calculated fields? What is your source?

SSIS expects a specific format.

YYYY-MM-DD HH:MIS:SS

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/65e1c7d2-5410-48d9-9bb1-964ea124d0d1/how-to-convert-string-data-type-to-datetime-in-derived-column-control-in-ssis-package?forum=sqlintegrationservices