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.
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.
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.
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.
how you load multi excel file in this video ...I not found permission to load excel file to sql server pla..explain this step
Thank you so much for taking the time to make this video. Good Job!
Glad you liked the video. Thanks.
Thank you for sharing. Very useful.
You are welcome Rita.
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.
You would need to make the flat file connection manager dynamic. Take a look at this video
ua-cam.com/video/BjpaSxMZMxs/v-deo.html
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.
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 ?
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.
@@learnssis Got it.Thank you Sir!!
@@HarshaV44 No problem.
Can you please explain best practices to implement any SSIS Project?
thank you
You can take a look at these 2 videos on the same topic
ua-cam.com/video/3pacxWeTce4/v-deo.html
ua-cam.com/video/7sKEgm2uQEM/v-deo.html
Very useful
Keep going please
Thank you Yassine.
Can we keep breakpoints in Data flow also, is it possible ?
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.
Hi aqil nice to see see you posting new videos ...please share some real time scenario videos
Sure Amit, will share some real time scenario soon. Thanks.
Hi dear nice video... Can u share migration ssis videos
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.
@@learnssis Thanqsomuch 👍
that's more great if you have subtitles
Yes, you are correct. I will work on it.