130 How to read data from api in ssis

How to read data from api in ssis

Download the file\script used in the Video from below link

How to read data from api in ssis
Can SSIS connect to an API?
How to pull data from API to database?
How to load data from API to SQL Server?

Happy Learning.

[drummermike]

Thanks for another great tutorial! I love how you showed how to create the classes in ChatGPT!

[medalatnejad]

I can't thank you enough! Your awesome videos have helped me find solutions to every issue I've encountered in SSIS on your channel.thank you, you are a really superb.🙏

[saiabhilash]

Bro you are really superb 🙏🙏.I struggled a lot to do this functionality 2 weeks back but u have done in very simple way and hatsoff to you .Most of APIs we use in projects are Authenticated .Could you please make video on calling API with authentication .
1stLevel Authentication Code
2nd level Access token .Also could you pls help us with how do you get C# code for these kind of tasks . I personally know many like me who are surviving in IT only because of your videos .May God bless you and give you back many more times .

[fahadalam]

Thank you so much, mate. I sent you an email a few weeks ago to make a video on API data. Thanks again :)

[reddyabhik]

Finally I got to know how can I use chatgpt and use the code in ssis
Thank you for the video upload.

[jennasyeda]

Superb, really outstanding, kindly make video on fetching data from external API.

[dfkbthv]

Excellent explanation as usual, thanks for this video

[NripaEmpowerthroughknowledge]

thank you for sharing, very useful . looking forward to collaborate with you

[saharicreations]

Sir ssis instalation lo lssu undi konchem solve cheyraa

[harshavardhan]

Well done keep uploading more videos sir

[antwanwimberly]

I think one very important thing to note is that you’d want to use something like a prepared statement/parameterized statement for security purposes when interacting with a database instead of string concatenation in the insert statement. This helps avoid SQL Injection.

[mateusnunes]

Is it possible to do this without using C# or an external tool?

[aka_modern_ashoka]

Can you please let me know how to fetch data from the second URL returned by the API

[yateeshkandru]

Thanks for the video, Its super helpful! When you get a chance can you Post Similar video using authentication API. Thanks a lot!

[willywooca]

Looks like this is for Application Developer that wants to create SSIS package, but for Database Developer we don't normally write C# code, is that a way in SSIS to directly map the API output into database table? Using data transformation within SSIS, instead of using C# to do everything?

[sunilkanukuntla]

Hi I need help on a task. Pls let me know how we can communicate

[Booleys]

Awesome! Can you advise a good c# tutorial?

[yosrabusbait]

Thank you very much for the helpful video, if you can help me I got error when run the package says that “The binary code for the script is not found”

[nareshchowdary]

Great video. Can we achieve this vs 2012 and can't we use web services task in ssis.?

[tomlee]

Thanks for the video, but i have a senario on how to loop a parameter (lets say an id or page number ) in the Get request by this method