SteffSullivan (1) [Avatar] Offline
#1
Following the instructions from the book, I have generated an InputXML variable that evaluates but does cause the task to dynamically profile.

NB. I also had issues with tables with XML in which would break the task forever. Excluding these tables from the set to operate on and recreating the task have prevented a repeat occurence.

My XML expression looks like:
"<?xml version="1.0"?>
<DataProfile xmlnssmiliesi="http://www.w3.org/2001/XMLSchema-instance" xmlnssmiliesd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/sqlserver/2008/DataDebugger/">
<DataSources>
<DtsDataSource ID="{C026647F-A104-44BA-83A4-DEFF6CE3DD3C}" Name="Net Adventure Works">
<DtsConnectionManagerID>Net Adventure Works</DtsConnectionManagerID>
</DtsDataSource>
</DataSources>
<DataProfileInput>
<ProfileMode>Exact</ProfileMode>
<Timeout>0</Timeout>
<Requests>
<ColumnNullRatioProfileRequest ID="NullRatioReq">
<DataSourceID>{C026647F-A104-44BA-83A4-DEFF6CE3DD3C}</DataSourceID>
<Table Schema="" + @[User::SchemaName] +"" Table="" +@[User::TableName] + "" />
<Column IsWildCard="true" />
</ColumnNullRatioProfileRequest>
<ColumnStatisticsProfileRequest ID="StatisticsReq">
<DataSourceID>{C026647F-A104-44BA-83A4-DEFF6CE3DD3C}</DataSourceID>
<Table Schema="" + @[User::SchemaName] +"" Table="" +@[User::TableName] + "" />
<Column IsWildCard="true" />
</ColumnStatisticsProfileRequest>
<ColumnLengthDistributionProfileRequest ID="LengthDistReq">
<DataSourceID>{C026647F-A104-44BA-83A4-DEFF6CE3DD3C}</DataSourceID>
<Table Schema="" + @[User::SchemaName] +"" Table="" +@[User::TableName] + "" />
<Column IsWildCard="true" />
<IgnoreLeadingSpace>false</IgnoreLeadingSpace>
<IgnoreTrailingSpace>true</IgnoreTrailingSpace>
</ColumnLengthDistributionProfileRequest>
<ColumnValueDistributionProfileRequest ID="ValueDistReq">
<DataSourceID>{C026647F-A104-44BA-83A4-DEFF6CE3DD3C}</DataSourceID>
<Table Schema="" + @[User::SchemaName] +"" Table="" +@[User::TableName] + "" />
<Column IsWildCard="true" />
<Option>FrequentValues</Option>
<FrequentValueThreshold>0.001</FrequentValueThreshold>
</ColumnValueDistributionProfileRequest>
</Requests>
</DataProfileInput>"

I'm getting the error message:
Error: The result of the expression "@[User::InputXML]" on property "ProfileInputXml" cannot be written to the property. The expression was evaluated, but cannot be set on the property.

My Output despite this error looks like:
<?xml version="1.0"?>
<DataProfile xmlnssmiliesi="http://www.w3.org/2001/XMLSchema-instance" xmlnssmiliesd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/sqlserver/2008/DataDebugger/">
<DataSources>
<DtsDataSource ID="{964A99C3-71F5-4E24-B064-539519A4D6C5}" Name="DynamicFixedSQLServerProfiler.xml">
<DtsConnectionManagerID>DynamicFixedSQLServerProfiler.xml</DtsConnectionManagerID>
</DtsDataSource>
<DtsDataSource ID="{C026647F-A104-44BA-83A4-DEFF6CE3DD3C}" Name="Net Adventure Works">
<DtsConnectionManagerID>Net Adventure Works</DtsConnectionManagerID>
</DtsDataSource>
<DtsDataSource ID="{8DD0A43D-8DA1-4193-A2C6-D9245E63A041}" Name="OLEDB Adventure Works">
<DtsConnectionManagerID>OLEDB Adventure Works</DtsConnectionManagerID>
</DtsDataSource>
<DtsDataSource ID="{6AC0EA9F-C6E2-45C8-8E09-5E64BD20F012}" Name="OLEDB Repository">
<DtsConnectionManagerID>OLEDB Repository</DtsConnectionManagerID>
</DtsDataSource>
</DataSources>
<DataProfileInput>
<ProfileMode>Exact</ProfileMode>
<Timeout>0</Timeout>
<Requests />
</DataProfileInput>
<DataProfileOutput>
<Profiles />
</DataProfileOutput>
</DataProfile>

Is anyone able to see where I'm going wrong?