06 How do I archive files in SSIS

[@amitkdhal9961]

Thank u Aqil really happy to see you accepting my request and posting the scenario...your way of explanation is superb

[@learnssis]

Glad to know that you liked the video.

[@yohannesareda901]

This is very useful information. Thank you Sir!

[@learnssis]

You are most welcome.

[@saiabhilash3151]

Bro ,Thanks for all patience you have to provide series on Ssis 🙏🙏.But only suggestion i ask is please avoid using script task where ever possible or please make one more video how to do same task without using script task and add link in comments .As u know script task has its own flaws and not every developer has knowledge on c sharp .

[@learnssis]

Thanks for your suggestion, yes wherever possible we should avoid using script task, I just given an example that it is also one way to do this. Using file system task you can do this like below kzbin.info/www/bejne/f5PMlnd3ltmZa68

[@MVinodKumar-tt1tu]

Hello Sir, Is there any videos available on C# to learn sir. To get some basic or intermediate knowledge?

[@learnssis]

Hi, I don't have the C# videos on my channel but you can find plenty of them on youtube from other creators.

[@deepthinandyala8754]

Hi Akhil, How to make copy of table .if we are getting data in tables like archiving files in SSIS

[@learnssis]

In this video you can see how to make copy of table. kzbin.info/www/bejne/eWnXfXiJZqd7g5Y

[@danialilyasak3941]

Hi thank you for your sharing. I have question, what if I also want to rename the file that I want to archive with date?

[@learnssis]

Hi, In the below line you would need to change the code, string DestFilePath = ArchiveFolderPath + "\\" + FileName; Instead of Filename, you would need to provide the new file name.

[@triveninalabothu9094]

Can we use File System task to move file instead of Script task

[@learnssis]

Yes we should always use File System task to move the files from one location to another location. It was my bad that I used script task to move the files. Here is the video how you can use File System task to move the files. kzbin.info/www/bejne/f5PMlnd3ltmZa68

[@learnssis]

There is one more thing, if you are using file system task to move the file to archive folder, then you can just declare an ssis variable ArchiveFolder and provide it a valid folder path and then you can use that variable in the destination variable inside File System Task.

[@HarshaV44]

very helpful.. Thank you

[@learnssis]

Thanks Harsha Vardhan.

[@priyankaadhikari8235]

Hi Aqil, thank you for all your SSIS related videos. Can you please make a video on how to do unit testing of SSIS packages/ how does a developer test ssis package?

[@learnssis]

Thanks Priyanka. I have created few videos on debugging your SSIS packages which can be found here which might help you kzbin.info/www/bejne/kGjThoGifq6MiJY kzbin.info/www/bejne/Z4CwcoGHndSAh68 kzbin.info/www/bejne/bpSvdniZab-gkJo kzbin.info/www/bejne/noezfIJpfNCKrq8

[@sumaa2344]

Excellent tutorial. Please share the msbi installation steps . Is SQL server 2014 developer edition enough for msbi practice or any other tool required . Please help me

[@learnssis]

Thanks for your comment. You need SQL Server Developer edition and SQL Server Data Tools 2013 for the development of SSIS packages. I have made videos on both of the above topics 1. kzbin.info/www/bejne/fovapHWQf9mNj8U 2 . kzbin.info/www/bejne/i3bRlYl4msuBmLc

[@VijayKumar-iu7xu]

why file system task was not used to archive files ?

[@learnssis]

We can use either File System task or Script task to archive the files. I just used Script task in this example.

[@alexching8912]

hi Everybody, I have encounter this error "Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors." how can I resolved it

[@learnssis]

There should be more details of error. It is a generic error message.

[@Fyvics82]

Good job

[@learnssis]

Glad to know that you liked the video. Thanks.

[@ankushkale616]

Q: as a developer how to send our packages to tester for testing and how tester will send us packages for chenge back to developer please answer me Q: in which stage we decide is it new data or old data i mean whether it is in etl-staging--ods

[@learnssis]

Hi Ankush, thanks for question. Answer to both of your question differs company to company and project to project. A. Sometimes QA do not look at SSIS package at all, they just look at data. However still you want to send them the package. Just Zip whole Solution Folder and send it to QA. Similar way they can follow as well. Second time may be you can send just the .dtsx file to them and they can replace the old .dtsx file in their old solution with the new one. A. It depends project to project. Sometimes if possible we can fetch the new\modified data from source itself and while loading to staging tables we can decide if the data is new or updated. Similarly we can also decide from staging to ods if data is new or modified, its purely depends of the type of project and requirement. Thanks.

[@kannanramakrishnan4814]

Nice video

[@learnssis]

Thanks for your comment.

[@dilipkumar-ck1nc]

Please provide the code in notepad

[@learnssis]

I have uploaded the code to the google drive.