Відео

Apart from web activity do we have any other option activity to bring Ur key vault

If csv file is hqving some columna as json structure than how to proceed?

Hi TechBrothersIT, Thanks for the Video. I have some new scenario. How to Load CSV files with more columns than destination Table. For example. If my CSV file having few additional columns which are not available in the destination table then it should skip those columns and insert data only into available columns in the Destination Table. ? Could you pls help on this

What about if the column are delimited by “/“ how to come up with a data row lengths

Hello, I have one question. Suppose I have a complex sql query. Now I want to create one pipeline where I can store the output of this sql query as parameters , so that other pipelines who will call this pipeline can use these values. How to achieve that in adf?

Hello, I have one question. Suppose I have a complex sql query. Now I want to create one pipeline where I can store the output of this sql query as parameters , so that other pipelines who will call this pipeline can use these values. How to achieve that in adf?

is it compulsory to change synchronous commit to async, instead of that suspend data movement on secondary and apply patch on secondary?

Sir, u are one of the test tutor that i found on youtube. Everytime I used to watch your videos. It really helped me throughout my career growth. I am following u since 5 years.

What would be the 'truncate script' in the 'Pre-copy script' section ? Can't get this right. I have @concat('delete from @dataset().dsTableName') but this does not work.

Nice tutorial as always. So when you run the pipeline again after adding North America you are not get duplicate value for Asia and Europe why ?

Hello, I think is not possible to set it to write mode append only ?

I see that you have not locked the Storage account behind the ptivate vnet. Is the Storage account being used over a public IP in this workflow?

Straight to the point. Thank you!

Even in 2024 these videos are the best to watch if u want to be an expert in SSIS PAKAGE DEPLOYMENTS. THANKS SIR for all this great knowledge sharing

Thanks for guidelines

Can we have the dynamically change. Like user has the access to view 20, 50, or say 100 rows in that report. Is this possible?

Does it work with Shared Folders as well? I get an error: "Exception: Cannot retrieve the next object: iterator has reached the end."

how often do you recommend backing up tlog?

You got an accent which sounds like a mix between Indian and American, where are you from?

Very Informative video, Thats the real world scenario you covered.

hi ,my ssis package is sucessfully loading data but in windows log event viewer getting message like 'package.dtsx' got failed .what might be the the reason?please help

Wonderful explained!

Can we do it without input file?

The package runs successfully but no data is transferred. Execution results says: [Flexible File Source] Error: Cannot find the file specified. But the connection manager is good and it finds all the columns.

I did exacly the same shown in the video and it worked with 17 files. Great content!

благодарю, вы очень помогли данным видео, желаю Вам всего хорошего в жизни и побольше подписчиков))

Thankyou so much🎉

Thank you!

Do we need to restart the SQL to take effect when releasing tempdb space?

nice

Bur here partition by is not applied

thank u bro

Very good work

Why fake accent

What happens if the sql server is not in same region or same resource group or subscription ?

Very helpful! Thanks a lot!

I want to store data in variable for larger file, but web activity have only 4MB limitation, please help me here

I was getting this error: The length of execution output is over limit (around 4MB currently)

Thank you so much 😀

Thanks bro this is useful.

Thanks a lot.... Badly needed this.👍

mariadb database backup and restore tutorial??

Hi, question on branching strategy discussed at 16:49 . I have seen several videos on UA-cam but I don't see a collaboration branch created off of the master branch and then create say Amir's branch. Can you tell why that is not the case? And why Amir's branch is created directly off of the master branch? There might be a possibility of two data engineers working on the same factory so it might make sense to create their own branches off of a collaboration (feature) branch. No? Thank you!

I am planning to migrate my databases from my old version of mysql (5.0 series) to 8.0 series. Is it okay to use the backup created by mysqldump? or is it more advisable to use the "Migration Wizard"?

Hi! Is it compatible to migrate my database from old version such as 5.6.23 \ 5.7.17 \ 5.7.39 \ to 8.0.37 using "Schema Transfer Wizard"? If yes, the collation of 5.0 versions are utf8_general_ci does this means it will change also to utf8mb3_general_ci?

Really great

Worst video. Please don't watch & waste your time

Not justified 🙄

Hi I written below expressions =Round(Sum(Fields!Average_Days_from_Flooring_to_Title_in_Vault.Value, "YTD") / CountRows("YTD"), 0) =Round(Sum(Fields!Average_Days_from_Title_at_Auction_to_Vault, "YTD") / Sum(IIf(Fields!Average_Days_from_Title_at_Auction_to_Vault.Value > 0, 1, 0), "YTD"), 0) Report executed successfully but am not getting the values. Please correct where I did the wrong.!

can we create schedule to copy files periodically ?