Does anybody know what this means? I have a SQL source (OLEDB) going to a script transformation as a destination:
[DTS.Pipeline] Warning: Component "Add Schemas" (32) has been removed from the Data Flow task because its output is not used and its inputs have no side effects. If the component is required, then the HasSideEffects property on at least one of its inputs should be set to true, or its output should be connected to something.
Add Schemas is the script transformation destination. I can't find a HasSideEffects property, and have no idea why this would be a problem.ETL(extraction transformation and loading) related, try this link for more info. Hope this helps.
http://www.sqlis.com/
No comments:
Post a Comment