 | |
SSIS An error occurred while attempting to perform a type cast
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SSIS An error occurred while attempting to perform a type cast -
05-24-2006
, 04:49 AM
#2
| |||
| |||
|
|
Hi, I'm using SSIS for the first time but I'm no novice about unicode and non-unicode. This time I really don't see why SSIS is bothering me with a DT_STR to DT_WSTR conversion problems. I simply need to insert a new column with Derived Column of datatype nvarchar(2000) based on 3 concatenated varchar columns. (For now I just don't concatenate because the problem is the implicit or explicit conversion of DT_STR to DT_WSTR). In the expression I put the column name of the varchar(...) based column, the datatype will be unicode DT_WSTR. When I run the package I will get the error: Error: 0xC0049066 at DF_fill, Derived Column [4776]: Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion on the input column. Error: 0xC0209029 at DF_fill, Derived Column [4776]: The "component "Derived Column" (4776)" failed because error code 0xC0049066 occurred, and the error row disposition on "output column "LogText" (4825)" specifies failure on error. An error occurred on the specified object of the specified component. Error: 0xC0047022 at DF_fill, DTS.Pipeline: The ProcessInput method on component "Derived Column" (4776) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. And when I explicit do the conversion: (DT_WSTR,2000)activiteitcode I will get the error: Error: 0xC0049064 at DF_fill, Derived Column [4776]: An error occurred while attempting to perform a type cast. Error: 0xC0209029 at DF_fill, Derived Column [4776]: The "component "Derived Column" (4776)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "LogText" (4825)" specifies failure on error. An error occurred on the specified object of the specified component. Error: 0xC0047022 at DF_fill, DTS.Pipeline: The ProcessInput method on component "Derived Column" (4776) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. Please help me. I tried mixing the columns of the sources and destinations and checked the metadatamappings... Kind regards, Bugs Bunny |
#3
| |||
| |||
|
|
Hello Bugs, OK So it i read the post right we need to take 3 * varchar columns and make them into 1 * nvarchar as we want to do that using the derived column transform. First Q though. Can you do this in the source? If you can I would OK So let's take a Look CREATE TABLE T (c1 varchar(10), c2 varchar(10), c3 varchar(10)) GO INSERT T VALUES('SSIS','ROCKS','ETL') Here is the derived column expression I used (DT_WSTR, 10) [c1] + (DT_WSTR, 10) [c2] + (DT_WSTR, 10) [c3] It works as expected. What are the contents of DF_Fill? Maybe the issue is in the data which my example will not expose? Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hi, I'm using SSIS for the first time but I'm no novice about unicode and non-unicode. This time I really don't see why SSIS is bothering me with a DT_STR to DT_WSTR conversion problems. I simply need to insert a new column with Derived Column of datatype nvarchar(2000) based on 3 concatenated varchar columns. (For now I just don't concatenate because the problem is the implicit or explicit conversion of DT_STR to DT_WSTR). In the expression I put the column name of the varchar(...) based column, the datatype will be unicode DT_WSTR. When I run the package I will get the error: Error: 0xC0049066 at DF_fill, Derived Column [4776]: Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion on the input column. Error: 0xC0209029 at DF_fill, Derived Column [4776]: The "component "Derived Column" (4776)" failed because error code 0xC0049066 occurred, and the error row disposition on "output column "LogText" (4825)" specifies failure on error. An error occurred on the specified object of the specified component. Error: 0xC0047022 at DF_fill, DTS.Pipeline: The ProcessInput method on component "Derived Column" (4776) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. And when I explicit do the conversion: (DT_WSTR,2000)activiteitcode I will get the error: Error: 0xC0049064 at DF_fill, Derived Column [4776]: An error occurred while attempting to perform a type cast. Error: 0xC0209029 at DF_fill, Derived Column [4776]: The "component "Derived Column" (4776)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "LogText" (4825)" specifies failure on error. An error occurred on the specified object of the specified component. Error: 0xC0047022 at DF_fill, DTS.Pipeline: The ProcessInput method on component "Derived Column" (4776) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. Please help me. I tried mixing the columns of the sources and destinations and checked the metadatamappings... Kind regards, Bugs Bunny |
#4
| |||
| |||
|
|
Hi Allan, My source is an OLE DB Destination (where data is copied from a flat file). The record is validated and must be concatenated for logging. This is why I want to have a new (derived) column . So my concatenation cannot be done within the source. I understand the conversion with the cast mechanism but it gives the error I wrote in my previuos mail which I cannot explain. Perhaps it's the combination with the OLE DB destination that I have as my input. Maybe you can tell me more about that specific combination. Kind regards, Bugs Bunny "Allan Mitchell" wrote: Hello Bugs, OK So it i read the post right we need to take 3 * varchar columns and make them into 1 * nvarchar as we want to do that using the derived column transform. First Q though. Can you do this in the source? If you can I would OK So let's take a Look CREATE TABLE T (c1 varchar(10), c2 varchar(10), c3 varchar(10)) GO INSERT T VALUES('SSIS','ROCKS','ETL') Here is the derived column expression I used (DT_WSTR, 10) [c1] + (DT_WSTR, 10) [c2] + (DT_WSTR, 10) [c3] It works as expected. What are the contents of DF_Fill? Maybe the issue is in the data which my example will not expose? Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hi, I'm using SSIS for the first time but I'm no novice about unicode and non-unicode. This time I really don't see why SSIS is bothering me with a DT_STR to DT_WSTR conversion problems. I simply need to insert a new column with Derived Column of datatype nvarchar(2000) based on 3 concatenated varchar columns. (For now I just don't concatenate because the problem is the implicit or explicit conversion of DT_STR to DT_WSTR). In the expression I put the column name of the varchar(...) based column, the datatype will be unicode DT_WSTR. When I run the package I will get the error: Error: 0xC0049066 at DF_fill, Derived Column [4776]: Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion on the input column. Error: 0xC0209029 at DF_fill, Derived Column [4776]: The "component "Derived Column" (4776)" failed because error code 0xC0049066 occurred, and the error row disposition on "output column "LogText" (4825)" specifies failure on error. An error occurred on the specified object of the specified component. Error: 0xC0047022 at DF_fill, DTS.Pipeline: The ProcessInput method on component "Derived Column" (4776) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. And when I explicit do the conversion: (DT_WSTR,2000)activiteitcode I will get the error: Error: 0xC0049064 at DF_fill, Derived Column [4776]: An error occurred while attempting to perform a type cast. Error: 0xC0209029 at DF_fill, Derived Column [4776]: The "component "Derived Column" (4776)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "LogText" (4825)" specifies failure on error. An error occurred on the specified object of the specified component. Error: 0xC0047022 at DF_fill, DTS.Pipeline: The ProcessInput method on component "Derived Column" (4776) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. Please help me. I tried mixing the columns of the sources and destinations and checked the metadatamappings... Kind regards, Bugs Bunny |
#5
| |||
| |||
|
#6
| |||
| |||
|
#7
| |||
| |||
|
#8
| |||
| |||
|
| Build |
DefaultNamespace =
"ScriptComponent_63a4a18c45ba4682b6bb6fd6b37e86ce"
OptionCompare = "0"
OptionExplicit = "1"
OptionStrict = "1"
ProjectName =
"ScriptComponent_63a4a18c45ba4682b6bb6fd6b37e86ce"
ReferencePath =
"C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer. TxScript\9.0.242.0__89845dcd8080cc91\;C:\WINDOWS\a ssembly\GAC_MSIL\Microsoft.SqlServer.PipelineHost\ 9.0.242.0__89845dcd8080cc91\;C:\WINDOWS\assembly\G AC_MSIL\Microsoft.SqlServer.DTSPipelineWrap\9.0.24 2.0__89845dcd8080cc91\;C:\WINDOWS\assembly\GAC_MSI L\Microsoft.SqlServer.DTSRuntimeWrap\9.0.242.0__89 845dcd8080cc91\"
TreatWarningsAsErrors = "false"
WarningLevel = "1"
RootNamespace =
"ScriptComponent_63a4a18c45ba4682b6bb6fd6b37e86ce"
Quote:
| Config |
DefineConstants = ""
DefineDebug = "true"
DefineTrace = "true"
DebugSymbols = "true"
RemoveIntegerChecks = "false"
/>
</Settings>
<References>
<Reference
Name = "System"
AssemblyName = "System"
/>
<Reference
Name = "System.Data"
AssemblyName = "System.Data"
/>
<Reference
Name = "Microsoft.SqlServer.TxScript"
AssemblyName = "Microsoft.SqlServer.TxScript"
/>
<Reference
Name = "Microsoft.SqlServer.PipelineHost"
AssemblyName = "Microsoft.SqlServer.PipelineHost"
/>
<Reference
Name = "Microsoft.SqlServer.DTSPipelineWrap"
AssemblyName = "Microsoft.SqlServer.DTSPipelineWrap"
/>
<Reference
Name = "Microsoft.SqlServer.DTSRuntimeWrap"
AssemblyName = "Microsoft.SqlServer.DTSRuntimeWrap"
/>
</References>
<Imports>
<Import Namespace = "Microsoft.VisualBasic" />
</Imports>
</Build>
<Files>
<Include>
<File
RelPath = "ScriptMain"
BuildAction = "Compile"
ItemType = "2"
/>
<File
RelPath = "BufferWrapper"
BuildAction = "Compile"
ItemType = "2"
/>
<File
RelPath = "ComponentWrapper"
BuildAction = "Compile"
ItemType = "2"
/>
</Include>
</Files>
<Folders>
<Include/>
</Folders>
</VisualBasic>
</VisualStudioProject>
#9
| |||
| |||
|
#10
| |||
| |||
|
|
Hi Allan, No typo. I think it's time to show my package. I will dump this in 3 replies because it's too long. Have fun with it ;-) I deleted some array systemstrings which were very very large. My SSIS by the way shows me a messagebox when I open my projec...is this the problem perhaps I will try with a modified dtsx-file. I hope this dump works for you. Further on I dumped my t.txt file too. ?xml version="1.0"?><DTS:Executable xmlns  TS="www.microsoft.com/SqlServer/Dts"DTS:ExecutableType="MSDTS.Package.1"><DTS:Property DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property DTS:Name="VersionComments"></DTS:Property><DTS:Property DTS:Name="CreatorName">xxx</DTS:Property><DTS:Property DTS:Name="CreatorComputerName">U5</DTS:Property><DTS:Property DTS:Name="CreationDate" DTS ataType="7">5/19/2006 12:53:24PM</DTS:Property><DTS:Property DTS:Name="PackageType">5</DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</DTS:Property><DTS:Property DTS:Name="VersionMajor">1</DTS:Property><DTS:Property DTS:Name="VersionMinor">0</DTS:Property><DTS:Property DTS:Name="VersionBuild">91</DTS:Property><DTS:Property DTS:Name="VersionGUID">{F01E7F37-45B7-43B5-88FA-02BB600A82D2}</DTS:Pro perty><DTS:Property DTS:Name="EnableConfig">0</DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</DTS:Property DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">DCFile</DTS:Property><DTS:Property DTS:Name="DTSID">{84633D90-EA87-4F19-AFAC-B1C625EC451A}</DTS:Property DTS:Property DTS:Name="Description">test</DTS:Property><DTS:Property DTS:Name="CreationName">FLATFILE</DTS:Property><DTS:ObjectData><DTS:Co nnectionManager><DTS:Property DTS:Name="FileUsageType">0</DTS:Property><DTS:Property DTS:Name="Format">Delimited</DTS:Property><DTS:Property DTS:Name="LocaleID">1043</DTS:Property><DTS:Property DTS:Name="Unicode">0</DTS:Property><DTS:Property DTS:Name="HeaderRowsToSkip">0</DTS:Property><DTS:Property DTS:Name="HeaderRowDelimiter" xml:space="preserve">_x000D__x000A_</DTS:Property><DTS:Property DTS:Name="ColumnNamesInFirstDataRow">-1</DTS:Property><DTS:Property DTS:Name="RowDelimiter" xml:space="preserve"></DTS:Property><DTS:Property DTS:Name="DataRowsToSkip">0</DTS:Property><DTS:Property DTS:Name="TextQualifier"><none></DTS:Property><DTS:Property DTS:Name="CodePage">1252</DTS:Property DTS:FlatFileColumn><DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property><DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">_x007C_</DTS:Property><DTS:Property DTS:Name="ColumnWidth">0</DTS:Property><DTS:Property DTS:Name="MaximumWidth">0</DTS:Property><DTS:Property DTS:Name="DataType">3</DTS:Property><DTS:Property DTS:Name="DataPrecision">0</DTS:Property><DTS:Property DTS:Name="DataScale">0</DTS:Property><DTS:Property DTS:Name="TextQualified">-1</DTS:Property><DTS:Property DTS:Name="ObjectName">id</DTS:Property><DTS:Property DTS:Name="DTSID">{B82B5A6C-CDF6-4548-9010-1451B7846E55}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:FlatFileColumn DTS:FlatFileColumn><DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property><DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">_x007C_</DTS:Property><DTS:Property DTS:Name="ColumnWidth">0</DTS:Property><DTS:Property DTS:Name="MaximumWidth">50</DTS:Property><DTS:Property DTS:Name="DataType">129</DTS:Property><DTS:Property DTS:Name="DataPrecision">0</DTS:Property><DTS:Property DTS:Name="DataScale">0</DTS:Property><DTS:Property DTS:Name="TextQualified">-1</DTS:Property><DTS:Property DTS:Name="ObjectName">activiteitcode</DTS:Property><DTS:Property DTS:Name="DTSID">{0303EDAF-7333-4174-AD4F-F9D7ED1ED919}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:FlatFileColumn DTS:FlatFileColumn><DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property><DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">_x000A_</DTS:Property><DTS:Property DTS:Name="ColumnWidth">0</DTS:Property><DTS:Property DTS:Name="MaximumWidth">50</DTS:Property><DTS:Property DTS:Name="DataType">129</DTS:Property><DTS:Property DTS:Name="DataPrecision">0</DTS:Property><DTS:Property DTS:Name="DataScale">0</DTS:Property><DTS:Property DTS:Name="TextQualified">-1</DTS:Property><DTS:Property DTS:Name="ObjectName">activiteitbeschrijving</DTS:Property><DTS:Proper ty DTS:Name="DTSID">{5369B977-DDFD-4BC1-8B8E-D8E7B7C6EA6E}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:FlatFileColumn><DTS:Prope rty DTS:Name="ConnectionString">D:\My Documents\t.txt</DTS:Property></DTS:ConnectionManager></DTS:ObjectData /DTS:ConnectionManager DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">DCFile_automatic</DTS:Property><DTS:Property DTS:Name="DTSID">{B3011424-E971-4CB8-8E88-A580EBD4A766}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">FLATFILE</DTS:Property><DTS:ObjectData><DTS:Co nnectionManager><DTS:Property DTS:Name="FileUsageType">0</DTS:Property><DTS:Property DTS:Name="Format">Delimited</DTS:Property><DTS:Property DTS:Name="LocaleID">1043</DTS:Property><DTS:Property DTS:Name="Unicode">0</DTS:Property><DTS:Property DTS:Name="HeaderRowsToSkip">0</DTS:Property><DTS:Property DTS:Name="HeaderRowDelimiter" xml:space="preserve">_x000D__x000A_</DTS:Property><DTS:Property DTS:Name="ColumnNamesInFirstDataRow">-1</DTS:Property><DTS:Property DTS:Name="RowDelimiter" xml:space="preserve"></DTS:Property><DTS:Property DTS:Name="DataRowsToSkip">0</DTS:Property><DTS:Property DTS:Name="TextQualifier"><none></DTS:Property><DTS:Property DTS:Name="CodePage">1252</DTS:Property DTS:FlatFileColumn><DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property><DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">_x007C_</DTS:Property><DTS:Property DTS:Name="ColumnWidth">0</DTS:Property><DTS:Property DTS:Name="MaximumWidth">50</DTS:Property><DTS:Property DTS:Name="DataType">129</DTS:Property><DTS:Property DTS:Name="DataPrecision">0</DTS:Property><DTS:Property DTS:Name="DataScale">0</DTS:Property><DTS:Property DTS:Name="TextQualified">-1</DTS:Property><DTS:Property DTS:Name="ObjectName">id</DTS:Property><DTS:Property DTS:Name="DTSID">{7667F184-8B4E-4D8B-A806-A170857EC812}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:FlatFileColumn DTS:FlatFileColumn><DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property><DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">_x007C_</DTS:Property><DTS:Property DTS:Name="ColumnWidth">0</DTS:Property><DTS:Property DTS:Name="MaximumWidth">50</DTS:Property><DTS:Property DTS:Name="DataType">129</DTS:Property><DTS:Property DTS:Name="DataPrecision">0</DTS:Property><DTS:Property DTS:Name="DataScale">0</DTS:Property><DTS:Property DTS:Name="TextQualified">-1</DTS:Property><DTS:Property DTS:Name="ObjectName">activiteitcode</DTS:Property><DTS:Property DTS:Name="DTSID">{24601232-AF20-4073-A7B9-90ED4B0096C5}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:FlatFileColumn DTS:FlatFileColumn><DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property><DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">_x000A_</DTS:Property><DTS:Property DTS:Name="ColumnWidth">0</DTS:Property><DTS:Property DTS:Name="MaximumWidth">50</DTS:Property><DTS:Property DTS:Name="DataType">129</DTS:Property><DTS:Property DTS:Name="DataPrecision">0</DTS:Property><DTS:Property DTS:Name="DataScale">0</DTS:Property><DTS:Property DTS:Name="TextQualified">-1</DTS:Property><DTS:Property DTS:Name="ObjectName">activiteitbeschrijving</DTS:Property><DTS:Proper ty DTS:Name="DTSID">{1C0B17A1-4280-44B9-81D6-6706D72B6229}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:FlatFileColumn><DTS:Prope rty DTS:Name="ConnectionString">D:\My Documents\t.txt</DTS:Property></DTS:ConnectionManager></DTS:ObjectData /DTS:ConnectionManager DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">U005595\SQL_U005595.RemcoTes t</DTS:Property><DTS :Property DTS:Name="DTSID">{5BD3F144-6AD6-44E2-8E45-8D06FEFABE38}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">OLEDB</DTS:Property><DTS:ObjectData><DTS:Conne ctionManager><DTS:Property DTS:Name="Retain">0</DTS:Property><DTS:Property DTS:Name="ConnectionString">Data Source=U005595\SQL_U005595;Initial Catalog=RemcoTest;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;</DTS:Property></DTS:ConnectionManager></DTS:ObjectDat a></DTS:ConnectionManager DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS ataType="8"><PrecedenceConstraintxmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><d wd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint></DTS:Property DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{049DB30A-4B61-41C2-BA45-B42EEACF5A37}</DTS:Prop erty><DTS:Property DTS:Name="DTSID">{BBD41596-1F51-42F0-9E1E-D074956D2663}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS ataType="8"><Package xmlns:xsd="http://www.w3.org/2001/XMLSchema"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><d wd tsControlFlowDiagram><dwd:BoundingLeft>-5</dwd:BoundingLeft><dwd:Layout><dds diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.Grap hLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.G raphLayout" version="7" nextobject="11" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="21087" y="13811" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="1" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}" font ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" / /font mouseicon ddsxmlobjectstreamwrapper binary="6c74000000000000" / /mouseicon /diagram layoutmanager ddsxmlobj / /layoutmanager ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="1139" top="4365" logicalid="5" controlid="1" masterid="2" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0" control ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" / /control layoutobject ddsxmlobj property name="LogicalObject" value="{8A8B05C6-5F24-45EF-8C58-ABD7149CF9DE}" vartype="8" / property name="ShowConnectorSource" value="0" vartype="2" / /ddsxmlobj /layoutobject shape groupshapeid="0" groupnode="0" / /ddscontrol ddscontrol controlprogid="DdsShapes.DdsContainerObjectManaged Bridge.1" tooltip="Sequence Container" left="-5" top="0" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="10190" height="9711" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0" control ddsxmlobjectstreaminitwrapper binary="00080000ce270000ef250000" / /control layoutobject ddsxmlobj property name="Caption" value="Sequence Container" vartype="8" / property name="CaptionHeight" value="1164" vartype="3" / property name="Collapsed" value="0" vartype="11" / property name="CollapsedWidth" value="10190" vartype="3" / property name="LogicalObject" value="{DBD4AE19-0083-46AE-9BA7-120F16A3DCCF}" vartype="8" / property name="RealHeight" value="0" vartype="3" / property name="RealWidth" value="0" vartype="3" / property name="ShowConnectorSource" value="0" vartype="2" / /ddsxmlobj /layoutobject shape groupshapeid="0" groupnode="0" / /ddscontrol ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Init Task" left="1744" top="1911" logicalid="7" controlid="3" masterid="2" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0" control ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" / /control layoutobject ddsxmlobj property name="LogicalObject" value="{E0F8FF10-E5D8-4757-91D7-701C90F17040}" vartype="8" / property name="ShowConnectorSource" value="0" vartype="2" / /ddsxmlobj /layoutobject shape groupshapeid="0" groupnode="0" / /ddscontrol ddscontrol controlprogid="MSDDS.Polyline" left="2539" top="2676" logicalid="8" controlid="4" masterid="0" hint1="0" hint2="0" width="1404" height="2189" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0" control ddsxmlobj polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" / /ddsxmlobj /control layoutobject ddsxmlobj property name="LogicalObject" value="{049DB30A-4B61-41C2-BA45-B42EEACF5A37}" vartype="8" / property name="Virtual" value="0" vartype="11" / property name="VisibleAP" value="0" vartype="3" / /ddsxmlobj /layoutobject connector lineroutestyle="Microsoft.DataWarehouse.Layout.Gra phLayout" sourceid="3" destid="1" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0" point x="3543" y="3075" / point x="3543" y="3720" / point x="2938" y="3720" / point x="2938" y="4365" / /connector /ddscontrol /dds></dwd:Layout></dwd tsControlFlowDiagram></Package></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{34231942-5988-49CF-A6B8-57FC5E5FFE33}</DTS:Prop erty><DTS:Property DTS:Name="DTSID">{E7601CC4-F148-4978-BD4E-6913839F40F5}</DTS:Property DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.