59 Breakpoints in SSIS | how to use breakpoints in ssis

[@brentgroves7605]

Thank you so much for taking the time to make this video. Good Job!

[@learnssis]

Glad you liked the video. Thanks.

[@ramakrishnap2645]

Thank you. when i execute the package it is loading the same csv file as i placed in flat file source. also in for each loop container i put *.*. finally it is loading the same file again and again on iterating over it.

[@learnssis]

You would need to make the flat file connection manager dynamic. Take a look at this video kzbin.info/www/bejne/eJvTkoaugr-ArtU

[@ritawalsh7488]

Thank you for sharing. Very useful.

[@learnssis]

You are welcome Rita.

[@RajeshChavan-pg8mt]

Can you please explain best practices to implement any SSIS Project? thank you

[@learnssis]

You can take a look at these 2 videos on the same topic kzbin.info/www/bejne/aaHElKuNmrmWm5Y kzbin.info/www/bejne/baSudpqjZ9qEe68

[@anandmiryala4901]

Can we keep breakpoints in Data flow also, is it possible ?

[@learnssis]

No we can't put breakpoints in data flow. To check the data flowing from source to destination in data flow we can use data viewer.

[@ExonaQ]

Very useful Keep going please

[@learnssis]

Thank you Yassine.

[@HarshaV44]

Hi Sir, while trying for each loop container package is keep on failing.Could you please help me out? [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source returned error code 0xC0202091. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

[@learnssis]

Hi, it seems like there is some issue with the CSV file you are trying to load. Are you able to load the file without putting a breakpoint ?

[@learnssis]

I have replied to you on email as well. Either put *.csv in the foreachloop container file type configuration or put only the csv file in the folder that you want to load because right now it will try to load all files in the folder if file type is given as *.* Currently it is trying to load a sql file into the sql table, that's why it is failing.

[@HarshaV44]

@@learnssis Got it.Thank you Sir!!

[@learnssis]

@@HarshaV44 No problem.

[@amitkdhal9961]

Hi aqil nice to see see you posting new videos ...please share some real time scenario videos

[@learnssis]

Sure Amit, will share some real time scenario soon. Thanks.

[@sureshareti2843]

Hi dear nice video... Can u share migration ssis videos

[@learnssis]

Thanks Suresh for your comment, yeah it is a good idea to record some videos on migration. I will make a note of it and will make sure I record some videos on this area as well.

[@sureshareti2843]

@@learnssis Thanqsomuch 👍

[@phunghong3803]

that's more great if you have subtitles

[@learnssis]

Yes, you are correct. I will work on it.