16 File System Task in SSIS | How to use File System Task in SSIS

File System Task in SSIS | How to use File System Task in SSIS
Download the file\script used in the Video from below link
drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
File System Task in SSIS
How do I move a file system task in SSIS?
How do I move files to a folder in SSIS?
How do I copy files in SSIS?
What is Execute SQL task in SSIS?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@taniali131]

Merci merci ce gentil vous avez fait simplement et rapide avec qualité même aussi

[@learnssis]

De rien.

[@pavankulkarni9952]

Simple explanation at its best..good work mate..thanks

[@learnssis]

Thanks Pavan for your support.

[@kivisatedomotoji5956]

Thank you so much. very helpful

[@learnssis]

You are most welcome.

[@anirudha_wellwisher]

Hi Aqil , I have query regarding Move Files in File system task. I have a package in that i have certain operation but at last i want to move file to particular folder through move file operation but everytime my only Move File FST failed with Error message "Could not find the file _________.csv". What i need to do in this situation ??

[@learnssis]

If you have the file path in an ssis variable then you can easily move the file using operation as move file and from the source variable select the filepath ssis variable and in the destination file path select the folder path. kzbin.info/www/bejne/f5PMlnd3ltmZa68

[@vanimalge9070]

Hi i need help in variables , can you please tell me how to get the date in format of yyyy-mm-dd for the first day of the month like for any day in january my variable should return 2019-01-01 or for any date in feb my query shud return 2019-02-01

[@vickypatekar9532]

Sir Please make vedios in Hindi also as it understands very easily. Thank you

[@learnssis]

Sure Vicky.

[@hiteshparab8512]

Hi sir, It is so helpful video. One small request can you have pdf of all these tutorials in one document ,It will be very helpful and greatful. If it is chargeable I am ready to pay the same

[@learnssis]

Thank you. Yeah good suggestion but it will be a lot of work to write everything. May be I can think to get this done by someone.

[@vitto_af]

Hi, Have You got any vídeo about ftp task with path variable ?

[@learnssis]

Sorry I don't have access to an FTP server, thus I did not made any on it so far.

[@vanimalge9070]

where can i see the video to rename a file after copying it in the desired destination

[@learnssis]

Hi Vani, in this video, I have used second File system task to Copy a file from source to destination. So you can use 3rd File System task to rename a file. Instead of Copy file operation, select Rename file operation, and provide the current path of file in source source, and provide the new file path after rename, inside destination connection.

[@vanimalge9070]

@@learnssis Actually my requirement is to 1. copy abc.csv from one place to another folder name Archive and thats done 2. is to go in the archive and rename the abc.csv to like abc_todaysdate.csv(this i should be dynamic) . So for 1. i have used one file system task next how to do the rename thing im lost

[@learnssis]

This kind of thing like renaming a file and appending current date value to it, I normally do it in C# Script Task. 1. Declare a variable FilePath as a string SSIS variable, assign current file path to it, like "D:\data\ABC.CSV" 2. Drag and drop Script Task to Control Flow 3. Right Click on it | Edit, provide FilePath under Read only variables 4. Click Edit Script 5. Expand Namespaces and add "using System.IO;" 6. Inside Main method, add below code // TODO: Add your code here DateTime dt = DateTime.Now; string s = dt.ToString("yyyyMMdd"); string sourceFile = Dts.Variables["FilePath"].Value.ToString(); string ShortFileName = Path.GetFileNameWithoutExtension(sourceFile); string dest_direc = Path.GetDirectoryName(sourceFile); string DestFile = dest_direc + "\\" + ShortFileName + "_" + s + ".CSV"; //If CSV File exists in Archive directory then delete it if (File.Exists(DestFile)) { File.Delete(DestFile); } //Move CSV File to Archive directory if (File.Exists(sourceFile)) { File.Move(sourceFile, DestFile); }

[@vanimalge9070]

@@learnssis Thank you so much

[@ladhkay]

Why use this instead of just creating a new folder and copy pasting the courses file?

[@learnssis]

We are doing 2 operations there, creating a new Folder and then copying the file to it. Do you want to say that we can use other methods to create a folder and copy file. Sorry did not get you.

[@learnssis]

I think you might be thinking that instead of writing code for this, we can manually do this thing. This is fine for one time task, however think of a project, where on daily basis we receive some files in a source folder, and our requirement is that after loading those files we need to move the source files to a different folder (Archive folder) so that those files should not be processed again OR they don't want old files to be staying in source folder, so in that kind of scenario there should be some automated code which can do this kind of thing (moving files from one folder to another). And suppose the requirement is that processed files should be moved to each months folder. For 2018 there will be 12 folders and each months folder will be containing files for that month only, so all this thing can be automated using SSIS.

[@nabeelyaseen9447]

Thanks, Simple and good explanation. How can i move a file from source directory to destination directory ?

[@learnssis]

Its good to know that you liked this video. In below video I have shown how to move file after processing kzbin.info/www/bejne/iIe1cqh8jNeAmac

[@PavanKumar-nh5fe]

bro your explanayion topic wise is very ,uch good but a lot of things you said are not working bro

[@learnssis]

Hi Pavan if I am showing something in video it means that I have done that in my environment, may be same environment is not there like Folder path or file path or there might be some other issue, ideally everything should work.

[@steveoshaughnessy3736]

Move your microphone out of the coffee can.

[@kishanbhise4733]

Poor explanation!! its like practicing for yourself doesn't look like teaching

[@learnssis]

Sorry for that. I will try to make it a bit slow.

[@ambrishsingh8722]

very bad explanation