I'm not sure I fully understand your question, but here's nonetheless a first attempt at answering it.

You are right that you will need an execute package task to run the...

Read this thread.

Check BOL.

Try this: The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released[/url].

The result of

SELECT CAST(1.67574 AS DECIMAL(38,10)) / CAST(10000 AS DECIMAL(38,10)) conv_factor

has datatype decimal(38,6). From BOL: In Transact-SQL statements, a constant with a decimal point is automatically converted into a...

Try this: SQL Server 2008 Build List[/url].

Post create table statements, insert statements for sample data and an example of desired output and we'll help you to create the statement.

Use PIVOT - see BOL.

What is the location where your packages are stored: SQL Server or File system?

If it is File system, then it is normal that the PackageName is not filled in. The...

Check this link.

I agree. The article I referred to contains plenty of examples at the end about when (not) to use dynamic sql.

I doubt the RowSampling Transformation is the culprit. You'll have to give us some more information.

What is your source DB, what provider are you using, what does the query look...

Jeffrey is right about the clustered index not having to be unique, but when it comes to indexed views, BOL says:

The first index created on a view must be a...

Here's three I like:

Professional Microsoft SQL Server 2008 Administration

Microsoft SQL Server 2008 Management and Administration

Microsoft SQL Server 2008 Internals

and this book deservers a special recommendation

SQL Server MVP Deep Dives

This is how I do this:

DECLARE @sp_executesql NVARCHAR(150) = QUOTENAME('name of your database goes here') + '.sys.sp_executesql' ;

I put the statement to create the view in @sql of type NVARCHAR(MAX).

To...