SSIS Data Tools for SQL Server 2014 (none of vb.net script tasks are working, even with default code)

Question

I have installed SQL Server 2014 Data Tools. When I add the script task and use C#, it work. But when I add script task and choose vb.net 2012, and then clicked on edit script and save.

After that click ok and getting this error message for all scripts, please note that I have not even added vb.net code yet.

scripts contained in the package have compilation errors. do you want to save changes?

Any help is highly appreciated.

Don't think you can mix languages like this in a project. Maybe someone else has some better insight. — Jacob H, Jan 10 '18 at 14:26
sorry, I am not mixing but trying to code using vb.net 2012 in SSIS 2014 data tools but none of the scripts are compiling, even with skeleton code (generated by the wizard) — user3577355, Jan 10 '18 at 14:43
Thanks Tab and Jacob, I am only getting this error "scripts contained in the package have compilation errors. do you want to save changes?" — user3577355, Jan 10 '18 at 16:47
Is your SSDT2014 install an upgrade to a previous version, or a fresh install? — digital.aaron, Jan 10 '18 at 18:19

score 0 · Answer 1 · answered Jan 11 '18 at 15:42

0

Thanks everyone, I reinstalled SSDT and now all vb.net scripts are working.

answered Jan 11 '18 at 15:42

user3577355

11
1

SSIS Data Tools for SQL Server 2014 (none of vb.net script tasks are working, even with default code)

1 Answers1