SSIS Tutorial Part 111-SQL Statement Size Limitations in Execute SQL Task & Solution in SSIS Package

In this video we will be learning the limitation on length of SQL Query that we can use inside the Execute SQL task Editor.

Also we will be learning the different ways how to handle such situation when we really need to have all the script together in one query and the length exceeds from Execute SQL Task Editor limit.

Blog post link for the video with scripts

Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers

[krismaly]

Revisiting

I enjoyed watching this video and recommend others.

Host explained
1. Max lenght of SQL statement that SQL Editor limitation in SSIS
2. Explained how to resolve the problem
3. Also advantage of using Stored procedure in SSIS package

Thanks for educating the community and appreciate your volunteership.

Thanks a bunch

[krismaly]

I enjoyed watching this video.

Explained the functionality in detail.

I wish you should have turned on Line Numbers on SSMS Query Editor so that users could see how many lines of code.
Anyways you found the length with LEN function that explains them.

Suggest you to make make step by step way to explain

Thanks for educating the community and appreciate your volunteership.

[Servant]

32, 767 Char-rectors in the editor for Execute SQL task