actually it in synapse .. the pipeline pushes fresh data into tables.. we are pushing data into synapse ..

Thanks @PRADEEPCHEEKATLA-MSFT for the solution..

Thanks @SaurabhSharma-msft .. this solution has worked for me ..

tell me if is there any way to do this using notebooks .

Hi @Sumarigo-MSFT Your answer is helpful to us .. Thanks for Solution ..

Hi @SaurabhSharma-msft and @VaibhavChaudhari yes i have checked on suggestions provoided by you people .. we were to solve the error after correcting the schemas ..

Thanks @VaibhavChaudhari and @SaurabhSharma-msft .

Hi @bharathn-msft we are verifying on above information that u provided once we done testing from our side .. will let u know .. thanks for help

Yes @VaibhavChaudhari i have followed those steps but getting below error ..

could u please tell me why i m facing this error.

Hi @RichMatheisen-8856 now i understood about the device cal's and user cal's.

Actually my requirement is like this the users who haven't logged in into system from last 30 days their access should be revoked .. they should get an email like "as u havent logged in into system from last 30 days so your access is revoked."

How can i accomplish this one with simple script .. please provide me with some commands on how to do this ..

Regards,
Rohit

Thanks to @VaibhavChaudhari and @HimanshuSinha-MSFT ..

Hi @HimanshuSinha-MSFT,

Thanks for commands you provided .. I Checked those commands but for directory it is not showing size .. please see attched screenshot ..

as u can see in the screenshot it is not showing directory size ..

how can i get that ?

Regards,
Rohit

Hi @deherman-MSFT Thanks ..

I have run those commands and i can see file share in powershell and i was able to do "cd Z:" as well ..

But my question is like - Why it is still not showing in "ThisPc" where as i was able to see in powershell .. i have also checked in Network location folder but i was not able to see file share there ..

I would also like to know what is below Warning Message :

warning : Ping to .file.share.windows.net failed --status: Timedout**

Why this warning message is coming up ?

Regards,
Rohit

Hi @KranthiPakala-MSFT run pipeline as u suggested but still not able to copy emprty folders to destination.. if folder contains files then only it is getting copied ..

Thanks & Regards,
Rohit

Hi @HimanshuSinha-MSFT My source and destination both are adls gen2 only .. but we store our sql tables in adls gen2 ..

so i am copying sql tables in source adls to destination which is also adls gen2 ..

what would be its behavior append or overwrite ?

Regards,
Rohit

Hi @HarithaMaddi-MSFT using this approch i can delete the container by specified days but my ask is like how can i identify that the particular container is autromatically created by informatica ..

my requirement it should only delete those automatically created containers only .. all containers that are created have some specific pattern like
"(----------)/-(-----)/-(----)/-(-----------)" ..

Is there anyway to match container names and then deleting them.

Action item:
1)Finding the containers which are in that specific pattern
2)then filtering them out with modified date
3)deleting containers that we got after filtering.

Could u please help me on achieving this requirement.

Regards,
Rohit