Can you please cover a video about 'set statement' and its usage?

Hello TechBrothersIT, Issue while exporting in CSV format In my SSRS RDL file, I have parameters reporttype Summary and Detail, and I have summary and detail tablix, which run report with the report type summary that time report load, but when I export report with CSV format that time in the showing both summary and detail data. When I select reporttype Summary, then export the report in CSV format, it shows only summary data, not detail data. I need argent solutions. Thank you.

Thanks!

This is Amazing... Thanks for covering the nuances.... I have 1 question -- The 9th question -- adding 2nd node... If 1st node utilizes 70% of CPU... What is Node here.... I was assuming the CPU -- either in virtual machine or the on-premise is the Node... What is the difference between CPU and Node... ... Thank you...

Thanks sooo much! super easy to follow and straight to the point. That nugget of info to copy into google for file information was exactly what i needed. No longer will I be right clicking and copying the file name for each document.

Thank you!

Thanks for this. Why did you both select a VNet for Azure-SSIS IR and use a self-hosted IR as a proxy? According to MS documentation article "Configure a self-hosted IR as a proxy for an Azure-SSIS IR", the proxy IR is an alternative to joining the Azure-SSIS IR to a VNet, which you might need if "your corporate network has a configuration too complex or a policy too restrictive for you to inject your Azure-SSIS IR into it". I'm here because I am having trouble starting my Azure-SSIS IR after locking down my Azure SSISDB to private endpoint only, even though I have always been able to access other resources on my organization's VNet from SSIS packages via injection of the Azure-SSIS IR into the VNet. Can you help me understand if I need a proxy IR or not?

Thank you for help

Not working

how to convert sql query of a ssis packages in to data databricks notebook

Thanks for your help. I am facing an issue with the file name. There has to be always that file in the folder which you provided in the FilePath. I am getting on the next run if the file is archived. Can you please help?

perfect can you please Do the latest version

Thanks very helpful

How do I send stored procedure output in a email body in SSIS package

Respect brother thanks

Thanks, helped a lot. With the new version of Azure data factory (Jul 2024) this method needs a little tweak. Adding dynamic content from dropdown or GUI does not work anymore. Instead one as to enter a string example .pipeline().parameters.<parameter_name>

Great !!! Your video really amazing. I have one question,could you please help me to resolve. Actually want to develop a SSIS package for importing Customer where the data is provided from multiple flat file sources. The customer primary data like customer id, name from one file and address information from different file source. The customer address data also contain multiple address information for each customer. need to get the latest customer information and merge it with customer primary data and import it into destionation customer table. How to design such a logic and it must be recent customer infomation is imported ? Please explain by drawing a diagram.

God bless you. You just saved my day. Although not the exact solution... all I needed was how to convert my project from ispac back to dstx.

The way you talk is so irritating and distracting … but good content for SSRS startup

Your videos are amazing. I learnt a lot from you. By mistake, you removed unique records too. It's wrong bro. If there are 6 records, 5 records are duplicate then one must be unique. But, in this video you are considering 6 records as duplicate. Can you please make another video and delete this video.

its a shame there is no option to rename schema in workbench, but your work around is brilliant approach -- can we also do this for view, sp, functions etc..

Hi sir. Can we disable manual entry at calender picker text box? I mean user can't write anything in the box only they can pick date from the calender. Is it possible?

Thanks for nice explanation Brother, Please plan videos on SSAS tutorials and project/Cube deployments

Thank you for this video. One imp question, how do we handle if the target table has columns with different names.

I can't see versions except 5.8

This code is great but it is not working if there is any sub folder in the drive. Is there any solution for it?

Very uueful contents👍

thank you for the video, i have a question , will it run daily?

PERFECT EXPLANATION, BE IT UR VIDEOS OR INTERVIEW EXPLANATIONS ARE SUPERB. THANKS

If u want extra columns as well then

Hi, how to publish the report if you want to be true for details parameter while deploying the report.how to do it. And replicate in browser

With this can I go and take the MYSQL 8.0 oracle database administrator exam?

Not provided key is this not a enterprise edition, also didnt see the screen of selecting edition

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."