SQLTeam.com | Weblogs | Forums

SSIS / I am wanting to replace each day with new data

Message
Executed as user: FULCRUM\jhardy. Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 08:00:02 Error: 2021-09-29 08:00:03.96 Code: 0xC002F210 Source: Preparation SQL Task 1 Execute SQL Task Description: Executing the query "CREATE TABLE [dbo].[Beboc] ( [Patch] varchar(4), [..." failed with the following error: "There is already an object named 'Beboc' in the database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 08:00:02 Finished: 08:00:03 Elapsed: 1.14 seconds. The package execution failed. The step failed.

CREATE TABLE [dbo].[Beboc] ( [Patch] varchar(4), [..." failed with the following error: "There is already an object named 'Beboc' in the database.".