CODEWITHSUNDEEP
sql-serverssisetl
Raghu
Raghu

Reputation: 21

Transfer SQL Server Objects Task Error: Execution failed with the following error: "Invalid column name"

I am using Transfer SQL Server Objects Task in SSIS to create a package for copying procedures from prod to dev.

[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Invalid column name XYZ"

Any help on the above error will be appreciated.

Raghu

SQL Server Objects Task properties Screenshots

Transfer SQL Server Objects Task properties

Transfer SQL Server Objects Task properties1

Transfer SQL Server Objects Task properties2

Upvotes: 2

Views: 1559

Answers (1)

Hadi
Hadi

Reputation: 37313

The error is thrown because you are trying to copy a stored procedure that is using the column XYZ from a Table, and this table is not copied or not found in the destination database.

Also From the screenshots, you are not copying Tables from the Source Database. ('CopyAllTables` property is False) , So make sure you choose all related tables to the stored procedure to be copied to the destination database

Upvotes: 1

Related Questions