SQL Server Integration Services (SSIS) Part 2 - Performing Basic Tasks

[@armansaleem3781]

this guy has the best english accent which makes our learning pretty much easy

[@DouginHanover]

I programmed the last 20 years with Oracle. The number of Oracle jobs are just limited compared to MS, so I am viewing these videos if I still want a paycheck.

[@gordonruthven7656]

what a brilliant tutorial and compliments to the speaker as the delivery, speed and infromation is second to none. many thanks!!

[@WiseOwlTutorials]

Thank you Gordon, I've passed on the compliments to Andy!

[@ekke553]

Thanks Andy. It is easy to follow you, even for non native English speakers.

[@haibuixuan4067]

I really like your approach, it's really intuitive and easy to understand.

[@georgesijo1983]

I'm moving from Prod DBA to BI analyst role. This is so helpful in getting a jump start

[@davem9976]

Found this learning channel very informative and useful. Covered every minute explanations. Great learning experience !! Well done.

[@MuhammadSaaddev]

WiseOwlTutorials can you please please make tutorials for SSAS. I searched everywhere but didn't find any material from you guys. It would be an honour to learn from you about SSAS. Please consider my request. :)

[@Mahmoud-ys1kt]

Great basic tutorial Thank you

[@WiseOwlTutorials]

Thanks for watching!

[@mariapradeepm]

Awesome explanation and very clear. I am working on SSIS and I could easily follow. Thanks so much.

[@Deepakmadduri]

If you encountered cannot convert between unicode and non-unicode string data types .Correct it as follows : rt click on flat file source->Advanced Editorr->I/O Properties->flat file source output->output columns -> set each column DATA type to DT_WSTR .Solved . This is common issue for freshers. Enjoy SSIS.

[@I677000]

Thanx! Really helpful!!! I spend 40 minutes trying to find resolution for my problem, few times recreate table, it didn't work, and Your solution is perfect :)

[@tomlee126]

THanks dude. i almost banged my head to my lap ..Even after that if u get the error ,,then In desination > Error output > under error > Ignore failure.

[@arvindkumartegampure4710]

I am Beginner and faced following Two errors while following this video. 1- The column "Appname" cannot be processed because more than one code page (65001 and 1252) are specified for it. 2 convert between unicode and non-unicode string data types To fix. -- 1 1.Modified code-behind by replacing all 1252 page number references with 65001. 2 "AlwaysUseDefaultCodePage" property of oledb source as true. To fix --2 Use varchar and not nvarchar if using sql server. Cheers!

[@bolajiawofuwa8116]

Thank You so very much

[@krismaly6300]

Awesome video. I enjoyed watching this video and recommend others to watch. Teacher is awesome too and narrates step by step clearly and crisply. Thanks for educating the community and your volunteer-ship is appreciated. Please keep educating others to see a new good world in the future. If I am of any use please let me know. Thanks a bunch.

[@Grrrl1976]

So easy to follow, thanx! Wanted to add SSIS to my knowledgebase for some time and you make this so easy! :)

[@tracygarner5912]

This really helped me understand debugging when testing fails. Thanks!!

[@christiandavidpadriquez4788]

Thank you for your help. Very detailed explanation

[@WiseOwlTutorials]

You're very welcome Christian, happy to hear that you found it useful!

[@h21bensaid]

Wise owl is the best ! simply excellent.. Thank you very much !

[@Vishalkumar-vj7hx]

you are awesome. very clear and very profound. hats off to you buddy.

[@gsr4535]

Once again, great job Andy. Thanks! :-)

[@hamzah1738]

So this similar to write a multiple Insert into SQL requests, but using the power of SSIS we can feed quickly our SQL server DB from the flat file, I would thank you for the explanation it was very clear

[@fadwa2413]

Excellent as usual Thanks a lot

[@WiseOwlTutorials]

Thanks, glad you enjoyed it, thanks for watching!

[@bouchrab5434]

Great job, very clear and useful . Thank you !

[@dougchittum7835]

I know, this guy is outstanding! Been using his videos for a couple of years now.

[@PaulBillingtonFW]

Good clear English, finally!

[@ramz87]

These are very good videos, but having done all this and not sharing the necessary resources used in each exercise is a great shame! Thankfully, some thoughtful viewers have bothered and shared the text file for example used here. But, it really should have been done by you!

[@tgall0194]

Very helpful and clear explanation. It help me a lot, thank you so much

[@josecaychoasin9358]

Thank you I really like your tutorials

[@WiseOwlTutorials]

Thank you Jose!

[@-Harambe]

Andy, Thanks a lot. I've landed a job where I will be using the SSIS skill I have acquired from your tutorial videos. Thanks a lot. Andy, I will be exporting SAS data into SQL Server tables using SSIS. Andy, how can I store SSIS connection strings on the server? Does my question make sense?

[@feng3625]

Please add SSAS from your class. you could create a pay course. we like to learn from you!

[@WiseOwlTutorials]

Thanks! It's certainly something we intend to do but we don't have an estimate on when this will happen.

[@MohamedSuleiman]

Excellent videos.. thanks you very much. I love it

[@edisonchen3588]

very clear and helpful!

[@luz8695]

Hey! You look familiar! Aren't you my classmate from last year? We are watching the same video!! 有缘啊！Great to see you on KZbin!

[@martinjerome6865]

Thx a lot for sharing this very good video. It is clear and really interresting.

[@ASX373]

thank you ! one of the best guides i saw

[@ericwunderlich9046]

Thank you for these videos!

[@tayjianzhen212]

CREATE TABLE Apps ( AppId int IDENTITY(1,1) PRIMARY KEY, AppName VARCHAR(250) NOT NULL, Rating INT NOT NULL DEFAULT 0, Summary VARCHAR(250) NOT NULL );

[@hazarsk]

Thanks Andy..great job.

[@MuhammadSaaddev]

can you please please make tutorials for SSAS. I searched everywhere but didn't find any material from you guys. It would be an honour to learn from you about SSAS. Please consider my request. :)

[@TheQciap]

Hi Andy, really impressed what you all do here in WiseOwl. Congrats. I am just wonder if you provide somewhere the link to the txt file you work on? It happens in different technology classes in WiseOwl there is why I am asking. Regards ;)

[@vladislavmikhailov]

Hey! Thanks for tutorials, I found it easy to learn with you, however, I don't know how to create a DB ssis that you have in video. Could you please give me a directions where to see this?

[@benzimegido747]

,The class was great Thenk you!

[@krismaly6300]

Revisited It's an AWESOME video

[@avishakechakraborty6275]

simple yet informative

[@Kyryt2002]

It would be very kind of you to put links to apps.txt and 'apps' db script under the video. Thank you for your video!

[@carlospwk]

AppName | Rating | Summary Temple Run | 8 | Try to evade the chasing pack by running along causeways and bridges, ducking under trees and leaping obstacles BBC News | 9 | News channel from the ever-reliable BBC Scramble | 7 | The most addictive word game ever created: try to spell out words from a Boggle-style grid Meeblings | 8 | Different Meeblings behave differently, according to their colour - solve puzzles at each level Met Office | 7 | Accurate weather foreacsts by your chosen areas up to 5 days in advance Train times | 8 | UK train times: plan journeys or see real time information on why your train is held up in a siding in Waftford Fruit Ninja | 8 | Karate-chop pineapples, water-melons and lots of other fruit to win points

[@tanzilakhasru3304]

Thank you so much

[@obinnamogbogu9525]

CREATE TABLE Apps ( AppId INT NOT NULL, AppName VARCHAR(250) NOT NULL, Rating INT NOT NULL DEFAULT 0, Summary VARCHAR(250) NOT NULL CONSTRAINT "pk_appId" PRIMARY KEY("AppId") )

[@muzammelhaquemukul7089]

It's super helpful

[@isrj01]

Thanks Carlos

[@almazbeyene2131]

You are Great! thank you so much for sharing your knowledge. Do you have any books for SQL SSRS and SSIS that is similarto your videos or any book that you suggest?

[@timjackson5343]

Andy, do you have any videos that show how to download a source file from the internet? Thanks for making these videos! They have been very helpful.

[@sangeetha281]

Very helpful. Thank you so much.

[@ozhoneybadger]

Amazing tutorials. Question...My excel to SQL server import fails because of Unicode and non Unicode data types...even with a data transformation in between and correct mapping I get the same issue. Having a closer look revealed that my SQL server types are supporting Unicode...I have no clue and any help even after googling would be good.

[@ican1972]

how did you guys get the access for the sql script and the apps table?

[@barrymorse8810]

Thank you for the great tutorial. One question about the Data Viewer: Is it possible to view the new AppId in data viewer? I ask because in reality, input and output tables will contain thousands of records, many of which may be unchanged from one instance to the next. Therefore, the only distinguishable change might be the AppId. Seeing the change of AppId would, I suppose, confirm that the correct output file or table was specified in the flow. One of the easiest errors to make, in my experience, is to misspell an output file name or table name on creation.

[@aerhearts]

Great tutorial. Now, if you have several tables to repopulate - can you set them all up in one Control Flow? Would they run separately in parallel, or should they be strung together in a series?

[@andybrown7443]

Each one would be a separate data flow task. You could run these in series or in parallel in control flow. If the tables are independent of each other, it would be most efficient to run the data flow tasks in parallel, then SSIS could use multi-threading to run them most efficiently.

[@n70amu]

awesome tutorial brother, keep it up....

[@pawem.9684]

THANK YOU!

[@paulboudreau4371]

i'm just curious... why did you create a new package and rename the new package? couldn't you have renamed the original package?

[@bojanadjokic7154]

Do you have a video where switching txt file into a table from the database, with 2 lookup controls?

[@amittechhie]

nice explanation...thnx very much :)

[@sruthibadri1632]

Hey.. I get NULL value in the table for app. why am i getting it? Can you please tell me where did i go wrong?

[@theleeclan00]

How was the AppId created?

[@parthbhagat4253]

Hello, will you please send a link from where I can download the 'Apps' Database?

[@rayz8569]

Thank you

[@DB-sf1hy]

Some say visual studio (ssis) 2019 is full of bugs... is that true or have they fixed the bugs?

[@-Harambe]

Andy, whenever I try to resize/move the sequence or any kind of boxes, they seem to go out of whack. Any tricks you can share? or am I doing something wrong?

[@-Harambe]

Thanks Andy.

[@Googlepaynnn]

How to download this videos,I am trying download but not downloading,please help me how can i do that?

[@MrIrrepressible]

what if you to only insert new rows of data or update existing rows?

[@suchitedits000]

good one

[@artyom9499]

Nice

[@WiseOwlTutorials]

Thanks!

[@igspstl]

Great series, but four clicks to stop two pairs of commercials?! Come on KZbin!

[@-Harambe]

Andy, I am trying to import a huge flat file into a sql server. It errors out after loading pass 30,000 records. When I physically split the files into two and load it two different times, it imports fine without any error. I also try to write from the flat file to a flat file. That worked fine as well. Andy, is there a flat file limitation on SSIS or at the sql end? Any help is appreciated.

[@gjulidh]

NOAH Hello NOAH, I executed a process loading 40,000 records and I had an error when try to execute the package, the process only loaded 5 records. After review the data source and the table structure, finally, I found the problem: one foreign key in the target table was it the problem. My suggestion is that try follow the same way, maybe you will find a similar solution. Regards.

[@Noah-cw3mr]

NOAH Sorry, I was out on vacation for awhile. My issue i realized was with the input file. There were double quotations where it shouldn't be. That was throwing off the SSIS. So, I wrote a script to clean that and it worked fine. Thanks the community for the support/.

[@yasminkhattab7589]

Hi again :) i have a problem specifically with loading to EXCEL sheets. I created an Excel Connection Manager, then when i click on the Excel Destination Editor, i fill it and in the Name of the Excel Sheet line i select "NEW", but i get the following error: ------------------------------ The table cannot be created. ADDITIONAL INFORMATION: ' Level' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. (Microsoft JET Database Engine) ------------------------------ Note that i tried changes the Level word into something else, tried lower case,..etc but it's useless. I need help ! Thanks

[@yasminkhattab7589]

@@WiseOwlTutorials I did actually it did not work. I have to mention when creating the Excel Connection manager, i selected Excel Version 97-2003 like the one in the video, even though my Excel Version on my Laptop is 2016. This because when i tried earlier to select version 2016, and in the Excel Editor, i was not able to create script, when i select "NEW" the window will sudden close. Is this related to the version of Excel? I am not able to use Excel as Source nor Destination .

[@mcring543]

Doesn't File > New > Project really create a .sln Solution? Then within the Solution, we create projects? The terminology is a bit confusing.

[@drwalegeorge5037]

HOW DID YOU COME ABOUT THE APP TXT, I GOT CONFUSED HERE , PLEASE HELP .

[@billyhutchins6629]

Script for creating the Apps table in SSIS db: CREATE TABLE [dbo].[Apps]( [AppId] [int] IDENTITY(1,1) NOT NULL, [AppName] [varchar](50) NULL, [Rating] [varchar](50) NULL, [Synopsis] [varchar](50) NULL ) ON [PRIMARY]

[@WiseOwlTutorials]

Cheers Billy!

[@shahann81]

Where do I get the flat file from?

[@maplecalculus]

Where Can I get the apps.txt File

[@samram9255]

where is the apps.txt file...? Please provide the file link.

[@tomlee126]

Create ur own file and do man

[@kiquenet]

Can I download flat files?

[@tayjianzhen212]

AppName | Rating | Summary Temple Run | 8 | Try to evade the chasing pack by running along causeways and bridges, ducking under trees and leaping obstacles BBC News | 9 | News channel from the ever-reliable BBC Scramble | 7 | The most addictive word game ever created: try to spell out words from a Boggle-style grid Meeblings | 8 | Different Meeblings behave differently, according to their colour - solve puzzles at each level Met Office | 7 | Accurate weather foreacsts by your chosen areas up to 5 days in advance Train times | 8 | UK train times: plan journeys or see real time information on why your train is held up in a siding in Waftford Fruit Ninja | 8 | Karate-chop pineapples, water-melons and lots of other fruit to win points