﻿<?xml version="1.0" encoding="utf-8"?><XmlProjectInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Id="32e1fb3b-9c5e-4951-b0f6-58f39bf50c8d" Name="CSVdataAB project" Type="0" OutputPath="build\" DefaultPublishProfile="Default" Version="2.12.3497.0" NotReplaceMacroInPreview="false" DisableMacroExtensions="false" TargitDbVersion="Version_1_334"><FileSystemObjects><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.XmlProjectModelInfo"><XmlProjectModelInfo FileName="CSVdataAB project.impm" BuildAction="Yes" Id="4049fd97-78c5-49ad-ad35-5743edd45c24" Created="2023-08-03T10:42:33.5721118+02:00" CreatedBy="TARGIT-INET\ole_d" Edited="2023-08-03T11:41:14.6041178+02:00" EditedBy="TARGIT-INET\ole_d" IsOpened="true" CubeName="CSVdataAB project" PublishToServer="true" Is32BitExecutionMode="false" IsBaseScriptLocked="false" ExecuteOnScheduleOnly="false" IsStandard="false" RetryAttempts="0" RetryIntervalMins="0" RestartOnServiceFailure="true" RemoveDatabaseFromScheduler="true"><Instructions><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="CSVdataA" Id="dc14bbe9-f75d-4e9d-bd59-22d237b3bd05" DataSourceId="e2f1f195-96d6-43d1-877d-cbd04b6a51c5" DataSourceText="CSV" DataSourceQuery="SELECT * FROM [C:\Temp\CSVdata\CSVdataA.txt]" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="CSVdataAFull" Id="e6842602-999d-40c3-ae04-5e168dfe1217" DataSourceId="8d0931c9-4c61-4bc1-b02e-ce8cdbbe204b" DataSourceText="ME" DataSourceQuery="SELECT &#xD;&#xA;CAST(COLUMNEXISTS(Time,Time,null) as VARCHAR) AS Time,&#xD;&#xA;CAST(COLUMNEXISTS(Value1,Value1,null) as VARCHAR) AS Value1,&#xD;&#xA;CAST(COLUMNEXISTS(Value2,Value2,null) as VARCHAR) AS Value2,&#xD;&#xA;CAST(COLUMNEXISTS(Value3,Value3,null) as VARCHAR) AS Value3,&#xD;&#xA;CAST(COLUMNEXISTS(Value4,Value4,null) as VARCHAR) AS Value4,&#xD;&#xA;CAST(COLUMNEXISTS(Value5,Value5,null) as VARCHAR) AS Value5,&#xD;&#xA;CAST(COLUMNEXISTS(Value6,Value6,null) as VARCHAR) AS Value6&#xD;&#xA;FROM [CSVdataA]" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="CSVdataAll" Id="58aa5155-db5b-4c2a-a5fc-f002eb283916" DataSourceId="8d0931c9-4c61-4bc1-b02e-ce8cdbbe204b" DataSourceText="ME" DataSourceQuery="SELECT * FROM [CSVdataAFull]" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="CSVdataB" Id="dc14bbe9-f75d-4e9d-bd59-22d237b3bd05" DataSourceId="e2f1f195-96d6-43d1-877d-cbd04b6a51c5" DataSourceText="CSV" DataSourceQuery="SELECT * FROM [C:\Temp\CSVdata\CSVdataB.txt]" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="CSVdataBFull" Id="e6842602-999d-40c3-ae04-5e168dfe1217" DataSourceId="8d0931c9-4c61-4bc1-b02e-ce8cdbbe204b" DataSourceText="ME" DataSourceQuery="SELECT &#xD;&#xA;CAST(COLUMNEXISTS(Time,Time,null) as VARCHAR) AS Time,&#xD;&#xA;CAST(COLUMNEXISTS(Value1,Value1,null) as VARCHAR) AS Value1,&#xD;&#xA;CAST(COLUMNEXISTS(Value2,Value2,null) as VARCHAR) AS Value2,&#xD;&#xA;CAST(COLUMNEXISTS(Value3,Value3,null) as VARCHAR) AS Value3,&#xD;&#xA;CAST(COLUMNEXISTS(Value4,Value4,null) as VARCHAR) AS Value4,&#xD;&#xA;CAST(COLUMNEXISTS(Value5,Value5,null) as VARCHAR) AS Value5,&#xD;&#xA;CAST(COLUMNEXISTS(Value6,Value6,null) as VARCHAR) AS Value6&#xD;&#xA;FROM [CSVdataB]" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlImportInstructionInfo"><XmlImportInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ImportToolSurfaceViewModel" Name="CSVdataAll" Id="58aa5155-db5b-4c2a-a5fc-f002eb283916" DataSourceId="8d0931c9-4c61-4bc1-b02e-ce8cdbbe204b" DataSourceText="ME" DataSourceQuery="SELECT * FROM [CSVdataBFull]" DataSourceQueryType="1" IsDisableMacro="false" IsUncolumnized="false" UseDisk="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlInstructionInfo"><XmlInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.SaveToolSurfaceViewModel" Name="Save Database" Id="f5490819-0798-4fc4-b990-8bd287b6ac83" /></IStorageInfo></Instructions><Schedules><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.XmlSchedule"><XmlSchedule Name="Nightly update" ScheduleValue="0 0 2 1/1 * ? *" ExecutionTimeLimit="0" /></IStorageInfo></Schedules></XmlProjectModelInfo></IStorageInfo></FileSystemObjects><PublishProfiles><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Publish.XmlPublishProfileInfo"><XmlPublishProfileInfo Name="Default"><PublishStrategyInfo xsi:type="XmlSchedulerServicePublishStrategyInfo" Server="localhost:9098" OpenOutputFolderInWindowsExplorer="false" ExecuteAndFetchResultsLocally="false" DeleteAllExistingFiles="false"><Folder Id="ea108ab1-cc39-486e-9c0d-0a63a0cc8dfd" Name="Public" /></PublishStrategyInfo></XmlPublishProfileInfo></IStorageInfo></PublishProfiles><DataSources><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.DataSources.XmlCsvDataSourceInfo"><XmlCsvDataSourceInfo Id="e2f1f195-96d6-43d1-877d-cbd04b6a51c5" ConnectionString="'TARGIT.CSV.CsvConnection' 'HasHeaders=true;loadasstring=false;type=local;delimiter=,;encoding=Windows-1252;culture=en-US;detectionrowscount=100;skiplines=0;'" DefaultQuery="SELECT * FROM []" Name="CSV" Type="TARGIT.InMemory.ETL.Studio.ViewModels.DataSources.CsvDataSourceViewModel" GenerateCode="Auto" IsLocked="false" Assembly="TARGIT.Csv.dll" AssemblyType="Server" LoadAsString="false" HasHeaders="true" Delimiter=";" Encoding="Windows-1252" Culture="en-US" DataSourceType="LocalFile" DelimiterSelector="1" SkipLines="0" DetectionRowsCount="100" ManuallyChangeConnectionString="false" /></IStorageInfo></DataSources><Macros /><Synchronization IsEnabled="false" /></XmlProjectInfo>