question

RosCampbell-3244 avatar image
0 Votes"
RosCampbell-3244 asked GuoxiongYuan-7218 edited

The SQL Server Agent Job scheduled of the dtsx file is failing

Hi,

I created a dtsx file through Microsoft Visual Studio version 18.6 to run an SQL script. At the end of setting it up, it ran and created the CSV file correctly.

Next I set up a job schedule through SQL Server Agent, and tried to run it. It failed saying

"The job failed - Excuted as user: NT Service\SQLSERVERAGENT.Microsoft (R) SQL Server Execute Package Utility Version 13.0.5865.1 for 64-bit. Copyright (C) 2016. All rights reserved. Started 12:05:01PM Error 2022-03-31 12:05:01:19 Code 0xC0048020 Source: Data Flow Task 1 (SSIS.Pipeline) Description: The version of Destination - Testing_csv is not compatible with this version of the DataFlow. End Error Error: 2022-02-31 12:05:01.20 Code 0xC0048020 Source Data Flow Task 1 SSIS.Pipeline Description: The version of Destination - Testing_csv.clsid {44152846-E5A6-4EDB-8B8E-7072209A7662} is not compatible with this version of DataFlow. End Error Error: 2022-03-31 12:05:01:20 Code: 0xC0048021 Source: Data Flow Task 1 Destination - Testing_csv [2] Description: The component is missing not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Flat File Destination, Microsoft Corporation, Microsoft SQL Server (C) Microsoft Corporation All Rights Reserved http://www.microsoft.com/sql/support:1 End Error

Is that enough to identify what the issue is?

Thank you for your help

Best wishes

Ros

sql-server-generalsql-server-transact-sqlsql-server-integration-services
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

4 Answers

GuoxiongYuan-7218 avatar image
0 Votes"
GuoxiongYuan-7218 answered GuoxiongYuan-7218 edited

What is your SQL server version (SELECT @@VERSION)? In your SSIS project property, you need to set the target server version to the same version of your SQL server.

188818-image.png


Open your SSIS project in Visual Studio and right click on the project property. On the Property Pages, you will see "TargetServerVersion" under the "General" tab. You also can check it by searching for "TargetServerVersion" in the dtproj file. You should see the tag <TargetServerVersion>SQLServer2016</TargetServerVersion>


image.png (22.2 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RosCampbell-3244 avatar image
0 Votes"
RosCampbell-3244 answered GuoxiongYuan-7218 commented

Hi,

Thank you for coming back to me. The Server version is showing as:

Microsoft SQL Server 2016 (SP2-CU15-GDR) (KB4583461) - 13.0.5865.1 (X64)
Oct 31 2020 02:43:57
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)

I couldn't see how to edit the SSIS project property to set the target server version to the same version of your SQL server as per the screen shot above?

The SQL server management studio version is saying v18.6 see attached, where I created the .dtsx files. And there is a visual studio showing version 17.1.0 (2022) (again see attached ).188891-versions-etc.pdf

The script for the SSIS is below - can I change it in there, or is there another way?

Thank you for your help.

Best wishes

Ros

Script from the .dtsx file:

<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
DTS:refId="Package"
DTS:CreationDate="3/31/2022 11:32:19 AM"
DTS:CreationName="Microsoft.Package"
DTS:CreatorComputerName="LISHMANS-SQL01"
DTS:CreatorName="LISHMANS\alcam"
DTS:Description="Testing SSIS Package Description"
DTS:DTSID="{2B20C829-15CF-4361-B803-72B4F995EA19}"
DTS:ExecutableType="Microsoft.Package"
DTS:LastModifiedProductVersion="15.0.2000.118"
DTS:LocaleID="1033"
DTS:MaxErrorCount="0"
DTS:ObjectName="Test"
DTS:ProtectionLevel="0"
DTS:VersionGUID="{E4DD3375-4D58-4EC7-92B8-C5F9459D8F54}">
<DTS:Property
DTS:Name="PackageFormatVersion">8</DTS:Property>
<DTS:ConnectionManagers>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[DestinationConnectionFlatFile]"
DTS:CreationName="FLATFILE"
DTS:DTSID="{0A5C1D97-BC4F-4CE7-B1AB-5BDBB3D1CD4D}"
DTS:ObjectName="DestinationConnectionFlatFile">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:Format="Delimited"
DTS:LocaleID="2057"
DTS:HeaderRowDelimiter="x000Dx000A"
DTS:ColumnNamesInFirstDataRow="True"
DTS:RowDelimiter=""
DTS:TextQualifier="x003C_none_x003E"
DTS:CodePage="1252"
DTS:ConnectionString="\\lishmans-fs01\sage\IRIS\Reports - Excel\Data\SSIS Packages\Testing.csv">
<DTS:FlatFileColumns>
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffId"
DTS:DTSID="{282E98BB-5643-4EAE-B5AE-46CCF0337B72}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="120"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffName"
DTS:DTSID="{22C62FA6-269E-4551-BDA2-5F25CA31E45D}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffDepartment"
DTS:DTSID="{519B3106-A88A-436E-BE7C-2AA93802D368}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffBranch"
DTS:DTSID="{ECF02FD5-C0A0-4640-B4D2-9091C8A8B7A3}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="501"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffDepartmentDesc"
DTS:DTSID="{DC02246C-AAB7-46F0-8F41-7CE0F2F819D5}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffCategory"
DTS:DTSID="{6FA76D7F-B852-423D-850A-380003833BA1}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="501"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffCategoryDesc"
DTS:DTSID="{11D50A4A-ABBD-44F1-9063-76914053DA41}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffPartner"
DTS:DTSID="{AB61598A-0EFD-4782-96F6-ED11B55A02B4}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffManager"
DTS:DTSID="{7CAD9A22-64B9-4FFD-A555-F97697FC9AE3}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="120"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffPartnerName"
DTS:DTSID="{D2E99A56-D5E3-4859-82AB-0F12AA5FF265}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="120"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffManagerName"
DTS:DTSID="{31F78725-0D0D-4DE0-B345-63BC27C97821}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="501"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="StaffBranchDesc"
DTS:DTSID="{BB41BAE6-B644-4818-A6AC-0D49C24F27F7}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="1"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="Chargeable"
DTS:DTSID="{13A715BF-6129-4C86-8C48-4144B9DB44C6}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="6"
DTS:DataType="2"
DTS:TextQualified="True"
DTS:ObjectName="Year"
DTS:DTSID="{F72585BF-9DB5-49A3-8FBF-A62B67B1B78D}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="3"
DTS:DataType="17"
DTS:TextQualified="True"
DTS:ObjectName="Period"
DTS:DTSID="{391BF1C4-1B74-4C90-88B4-3B2E42482F73}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="3"
DTS:TextQualified="True"
DTS:ObjectName="Posting"
DTS:DTSID="{965E2F19-42B9-406D-A0FB-A6CB763EE2D4}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:DataType="304"
DTS:DataScale="3"
DTS:TextQualified="True"
DTS:ObjectName="Date"
DTS:DTSID="{FA97B120-4297-4C8A-B34E-8D5F2838992D}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="2"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="Type"
DTS:DTSID="{AB2AE3B1-0215-4453-B39F-1205D0D52844}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="250"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="Narrative"
DTS:DTSID="{FEC5EE2D-256F-4B83-B04F-250A2844B6B9}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="31"
DTS:DataType="131"
DTS:DataPrecision="38"
DTS:TextQualified="True"
DTS:ObjectName="Amount"
DTS:DTSID="{A55AD090-F766-47D6-BE0F-D6D2AFCF9531}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="3"
DTS:TextQualified="True"
DTS:ObjectName="ActualMinutes"
DTS:DTSID="{FF80616D-ACAD-413A-83D2-73D823605B68}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="31"
DTS:DataType="131"
DTS:DataPrecision="38"
DTS:TextQualified="True"
DTS:ObjectName="WIPCost"
DTS:DTSID="{FD90CB84-C632-4F45-B191-7DD4C81DE9EF}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="31"
DTS:DataType="131"
DTS:DataPrecision="38"
DTS:TextQualified="True"
DTS:ObjectName="Matched"
DTS:DTSID="{86FE73E6-1FAB-49BD-ABCE-1F3A743D1C0B}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="JobClientId"
DTS:DTSID="{22A0E2BF-1E33-4869-9DB8-3AA4F3090DA0}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="11"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="JobType"
DTS:DTSID="{EF4F19BD-918B-4DE9-847B-4E7607B88968}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="1"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="Pending"
DTS:DTSID="{A215A171-7A08-4961-BBB3-DD96B30D407F}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="3"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="PostCategory"
DTS:DTSID="{1C6D9EFC-CC55-4C33-8404-C1CBD1C7B6F4}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="1"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="IncludesExpenses"
DTS:DTSID="{FE12CD73-C3E3-4F13-BFC6-9A9E22BDB8D6}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x002C"
DTS:MaximumWidth="1"
DTS:DataType="129"
DTS:TextQualified="True"
DTS:ObjectName="IncludesWIP"
DTS:DTSID="{696D5761-E50C-4990-8A27-AF1B014B1499}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="x000Dx000A"
DTS:MaximumWidth="11"
DTS:DataType="3"
DTS:TextQualified="True"
DTS:ObjectName="ExpenseCatInternalId"
DTS:DTSID="{7B25073B-65EF-4F2A-BE5C-2016C2BD271B}"
DTS:CreationName="" />
</DTS:FlatFileColumns>
</DTS:ConnectionManager>
</DTS:ObjectData>
</DTS:ConnectionManager>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[SourceConnectionOLEDB]"
DTS:CreationName="OLEDB"
DTS:DTSID="{AFE74F71-A030-466C-9C59-FAEB427C972A}"
DTS:ObjectName="SourceConnectionOLEDB">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:ConnectionString="Data Source=LISHMANS-SQL01;Initial Catalog=IRIS;Provider=SQLNCLI11;Integrated Security=SSPI;Auto Translate=false;" />
</DTS:ObjectData>
</DTS:ConnectionManager>
</DTS:ConnectionManagers>
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Data Flow Task 1"
DTS:CreationName="Microsoft.Pipeline"
DTS:DTSID="{69171B6F-0629-4D53-992F-5B0A3F571CE8}"
DTS:ExecutableType="Microsoft.Pipeline"
DTS:FailPackageOnFailure="True"
DTS:LocaleID="-1"
DTS:ObjectName="Data Flow Task 1"
DTS:TaskContact="Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">;
<DTS:Variables />
<DTS:ObjectData>
<pipeline
defaultBufferSize="3145728"
version="1">
<components>
<component
refId="Package\Data Flow Task 1\Destination - Testing_csv"
componentClassID="Microsoft.FlatFileDestination"
contactInfo="Flat File Destination;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1"
description="Flat File Destination"
localeId="2057"
name="Destination - Testing_csv"
version="1">
<properties>
<property
dataType="System.Boolean"
description="Specifies whether the data will overwrite or append to the destination file."
name="Overwrite">false</property>
<property
dataType="System.String"
description="Specifies the text to write to the destination file before any data is written."
expressionType="Notify"
name="Header"></property>
<property
dataType="System.Boolean"
description="When text qualifier is enabled, specifies whether the text qualifier in the data written to the destination file will be escaped or not."
name="EscapeQualifier">false</property>
</properties>
<connections>
<connection
refId="Package\Data Flow Task 1\Destination - Testing_csv.Connections[FlatFileConnection]"
connectionManagerID="Package.ConnectionManagers[DestinationConnectionFlatFile]"
connectionManagerRefId="Package.ConnectionManagers[DestinationConnectionFlatFile]"
name="FlatFileConnection" />
</connections>
<inputs>
<input
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input]"
hasSideEffects="true"
name="Flat File Destination Input">
<inputColumns>
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffId]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="11"
cachedName="StaffId"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffId]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffId]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffName]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="120"
cachedName="StaffName"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffName]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffName]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffDepartment]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="11"
cachedName="StaffDepartment"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffDepartment]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffDepartment]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffBranch]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="11"
cachedName="StaffBranch"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffBranch]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffBranch]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffDepartmentDesc]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="501"
cachedName="StaffDepartmentDesc"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffDepartmentDesc]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffDepartmentDesc]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffCategory]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="11"
cachedName="StaffCategory"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffCategory]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffCategory]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffCategoryDesc]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="501"
cachedName="StaffCategoryDesc"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffCategoryDesc]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffCategoryDesc]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffPartner]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="11"
cachedName="StaffPartner"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffPartner]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffPartner]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffManager]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="11"
cachedName="StaffManager"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffManager]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffManager]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffPartnerName]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="120"
cachedName="StaffPartnerName"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffPartnerName]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffPartnerName]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffManagerName]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="120"
cachedName="StaffManagerName"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffManagerName]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffManagerName]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[StaffBranchDesc]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="501"
cachedName="StaffBranchDesc"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffBranchDesc]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffBranchDesc]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Chargeable]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="1"
cachedName="Chargeable"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Chargeable]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Chargeable]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Year]"
cachedDataType="i2"
cachedName="Year"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Year]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Year]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Period]"
cachedDataType="ui1"
cachedName="Period"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Period]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Period]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Posting]"
cachedDataType="i4"
cachedName="Posting"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Posting]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Posting]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Date]"
cachedDataType="dbTimeStamp"
cachedName="Date"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Date]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Date]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Type]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="2"
cachedName="Type"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Type]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Type]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Narrative]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="250"
cachedName="Narrative"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Narrative]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Narrative]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Amount]"
cachedDataType="numeric"
cachedName="Amount"
cachedPrecision="18"
cachedScale="2"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Amount]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Amount]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[ActualMinutes]"
cachedDataType="i4"
cachedName="ActualMinutes"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[ActualMinutes]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[ActualMinutes]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[WIPCost]"
cachedDataType="numeric"
cachedName="WIPCost"
cachedPrecision="18"
cachedScale="2"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[WIPCost]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[WIPCost]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Matched]"
cachedDataType="numeric"
cachedName="Matched"
cachedPrecision="18"
cachedScale="2"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Matched]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Matched]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[JobClientId]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="11"
cachedName="JobClientId"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[JobClientId]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[JobClientId]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[JobType]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="11"
cachedName="JobType"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[JobType]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[JobType]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[Pending]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="1"
cachedName="Pending"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Pending]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Pending]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[PostCategory]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="3"
cachedName="PostCategory"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[PostCategory]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[PostCategory]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[IncludesExpenses]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="1"
cachedName="IncludesExpenses"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[IncludesExpenses]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[IncludesExpenses]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[IncludesWIP]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="1"
cachedName="IncludesWIP"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[IncludesWIP]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[IncludesWIP]" />
<inputColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].Columns[ExpenseCatInternalId]"
cachedDataType="i4"
cachedName="ExpenseCatInternalId"
externalMetadataColumnId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[ExpenseCatInternalId]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[ExpenseCatInternalId]" />
</inputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffId]"
codePage="1252"
dataType="str"
length="11"
name="StaffId" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffName]"
codePage="1252"
dataType="str"
length="120"
name="StaffName" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffDepartment]"
codePage="1252"
dataType="str"
length="11"
name="StaffDepartment" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffBranch]"
codePage="1252"
dataType="str"
length="11"
name="StaffBranch" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffDepartmentDesc]"
codePage="1252"
dataType="str"
length="501"
name="StaffDepartmentDesc" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffCategory]"
codePage="1252"
dataType="str"
length="11"
name="StaffCategory" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffCategoryDesc]"
codePage="1252"
dataType="str"
length="501"
name="StaffCategoryDesc" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffPartner]"
codePage="1252"
dataType="str"
length="11"
name="StaffPartner" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffManager]"
codePage="1252"
dataType="str"
length="11"
name="StaffManager" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffPartnerName]"
codePage="1252"
dataType="str"
length="120"
name="StaffPartnerName" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffManagerName]"
codePage="1252"
dataType="str"
length="120"
name="StaffManagerName" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[StaffBranchDesc]"
codePage="1252"
dataType="str"
length="501"
name="StaffBranchDesc" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Chargeable]"
codePage="1252"
dataType="str"
length="1"
name="Chargeable" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Year]"
dataType="i2"
name="Year" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Period]"
dataType="ui1"
name="Period" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Posting]"
dataType="i4"
name="Posting" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Date]"
dataType="dbTimeStamp2"
name="Date"
scale="3" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Type]"
codePage="1252"
dataType="str"
length="2"
name="Type" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Narrative]"
codePage="1252"
dataType="str"
length="250"
name="Narrative" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Amount]"
dataType="numeric"
name="Amount"
precision="38" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[ActualMinutes]"
dataType="i4"
name="ActualMinutes" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[WIPCost]"
dataType="numeric"
name="WIPCost"
precision="38" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Matched]"
dataType="numeric"
name="Matched"
precision="38" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[JobClientId]"
codePage="1252"
dataType="str"
length="11"
name="JobClientId" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[JobType]"
codePage="1252"
dataType="str"
length="11"
name="JobType" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[Pending]"
codePage="1252"
dataType="str"
length="1"
name="Pending" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[PostCategory]"
codePage="1252"
dataType="str"
length="3"
name="PostCategory" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[IncludesExpenses]"
codePage="1252"
dataType="str"
length="1"
name="IncludesExpenses" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[IncludesWIP]"
codePage="1252"
dataType="str"
length="1"
name="IncludesWIP" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input].ExternalColumns[ExpenseCatInternalId]"
dataType="i4"
name="ExpenseCatInternalId" />
</externalMetadataColumns>
</input>
</inputs>
</component>
<component
refId="Package\Data Flow Task 1\Source - Query"
componentClassID="Microsoft.OLEDBSource"
contactInfo="OLE DB Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7"
description="OLE DB Source"
name="Source - Query"
usesDispositions="true"
version="7">
<properties>
<property
dataType="System.Int32"
description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out."
name="CommandTimeout">0</property>
<property
dataType="System.String"
description="Specifies the name of the database object used to open a rowset."
name="OpenRowset"></property>
<property
dataType="System.String"
description="Specifies the variable that contains the name of the database object used to open a rowset."
name="OpenRowsetVariable"></property>
<property
dataType="System.String"
description="The SQL command to be executed."
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor">SELECT Practice.ibvStaffCategorisation.StaffId, Practice.ibvStaffCategorisation.StaffName, Practice.ibvStaffCategorisation.StaffDepartment, Practice.ibvStaffCategorisation.StaffBranch, Practice.ibvStaffCategorisation.StaffDepartmentDesc, Practice.ibvStaffCategorisation.StaffCategory, Practice.ibvStaffCategorisation.StaffCategoryDesc, Practice.ibvStaffCategorisation.StaffPartner,
Practice.ibvStaffCategorisation.StaffManager, Practice.ibvStaffCategorisation.StaffPartnerName, Practice.ibvStaffCategorisation.StaffManagerName, Practice.ibvStaffCategorisation.StaffBranchDesc, Practice.idvTimePosting.Chargeable, Practice.idvTimePosting.Year, Practice.idvTimePosting.Period, Practice.idvTimePosting.Posting, Practice.idvTimePosting.Date, Practice.idvTimePosting.Type,
Practice.idvTimePosting.Narrative, Practice.idvTimePosting.Amount, Practice.idvTimePosting.ActualMinutes, Practice.idvTimePosting.WIPCost, Practice.idvTimePosting.Matched, Practice.ibvJobCategorisation.JobClientId, Practice.ibvJobCategorisation.JobType, Practice.idvTimePosting.Pending, Practice.idvTimePosting.PostCategory, Practice.idvTimePosting.IncludesExpenses,
Practice.idvTimePosting.IncludesWIP, Practice.idvTimePosting.ExpenseCatInternalId
FROM Practice.idvTimePosting LEFT OUTER JOIN
Practice.ibvJobCategorisation ON Practice.idvTimePosting.JobInternalId = Practice.ibvJobCategorisation.JobInternalId LEFT OUTER JOIN
Practice.ibvStaffCategorisation ON Practice.idvTimePosting.StaffInternalId = Practice.ibvStaffCategorisation.StaffInternalId
WHERE (Practice.idvTimePosting.Chargeable = 'Y') AND (Practice.idvTimePosting.Type = 'TS') AND (Practice.idvTimePosting.Year &gt; 2019) AND (Practice.idvTimePosting.Pending = 'N') OR
(Practice.idvTimePosting.Chargeable = 'Y') AND (Practice.idvTimePosting.Type = 'AH') AND (Practice.idvTimePosting.Year &gt; 2019) AND (Practice.idvTimePosting.Pending = 'N') OR
(Practice.idvTimePosting.Chargeable = 'Y') AND (Practice.idvTimePosting.Type = 'TA') AND (Practice.idvTimePosting.Year &gt; 2019) AND (Practice.idvTimePosting.Pending = 'N')</property>
<property
dataType="System.String"
description="The variable that contains the SQL command to be executed."
name="SqlCommandVariable"></property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Boolean"
description="Forces the use of the DefaultCodePage property value when describing character data."
name="AlwaysUseDefaultCodePage">false</property>
<property
dataType="System.Int32"
description="Specifies the mode used to access the database."
name="AccessMode"
typeConverter="AccessMode">2</property>
<property
dataType="System.String"
description="The mappings between the parameters in the SQL command and variables."
name="ParameterMapping"></property>
</properties>
<connections>
<connection
refId="Package\Data Flow Task 1\Source - Query.Connections[OleDbConnection]"
connectionManagerID="Package.ConnectionManagers[SourceConnectionOLEDB]"
connectionManagerRefId="Package.ConnectionManagers[SourceConnectionOLEDB]"
description="The OLE DB runtime connection used to access the database."
name="OleDbConnection" />
</connections>
<outputs>
<output
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output]"
name="OLE DB Source Output">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffId]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffId]"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffId]"
name="StaffId"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffName]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffName]"
length="120"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffName]"
name="StaffName"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffDepartment]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffDepartment]"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffDepartment]"
name="StaffDepartment"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffBranch]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffBranch]"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffBranch]"
name="StaffBranch"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffDepartmentDesc]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffDepartmentDesc]"
length="501"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffDepartmentDesc]"
name="StaffDepartmentDesc"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffCategory]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffCategory]"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffCategory]"
name="StaffCategory"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffCategoryDesc]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffCategoryDesc]"
length="501"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffCategoryDesc]"
name="StaffCategoryDesc"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffPartner]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffPartner]"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffPartner]"
name="StaffPartner"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffManager]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffManager]"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffManager]"
name="StaffManager"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffPartnerName]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffPartnerName]"
length="120"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffPartnerName]"
name="StaffPartnerName"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffManagerName]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffManagerName]"
length="120"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffManagerName]"
name="StaffManagerName"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffBranchDesc]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffBranchDesc]"
length="501"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[StaffBranchDesc]"
name="StaffBranchDesc"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Chargeable]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Chargeable]"
length="1"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Chargeable]"
name="Chargeable"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Year]"
dataType="i2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Year]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Year]"
name="Year"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Period]"
dataType="ui1"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Period]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Period]"
name="Period"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Posting]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Posting]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Posting]"
name="Posting"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Date]"
dataType="dbTimeStamp"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Date]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Date]"
name="Date"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Type]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Type]"
length="2"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Type]"
name="Type"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Narrative]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Narrative]"
length="250"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Narrative]"
name="Narrative"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Amount]"
dataType="numeric"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Amount]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Amount]"
name="Amount"
precision="18"
scale="2"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[ActualMinutes]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[ActualMinutes]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[ActualMinutes]"
name="ActualMinutes"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[WIPCost]"
dataType="numeric"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[WIPCost]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[WIPCost]"
name="WIPCost"
precision="18"
scale="2"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Matched]"
dataType="numeric"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Matched]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Matched]"
name="Matched"
precision="18"
scale="2"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[JobClientId]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[JobClientId]"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[JobClientId]"
name="JobClientId"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[JobType]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[JobType]"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[JobType]"
name="JobType"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Pending]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Pending]"
length="1"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[Pending]"
name="Pending"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[PostCategory]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[PostCategory]"
length="3"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[PostCategory]"
name="PostCategory"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[IncludesExpenses]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[IncludesExpenses]"
length="1"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[IncludesExpenses]"
name="IncludesExpenses"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[IncludesWIP]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[IncludesWIP]"
length="1"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[IncludesWIP]"
name="IncludesWIP"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[ExpenseCatInternalId]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[ExpenseCatInternalId]"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].Columns[ExpenseCatInternalId]"
name="ExpenseCatInternalId"
truncationRowDisposition="FailComponent" />
</outputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffId]"
codePage="1252"
dataType="str"
length="11"
name="StaffId" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffName]"
codePage="1252"
dataType="str"
length="120"
name="StaffName" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffDepartment]"
codePage="1252"
dataType="str"
length="11"
name="StaffDepartment" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffBranch]"
codePage="1252"
dataType="str"
length="11"
name="StaffBranch" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffDepartmentDesc]"
codePage="1252"
dataType="str"
length="501"
name="StaffDepartmentDesc" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffCategory]"
codePage="1252"
dataType="str"
length="11"
name="StaffCategory" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffCategoryDesc]"
codePage="1252"
dataType="str"
length="501"
name="StaffCategoryDesc" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffPartner]"
codePage="1252"
dataType="str"
length="11"
name="StaffPartner" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffManager]"
codePage="1252"
dataType="str"
length="11"
name="StaffManager" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffPartnerName]"
codePage="1252"
dataType="str"
length="120"
name="StaffPartnerName" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffManagerName]"
codePage="1252"
dataType="str"
length="120"
name="StaffManagerName" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[StaffBranchDesc]"
codePage="1252"
dataType="str"
length="501"
name="StaffBranchDesc" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Chargeable]"
codePage="1252"
dataType="str"
length="1"
name="Chargeable" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Year]"
dataType="i2"
name="Year" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Period]"
dataType="ui1"
name="Period" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Posting]"
dataType="i4"
name="Posting" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Date]"
dataType="dbTimeStamp"
name="Date" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Type]"
codePage="1252"
dataType="str"
length="2"
name="Type" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Narrative]"
codePage="1252"
dataType="str"
length="250"
name="Narrative" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Amount]"
dataType="numeric"
name="Amount"
precision="18"
scale="2" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[ActualMinutes]"
dataType="i4"
name="ActualMinutes" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[WIPCost]"
dataType="numeric"
name="WIPCost"
precision="18"
scale="2" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Matched]"
dataType="numeric"
name="Matched"
precision="18"
scale="2" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[JobClientId]"
codePage="1252"
dataType="str"
length="11"
name="JobClientId" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[JobType]"
codePage="1252"
dataType="str"
length="11"
name="JobType" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[Pending]"
codePage="1252"
dataType="str"
length="1"
name="Pending" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[PostCategory]"
codePage="1252"
dataType="str"
length="3"
name="PostCategory" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[IncludesExpenses]"
codePage="1252"
dataType="str"
length="1"
name="IncludesExpenses" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[IncludesWIP]"
codePage="1252"
dataType="str"
length="1"
name="IncludesWIP" />
<externalMetadataColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output].ExternalColumns[ExpenseCatInternalId]"
dataType="i4"
name="ExpenseCatInternalId" />
</externalMetadataColumns>
</output>
<output
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output]"
isErrorOut="true"
name="OLE DB Source Error Output">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffId]"
codePage="1252"
dataType="str"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffId]"
name="StaffId" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffName]"
codePage="1252"
dataType="str"
length="120"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffName]"
name="StaffName" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffDepartment]"
codePage="1252"
dataType="str"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffDepartment]"
name="StaffDepartment" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffBranch]"
codePage="1252"
dataType="str"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffBranch]"
name="StaffBranch" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffDepartmentDesc]"
codePage="1252"
dataType="str"
length="501"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffDepartmentDesc]"
name="StaffDepartmentDesc" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffCategory]"
codePage="1252"
dataType="str"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffCategory]"
name="StaffCategory" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffCategoryDesc]"
codePage="1252"
dataType="str"
length="501"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffCategoryDesc]"
name="StaffCategoryDesc" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffPartner]"
codePage="1252"
dataType="str"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffPartner]"
name="StaffPartner" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffManager]"
codePage="1252"
dataType="str"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffManager]"
name="StaffManager" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffPartnerName]"
codePage="1252"
dataType="str"
length="120"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffPartnerName]"
name="StaffPartnerName" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffManagerName]"
codePage="1252"
dataType="str"
length="120"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffManagerName]"
name="StaffManagerName" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffBranchDesc]"
codePage="1252"
dataType="str"
length="501"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[StaffBranchDesc]"
name="StaffBranchDesc" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Chargeable]"
codePage="1252"
dataType="str"
length="1"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Chargeable]"
name="Chargeable" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Year]"
dataType="i2"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Year]"
name="Year" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Period]"
dataType="ui1"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Period]"
name="Period" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Posting]"
dataType="i4"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Posting]"
name="Posting" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Date]"
dataType="dbTimeStamp"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Date]"
name="Date" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Type]"
codePage="1252"
dataType="str"
length="2"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Type]"
name="Type" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Narrative]"
codePage="1252"
dataType="str"
length="250"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Narrative]"
name="Narrative" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Amount]"
dataType="numeric"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Amount]"
name="Amount"
precision="18"
scale="2" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[ActualMinutes]"
dataType="i4"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[ActualMinutes]"
name="ActualMinutes" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[WIPCost]"
dataType="numeric"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[WIPCost]"
name="WIPCost"
precision="18"
scale="2" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Matched]"
dataType="numeric"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Matched]"
name="Matched"
precision="18"
scale="2" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[JobClientId]"
codePage="1252"
dataType="str"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[JobClientId]"
name="JobClientId" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[JobType]"
codePage="1252"
dataType="str"
length="11"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[JobType]"
name="JobType" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Pending]"
codePage="1252"
dataType="str"
length="1"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[Pending]"
name="Pending" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[PostCategory]"
codePage="1252"
dataType="str"
length="3"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[PostCategory]"
name="PostCategory" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[IncludesExpenses]"
codePage="1252"
dataType="str"
length="1"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[IncludesExpenses]"
name="IncludesExpenses" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[IncludesWIP]"
codePage="1252"
dataType="str"
length="1"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[IncludesWIP]"
name="IncludesWIP" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[ExpenseCatInternalId]"
dataType="i4"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[ExpenseCatInternalId]"
name="ExpenseCatInternalId" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
</components>
<paths>
<path
refId="Package\Data Flow Task 1.Paths[OLE DB Source Output]"
endId="Package\Data Flow Task 1\Destination - Testing_csv.Inputs[Flat File Destination Input]"
name="OLE DB Source Output"
startId="Package\Data Flow Task 1\Source - Query.Outputs[OLE DB Source Output]" />
</paths>
</pipeline>
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
</DTS:Executable>



versions-etc.pdf (103.9 KiB)
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GuoxiongYuan-7218 avatar image GuoxiongYuan-7218 ·

See my updated answer.

0 Votes 0 ·
Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered RosCampbell-3244 commented

Hi @RosCampbell-3244,

You may import the dts file with Visual Studio.

Add the existing package and then change the target server version.

Don't forget to re-deploy it.

188870-image.png

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



image.png (19.2 KiB)
· 3
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RosCampbell-3244 avatar image RosCampbell-3244 ·

Hi Zoe, Thank you for coming back to me. I have tried this, but we have visual studio 2022 installed and can't figure it out how to do the above. The internet doesn't have much on 2022. I have asked if we can get an earlier version installed and will have ago on that. Thanks for your help, will update this once that's in place. Fingers crossed.
Best wishes
Ros

0 Votes 0 ·
Zoehui-MSFT avatar image Zoehui-MSFT RosCampbell-3244 ·

VS2022 do not have SSIS temporarily. Check this link to download earlier version.
https://my.visualstudio.com/Downloads?q=Visual%20Studio%202019

0 Votes 0 ·
RosCampbell-3244 avatar image RosCampbell-3244 Zoehui-MSFT ·

Thank you for getting back to me.

I have asked again about an earlier version, so will wait for that and have another go. Best wishes Ros

0 Votes 0 ·
RosCampbell-3244 avatar image
0 Votes"
RosCampbell-3244 answered GuoxiongYuan-7218 edited

Hi, so Visual Studio 2019 has been installed and I still cannot see how to do the above. The screen is all black, and I can't see how to get to the screen to change the target server version ...

Can anyone help with this? I have looked on the internet and found about creating a project first and following the steps, https://sqlstudies.com/2017/08/16/creating-an-ssis-project/ but the screens are all different. Falling at the first hurdle of creating a project of type "integration services project"

On this from above, "Open your SSIS project in Visual Studio and right click on the project property. On the Property Pages, you will see "TargetServerVersion" under the "General" tab. You also can check it by searching for "TargetServerVersion" in the dtproj file. You should see the tag" - I only have a .dtsx file that I created in Microsoft SQL Server Management Studio version 18.6 to run an SQL script. I was trying to create a project, then import the .dtsx file - that seemed to be what the instructions were advising.

Help and thank you

Ros

· 8
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GuoxiongYuan-7218 avatar image GuoxiongYuan-7218 ·

Are you able to import your .dtsx file to your project?

0 Votes 0 ·
RosCampbell-3244 avatar image RosCampbell-3244 GuoxiongYuan-7218 ·

Hi, I'm struggling to create the project. The instructions in

https://sqlstudies.com/2017/08/16/creating-an-ssis-project/ but the screens are all different. So I can't create a project of type "integration services project" to import the .dtsx file into?

The screens in Visual Studio 2019 are totally different.

Thanks

Ros


0 Votes 0 ·
GuoxiongYuan-7218 avatar image GuoxiongYuan-7218 RosCampbell-3244 ·

Make sure you have the SSIS installed. From VS, click on the tab "Extensions" and select "Manage Extensions". Check if the SSIS is installed:

193150-image.png


0 Votes 0 ·
image.png (7.7 KiB)
Show more comments