No video :(

SSIS Tutorial Part 24-Load Files to Different Tables according to the File Name in SSIS Package

Подписаться 90 тыс.

Просмотров 65 тыс.

50% 1

In this video we will learn how to load the files according to the file names in SQL Server Tables.
The video covers real time scenario and requirement where we often have to extract the file name from given file name with datetime and load to table as per file name.
This video also covers
How to create SSIS Package from Scratch
How to use Foreach Loop Container in SSIS Package
How to use Precedence Constraints in SSIS Package
How to write expressions in Precedence Constraint in SSIS Package
How to use Data Flow Task in SSIS Package
How to Write Expressions on Connection Managers in SSIS Package
How to use Flat File Source in SSIS Package
How to use OLE DB Destination in SSIS Package
To Follow Step by Step this SSIS video tutorial By Tech Brothers
www.techbrother...

Опубликовано:

5 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 47

@pragyakhare1274 4 года назад

It can also be done by single substring function. I used the below one. SUBSTRING(@[User::FileName],1,8)=="Customer"

@okeyokafor648 5 лет назад

Please help. When I execute the package it stops at the Script Task and does not load data into the SQL tables. How can I fix this?

@abhishekanand5517 4 года назад

For those of you who are unable to get past the Script Task, I believe there is some problem with Comparing the file names in the expression. Try to manually compare the file names in precedence constraints, for example, my file name CustomerFixedWidth_2019-etc. I placed, substring(@uvfilename,1,18) and it flowed.

@sandeepsolanki7661 10 месяцев назад

Hey Amir, great video. You mentioned scripting for multiple use cases, did you end up making a video for that? If yes, Can you please share the link to that? Thank you!!

@jitu206 6 лет назад

hi .. I tried every this step by step as per this tutorial , but my package stop at script task , is not moving to data flow task . can you please help .

@shivakiran100 4 года назад

Hi Jitendra, I followed the same the step by step as per tutorial but only thing that was missing was ".csv" in expression. For my task i have changed the expression as below >> SUBSTRING("ACT_Transport",5,13)=="Transport.csv" , it worked well. Where as in above tutorial they have taken just he file name without .csv. Hope this helps

@pareshyadnik4108 3 года назад

This is very helpful video!! Can you please provide the link where we can get the script for loading more files as you mentiond

@MultiAxat 5 лет назад

How does script task flow through data flow task? I did the same as you in the video, but when I execute the pkg, it stopped at script task and did not move forward. What could be the problem? I use Visual Studio 2008. I have this same doubt. How to solve this? i tried everything.

@muyiwaola9051 4 года назад

Pjmask

@swatijain4878 4 года назад

Even I have the same issue, can you please tell how you resolved it?

@swatijain4878 4 года назад

Hi Sir, I am doing exactly the same but in my package, the data flow tasks are not getting executed, inside the for loop, only the script task gets executed and the package exceution stops successfully. Can you please tell any possible reason why the data flow tasks are not getting executed.

@subbareddy8288 2 года назад

May be delay validation

@JourneyofAjuNive 4 года назад

what did you do in script task?

@monicaatibm9275 9 лет назад

Excellent! Thank you. Just what I needed!

@lucyfoley1370 3 года назад

Brilliant! Loved this!

@DeekshiWithDaddy 2 года назад

i have a 3 text files in a folder but the structure of those 3 text files is different .how do you load these 3 files data into a single destination table in ssis

@TechBrothersIT 2 года назад

please check the playlist. i have video on this topic

@kevingonzxlez 4 года назад

at minute 7:30 when you added the substring, I got an empty box. It ran successfully, but it did not get the similar output. It only worked when I used the reverse function, any tips?

@JourneyofAjuNive 4 года назад

Hi i have different .xls file. i want to check and return the filename in output as a variable using script task and load it to SQL table according to the filename. could you please help me how to do this.

@kausikpradhan6252 3 года назад

under property expression editor, when i click the property the directory is not coming . Can you please help me out?

@IcanHazParody 6 лет назад

You are wonderful. Thank you, thank you, thank you.

@TechBrothersIT 6 лет назад

You are very welcome! thanks for watching.

@leameshesha3671 6 лет назад

Hello TechbrothersIT Thanks for this helpful video .

@mrhoangvo 6 лет назад

Thanks for the tutorial. Is it possible to use ONE File task to move the file to an archive folder on success instead of creating each File Task for each DFT?

@martindq8282 8 лет назад

this look easy... but in mi case, I need to "Load different Files to Different Tables in SSIS Package", do you have any idea..?

@TechBrothersIT 8 лет назад

+martin DQ www.techbrothersit.com/search/label/SSIS%20Video%20Tutorial?m=1 and then go to scrip task and csv dynamic heading. I have covered diff scenarios and you will find one related to your question.

@phuongmss107 6 лет назад

help please!!! Example: In case, orther source has multiple excel files, can I use Foreach loop container? So I have to create multiple data flow or how can I do it? thanks!

@TechBrothersIT 6 лет назад

You can use the same For each loop to loop through the files. if the files are different, you can control the flow of them by using naming pattern and direct them to correct data flow. I will suggest you to take a look on below link. I have created many of the scenarios by using script task that can handle different type of files and load many tables. Check Excel dynamic source and destination www.techbrothersit.com/search/label/SSIS%20Video%20Tutorial

@phuongmss107 6 лет назад

thank you so much!

@708naresh 6 лет назад

Hello I tried this but it is throwing an error at +‘’\\’’+ in excel connection manager properties

@kishank307 3 года назад

Why couldn't we use a single file connection manager with an expression?

@doggy1234556 8 лет назад

@TechBrothersIT 8 лет назад

Not sure what could be the problem, it should. I will suggest to take an empty script task and only add single variable and display by using MessageBox.show just to make sure script task is working fine. If that works then we can get worry maybet here is something wrong with code. All the best!

@taiweiwang6584 8 лет назад

I have the same problem too. However, I have found a way to bypass this. This is what I did. I used Substring expression only instead of the expression showed in the video. EX) Substring( @[User::FileName] ,1, 5) == "Sales". After this expression was set for each side, at the connection manager, you need to set the DelayVaildation to True. EX) @[User::FolderPath] + "\\" + @[User::FileName] with Set the DelayValidation to True. After these modifications, If I add more flat files named Sales with different data/time. It will add into the database. If I made a typo mistake on Sales, the file won't get loaded into database.

@okeyokafor648 5 лет назад

@@taiweiwang6584 I tried your way but it still isn't working. I get an error when I try to evaluate the expression? Can you email me at ookafor59@gmail.com? My name is Okey Okafor.

@shwetadalal1549 2 года назад

@@taiweiwang6584 What code did you write inside script task?

@mayankchaubey5917 4 года назад

Hi, How execute it in New TSQL Task..

@kishorebussa 7 лет назад

Hi Amir, Hope you doing good, first of all thanks for the amazing video. My package is getting executing with error, but i am able to see the data in sql tables after execution. But, i want to know why package is getting error. I have analyazed and found that in a folder, if we have different .txt files are having different data in each files (like customer and employee information as per your example) the data is getting read but showing error in package. if we loading from different folders its working fine i mean getting executed fine with out any errors and can able to see data in respecive sql tables. i dont know is it write or wrong. but, just want to clarify with you. waiting for your reply Thanks,

@subbareddy8288 2 года назад

Delay validation property settings

@mohanpinagadi7870 8 лет назад

Hi Amir I just want to know is there any video for the same task using Script task

@TechBrothersIT 8 лет назад

www.techbrothersit.com/2014/10/ssis-how-to-load-files-in-different.html?m=1 please check this link. All the best!

@mohanpinagadi7870 8 лет назад

Amir, I have worked on provided link but it is giving invocation errors by the script because of dll reference and frame work. Apart from screen shots is there any video done by you. So I can have clear idea