How can we help you today? How can we help you today?

Azure pipeline cannot find seed data txt file to deploy on azure sql using redgate deploy automation

I'm running a redgate deployment task  on my azurepipeline (RedgateSqlChangeAutomationRelease@4) to deploy my nuget package file on azure sql database Elastic pool but I'm getting the error: 

Cannot bulk load because the file "C:\Users\VssAdministrator\AppData\Local\Temp\DLM Automation\djirrmiq.kal\Seed\DataDictionary.txt" could not be opened. Operating system error code (null).
##[warning]RedGate.Versioning.Engine.Core.DatabaseInteraction.ScriptExecution.Exceptions.DeploymentException: An error occurred during script deployment. Output from SQL Server follows.
---------------------------------------------------------------
Msg 4861, Level 16, State 1, Server usndtaxidmsql01, Line 1
Cannot bulk load because the file "C:\Users\VssAdministrator\AppData\Local\Temp\DLM Automation\djirrmiq.kal\Seed\DataDictionary.txt" could not be opened. Operating system error code (null).
---------------------------------------------------------------

I have in my migration directory an .sql file with the:
BULK INSERT [Core].[DataDictionary]
FROM '$(DeployPath)Seed\DataDictionary.txt'  
WITH (FIELDTERMINATOR = '|', FIRSTROW = 2);
GO

also in my project I have set:
  <ItemGroup>
    <Folder Include="Seed" />
  </ItemGroup>
  <ItemGroup>
    <None Include="Seed\DataDictionary.txt">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    </None>
  </ItemGroup>

During pipeline build redgate I can see the file being copied:

##[debug] Copy: Creating directory "bin\Debug\Seed".
##[debug] Copy: Copying file from "D:\a\1\s\EY.Raptor.Forms.Efile\EY.Raptor.Forms.Efile.EFileCatalogDB\Seed\DataDictionary.txt" to "bin\Debug\Seed\DataDictionary.txt".

I'm following this documentation: https://documentation.red-gate.com/sca4/developing-databases/working-with-the-visual-studio-extension/advanced-scenarios-for-visual-studio/using-seed-data-in-visual-studio

Any ideas to share are really appreciated. 

Thank you
Luis
ldelpozo
0

Comments

1 comment

Sort by
  • Pete_Ruiz
    @ldelpozo

    Hello Luis,

    A support ticket has already been opened for this issue by your colleague Pablo Lin. Ticket reference is 271393.

    It appears that the agent is unable to access the local path. We recommend using a hosted agent and adding the file to the Azure repo.

    Please let me know if this helps or if you have any questions.

    Pete Ruiz
    Product Support Engineer
    Redgate





    Pete_Ruiz
    0

Add comment

Please sign in to leave a comment.