10 Debugging SSIS Packages | SSIS real time scenarios

[@anilchoubey7155]

Thank You very much for this informative video, keep it up

[@learnssis]

Thank you Anil.

[@sqllearning-tamil-sqltutor9933]

Could you please explain the use of delay validation? If any lecture video, particularly for this concept

[@learnssis]

Delay validation property is used by SSIS to authenticate the exitance of objects inside the package. For example if a table abc is used inside the ssis package specially in the data flow task and if the Delay validation property of package is set to false (by default it remains false) then the ssis package will try to see if abc table exists inside the database or not, if table does not exists inside the database then the ssis package will fail before starting it. However if you set the delay validation property of ssis package to true, then ssis won't check for the existence of table and it will start as usual.

[@mkh9954]

Thank you so much for this nice tutorial, it has helped me a lot to learn about package debugging. Great job keep it up 👍💕

[@learnssis]

Good to know that you liked the video. Thanks.

[@SudhirKumar-ms9cj]

Very nice and informative presentation.

[@learnssis]

Thank you Sudhir, its good to know that you liked the video.

[@alexrubin5955]

Hi Aqeel. Do you have the videos from 03 to 09 in this series?

[@learnssis]

Yeah if you check the description of each video, you can find the link to playlist and you can find all videos in the playlist.

[@radhapatel1260]

*Aqil Sir I've a question, I've a text file and already have some record in it, and now I want to get import records from SQL Server table but I want append data in that text file, I mean I don't want to loose any already existing records/data in text file* Thank Aqil Sir

[@learnssis]

In the flat file destination, just before the connection manager option, there is a check box "Over write data in the file", you need to uncheck that option. You can see the image at below location drive.google.com/drive/u/1/folders/1xqRUT4mYdxW5QmZ4jwx0HwDbQCGXOolU

[@radhapatel1260]

@@learnssis *cardialy great and your video is truly excellent after watching your 10-15 lecture I qualified first round of SSIS interview, they mainly asked data flow vs control flow, and what's event handler etc. And I was able to answer because you've already made these videos. Thanks for your reply Aqil Sir from Banaras India*

[@learnssis]

@@radhapatel1260 So glad to know this. All the very best.

[@SurajGupta96]

can you help me with this error :- 'The step did not generate any output. The return value was unknown. The process exit code was -1073741502'. Since debugging the package didn't find any issue. This run as SQL agent job.

[@learnssis]

Here the error msg is not fully generated. With this information I don't know what actual reason might be behind the failure of the sql job, sorry man.

[@SurajGupta96]

@@learnssis no problem man, this is the only thing i able to identify, i found this link docs.microsoft.com/en-us/archive/blogs/dataaccesstechnologies/ssis-package-fails-with-error-the-step-did-not-generate-any-output-the-return-value-was-unknown for this error and done as per suggested in article and yes it's work but after running 3-4 times it's again started failing...hope i find any other ways.

[@GovindDeepakKumar]

Sir few videos are missing in this playlist can you please add them

[@learnssis]

Which videos are missing Govind ?