Annette Wilson, MSIS
asked on
SSIS Odata Connection to SQL Server Table - Duplicating Records
I have an SSIS package in Visual Studio 2019 that uses an ODATA connection to pull data from one database and update a table in another SQL Server database.
An SQL Server Job runs every 5 minutes to execute the package but duplicate data is being populated.
How can I stop the data from duplicating?
Do I need the SQL Server Job to run this package that has been deployed to the SSIS Service Catalog?
An SQL Server Job runs every 5 minutes to execute the package but duplicate data is being populated.
How can I stop the data from duplicating?
Do I need the SQL Server Job to run this package that has been deployed to the SSIS Service Catalog?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.