CODEWITHSUNDEEP
sql-serverssisbusiness-intelligence
Elad L.
Elad L.

Reputation: 639

SSIS truncate table error

Hello I'm new to SSIS and BI. I'm trying to create a dimension and and the beginning of the work flow i want to truncate my Staging table. fr some reason this is throwing an error i cant seam to get passed. any help would be great thanks.

enter image description here

enter image description here

enter image description here

Upvotes: 1

Views: 466

Answers (1)

DatabaseCoder
DatabaseCoder

Reputation: 2032

According to your error description, you are trying to set "Execute SQL" task "Name" property. Please check "Execute SQL" task expressions again. I am able to reproduce same error - check below snapshot.

enter image description here

enter image description here

SSIS objects name can't contain these characters - /:[].

New Snapshot after removing special characters from "Name" expression, it works after that - enter image description here

enter image description here

Upvotes: 2

Related Questions