@@LearnWithMRajput Yes, but can you please do a video. I searched a lot on youtube but I did not find one. It could be helpful for someone if you do it so.
@Ahmed...first of all sorry for replying you so late..see in data import you cannot have multiple transformations funationality that you can have in SSIS , you can transform your input data into your desired format and then load while in data import you can't have that flexibility
Thanks for this! very helpful!
Glad that you like it
Can you explain on... How to import multiple csv files with different columns into SQL server?
You can use script task to write custom code and add for loop to do this.
@@LearnWithMRajput Yes, but can you please do a video. I searched a lot on youtube but I did not find one. It could be helpful for someone if you do it so.
Can you please tell me why we use SSIS instead of data import
@Ahmed...first of all sorry for replying you so late..see in data import you cannot have multiple transformations funationality that you can have in SSIS , you can transform your input data into your desired format and then load while in data import you can't have that flexibility
@@LearnWithMRajput thank you 😊