ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
94 How to move files from one folder to another using SSIS | File System Task in SSIS
ฝัง
- เผยแพร่เมื่อ 12 ม.ค. 2022
- how to move files from one folder to another using SSIS
Download the file\script used in the Video from below link
drive.google.com/drive/folder...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
how to move files from one folder to another using SSIS
How do you move all files in a folder to another folder in SSIS?
How do I move a file system task in SSIS?
How do I copy files in SSIS?
How do I move an archive file in SSIS?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”
Very good job in the explanation, and the google drive for providing the files is awesome. Thank you...
You are most welcome eagleandwings.
Really helped thanks for the simple explanation
Thank you Shubham.
Perfect, thank you
Thank you Magaba.
Your videos are great 👍.
Thank you Mery.
Hi, Could you please tell the scenario like, need to some validation on the data in the files, if the validatio fine then data can be inserted into sql server table and after insert, file will move to arhive folder. else file will be moved to error folder
Hi, Can you take a look at below 2 videos, I have done almost same thing but in 2 different videos
th-cam.com/video/l7nqLfhOwkI/w-d-xo.html
th-cam.com/video/qH_R2jWGPBA/w-d-xo.html
Do you have a video on how to move file from one location to sharepoint? Thanks.
Hi Manu, in SSIS there is no inbuilt component to upload the files to sharepoint, you would need to use C# to upload the file from local machine to sharepoint.
th-cam.com/video/VhbDHAT-oic/w-d-xo.html
Hi Brother .. I need to transfer file from an azure blob container to a shared drive path/local and i need to automate the process. It is like if a file with name xxx exists in a blob then move it to a path and archive it and if the same file already exists then just delete it. Put it in a scheduler and run this say in every 5minutes.Can it be done using SSIS and if we can then how? I would appreciate your reply
You can use AzCopy to download the files from Azure blob container to local. I have used AzCopy to upload the files from local to Azure blob container for one of my office project, the download should also work the same way
docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy-files
Before downloading a file in script task you can delete the file from local if file already exists
if (System.IO.File.Exists(FilePath))
{
System.IO.File.Delete(FilePath);
}
@@learnssis Thanks brother ..how ever I have a silly doubt . Where and how can I exactly use this command lines to copy or download in a SSIS data flow task ? I mean which ssis component should I use for this ?
@@debasishpadhi1837 You would need to use Execute Process Task
th-cam.com/video/4sMp3AD3pik/w-d-xo.html
@@learnssis Thanks a lot again brother 🙏
What if we don't have any CSV file in the source folder , how to handle this situation
If we won't have any CSV file in the source folder then the SSIS package won't do anything.
@@learnssis In my case it is throwing error "file name (which you have in source file name variable) doesn't exists"
@@crashdigest I tested it again. We are using a Foreach loop container in this case, thus if a file won't exists it won't go inside foreach loop container and thus it won't fail.
If my destination folder is dynamic than what I have to choose destination folder
We are using DestFolder as an SSIS variable in this example, thus if the value of DestFolder will change then it won't affect anything as the variable can be updated to new value at run time.
Can u help me in preparation of ssis package for moving of files from source location to archive location after retension period.
Thanks in advance.
What is retention period ?
@@learnssis means after 3 months
Hello… I use Visual Studio Community 2017 and created a container with a foreachloop to process multiple excel files 97-2003, once processed they get moved to another folder in SharePoint. The first time executed the files in my machine it went through successfully, but then the overnight EDW auto-refresh failed with the following error:
The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the driver is not installed, run the package in 32-bit mode.
Can you please guide me on how to solve this issue? I keep looking for online support documents and cannot find anything clear on to solve this issue. Thank you in advance!
From the Solution explorer, right click on Project name, go to properties. Expand the debugging, Set Run64BitRuntime to False
@@learnssis Still getting the same error. I have set the Excel Source properties to ValidateExternalValidation to False, Excel Connection DelayValidation to True, and Debugging Run64Runtime to False.
Hi Ahmed can pls share the destination folder expression statement
Actually you don't need to provide the expression, just give the folder path in the destination ssis variable. Just folder name will work, no need to append the file name to the folder name.
Can i make the source folder variable?
yes you can make that.
I'm getting error in Expression I used your expression only but facing issue
My files contains date I want to move every month how to do
Attempt to parse the expression "@[User::Destination]+"\\"+RIGHT( @[User::Sourcepath].FINDSTRING(REVERSE( @[User::Sourcepath]).
"\\".)" failed. The token "." at line number "1", character number "53" was not recognized. The expression cannot be parsed because it contains invalid elements at the location specified.
@@Listener-mh9ky you just need to provide the folder path in destination file path, it will work. Just provide the destfolderpath ssis variable and it should work.
I am getting error can u help me
Can you please share the error message ?
Make sure to give the FolderPath SSIS variable inside "DestinationVariable" property. FolderPath should contain the destination folder path.