administrator
/
executaveis
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
main
antes-bug-emails
correcao-bug-emails
dotnet-9
spa-oidc
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
executaveis/GCI/Dependencias/GecondSync
History
Hugo Prata 0e5a81af24 GecondSync 4 years ago
..
ContaSync.dtsx GecondSync 4 years ago
GecondSync.dtsx GecondSync 4 years ago
README.txt GecondSync 4 years ago
TriggerGecond.ps1 GecondSync 4 years ago

README.txt
Unescape Escape

This file contains invisible Unicode characters!

This file contains invisible Unicode characters that may be processed differently from what appears below. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to reveal hidden characters.

Corrigir o erro dos linked server:
alterar o servico SQLSERVER (services.msc) para correr como uma conta local (administrator caso exista, se der erro o utilizador logado). Restart dos servicos.


executar no sql server 1 vez:

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE;


acesso ao integration services denied:
https://www.mssqltips.com/sqlservertip/6236/connecting-to-integration-services-access-is-denied-in-sql-server-2016-or-2017/


C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\MappingFiles\JetToSSIS.xml

<!-- 130 -->
<dtm:DataTypeMapping >
    <dtm:SourceDataType>
        <dtm:DataTypeName>130</dtm:DataTypeName>
    </dtm:SourceDataType>
    <dtm:DestinationDataType>
        <dtm:CharacterStringType>
            <dtm:DataTypeName>DT_WSTR</dtm:DataTypeName>
            <dtm:UseSourceLength/>
        </dtm:CharacterStringType>
    </dtm:DestinationDataType>
</dtm:DataTypeMapping>



C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\MappingFiles\MSSQLToSSIS10.XML

<!-- 130 -->
<dtm:DataTypeMapping >
    <dtm:SourceDataType>
        <dtm:DataTypeName>-1</dtm:DataTypeName>
    </dtm:SourceDataType>
    <dtm:DestinationDataType>
        <dtm:CharacterStringType>
            <dtm:DataTypeName>nvarchar</dtm:DataTypeName>
            <dtm:UseSourceLength/>
        </dtm:CharacterStringType>
    </dtm:DestinationDataType>
</dtm:DataTypeMapping>


C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\DtwTypeConversion.xml

  <!-- Convert from DT_WSTR-->
      <dtw:ConversionEntry>
        <dtw:SourceType>130</dtw:SourceType>
        <dtw:DestinationType TypeName="DT_NTEXT">
          <dtw:ConversionStep StepNum="1" ConvertToType="DT_NTEXT"/>
        </dtw:DestinationType>
      </dtw:ConversionEntry>