Execute an SSIS package at regular intervals using SQL Server Agent

you can execute an SSIS package at regular intervals using SQL Server Agent, which is a component of SQL Server used for scheduling and automating tasks, including SSIS package execution. Here's how you can schedule the execution of an SSIS package at intervals:

1. Create SQL Server Agent Job:

   • Open SQL Server Management Studio (SSMS).
   • Connect to your SQL Server instance.
   • Expand the "SQL Server Agent" node.
   • Right-click on "Jobs" and select "New Job...".

2. Define Job Details:

   • In the "General" tab of the "New Job" dialog, provide a name for the job and an optional description.

3. Add Job Step:

   • In the "Steps" tab of the "New Job" dialog, click on "New..." to add a new job step.
   • In the "New Job Step" dialog, provide a name for the step and select "SQL Server Integration Services Package" as the type.
   • Choose the appropriate SSIS package source (e.g., File System, SSIS Package Store, SQL Server).
   • Select the SSIS package you want to execute.

4. Schedule Job:

   • In the "Schedules" tab of the "New Job" dialog, click on "New..." to add a new schedule.
   • Configure the schedule by specifying the frequency (e.g., daily, weekly, monthly) and the interval at which you want the job to run.
   • Set the start date and time for the schedule.
   • Optionally, configure other schedule options such as end date, recurrence pattern, and notification settings.

5. Configure Notifications (Optional):

   • In the "Notifications" tab of the "New Job" dialog, configure email notifications to be sent upon job completion or failure.

6. Save Job:

   • Click "OK" to save the job configuration.

Once the job is created and scheduled, SQL Server Agent will automatically execute the SSIS package according to the defined schedule.

Additionally, you can also use external scheduling tools or services (e.g., Windows Task Scheduler, Azure Automation) to execute SSIS packages at intervals if you prefer. These tools provide additional flexibility and options for scheduling and managing automated tasks. 

Var Vs Dynamic Keywords In C#

If you're working with C# code, I assume you're utilizing the 'var' and 'dynamic' keywords. Here are some highlighted points that I hope you find helpful.

Var Vs Dynamic Keywords In C#

When were they introduced

• var was introduced in C# 3.0
• dynamic was introduced in C# 4.0.

Type inference of variables

• var is a statically typed variable. It results in a strongly typed variable, in other words the data type of these variables are inferred at compile time. This is done based on the type of value that these variables are initialized with.
• dynamic are dynamically typed variables. This means, their type is inferred at run-time and not the compile time in contrast to var type.

Initialization of variables

• var type of variables are required to be initialized at the time of declaration or else they encounter the compile time error: Implicitly-typed local variables must be initialized.
• dynamic type variables need not be initialized when declared.

If you want to understand kindly refer this link click here  

Thank you ,

Angular Upgrade | How to upgrade from Angular 10 to 11 ?

 In this article, we will learn how to implement angular 10 to angular 11 upgrades. you will learn to update @angular 10 to 11. this example will help you upgrade angular CLI to 11 in Ubuntu. Here you will learn to update angular 10 to 11. Follow the below tutorial step on how to update angular versions 10 to 11.

I have two ways to upgrade your angular 10 to 11 first we will directly update your angular cli version. if it's not working for you then you can uninstall and reinstall your angular cli with the below steps.

Let's see both ways:

Way 1:- 

Step 1) Update Angular CLI 

          ng update @angular/core@11 @angular/cli@11 --force

Step 2 ) If you're using angular/material the update command is as below 

           ng update @angular/material@11 --force

Step 3) Use ng update command for typescript update. 

If everything is ok the use ng version command to check the version of angular CLI.

Way 2:- 

Step 1) Uninstall Angular CLI:

          npm uninstall -g @angular/cli

Clear Cache:

         npm cache clean --force

         npm cache verify  

Install Angular CLI:

         ng update @angular/cli@11 @angular/core@11 --allow-dirty --force

Then check the version using ng version, 

Hope it is helpful for you Keep learning.

ANGULAR / CREATE A MODULE, COMPONENT WITHOUT CSS FILE IN ONE COMMAND?

 Minimalist Angular Cli generate example

ng g c hero-component --flat -it -is --skipTests

• -is for inline css, preventing style file creation
• --flat to prevent folder creation
• -it for inline template, preventing html file creation
• --skipTests to prevent .spec file creation

Link to the Angular doc reference https://angular

With all these parameters together,

The cli creates a single .ts file in the current folder and links it in the module.

How to add domain in Tag Manager

 Hello Friend today in this post I will explain to you how to add a domain name for tracking in Tag Manager.

 This is the screen where you add domain for tracking 

But the question is how to reach this window here is the step:-

this is an extension method of Crome 

Manage your extensions 

1)On your computer, open Chrome.

2)At the top right, click More More tools. Extensions.

Hope it will help you

How to configure Tag Manager in angular.

How does the Token-Based Authentication work?

Digital transformation brings security concerns for users to protect their identity from bogus eyes. According to US Norton, on average 8 lakh accounts are being hacked every year. There is a demand for high-security systems and cybersecurity regulations for authentication.  

 

Traditional methods rely on single-level authentication with a username and password to grant access to web resources. Users tend to keep easy passwords or reuse the same password on multiple platforms for their convenience. The fact is, there is always a wrong eye on your web activities to take unfair advantage in the future. 

Due to the rising security load, two-factor authentication (2FA) come into the picture and introduced Token-based authentication. This process reduces the reliance on password systems and added a second layer to security. Let’s straight jump on to the mechanism.

But first of all, let’s meet the main driver of the process: a T-O-K-E-N !!!

 

What is an Authentication Token?

A Token is a computer-generated code that acts as a digitally encoded signature of a user. They are used to authenticate the identity of a user to access any website or application network.

A token is classified into two types: A Physical token and a Web token. Let’s understand them and how they play an important role in security.

·       Physical token: A Physical token use a tangible device to store the information of a user. Here, the secret key is a physical device that can be used to prove the user’s identity. Two elements of physical tokens are hard tokens and soft tokens. Hard tokens use smart cards and USB to grant access to the restricted network like the one used in corporate offices to access the employees. Soft tokens use mobile or computer to send the encrypted code (like OTP) via an authorized app or SMS.

·       Web token: Authentication via web token is a fully digital process. Here, the server and the client interface interact upon the user’s request. The client sends the user credentials to the server and the server verifies them, generates the digital signature, and sends it back to the client. Web tokens are popularly known as JASON Web Token (JWT), a standard for creating digitally signed tokens.

A token is a popular word used in today’s digital climate. It is based on decentralized cryptography. Some other token-associated terms are Defi tokens, governance tokens, Non-Fungible tokens, and security tokens. Tokens are purely based on encryption which is difficult to hack.  

What is a Token-based Authentication?

Token-based authentication is a two-step authentication strategy to enhance the security mechanism for users to access a network. The users once register their credentials, receive a unique encrypted token that is valid for a specified session time. During this session, users can directly access the website or application without login requirements. It enhances the user experience by saving time and security by adding a layer to the password system.

A token is stateless as it does not save information about the user in the database. This system is based on cryptography where once the session is complete the token gets destroyed. So, it gets the advantage against hackers accessing resources using passwords.  

The most friendly example of the token is OTP (One Time Password) which is used to verify the identity of the right user to get network entry and is valid for 30-60 seconds. During the session time, the token gets stored in the organization’s database and vanishes when the session expired.  

Let’s understand some important drivers of token-based authentication-

·       User: A person who intends to access the network carrying his/her username & password.

·       Client-server: A client is a front-end login interface where the user first interacts to enroll for the restricted resource.

·       Authorization server: A backend unit handling the task of verifying the credentials, generating tokens, and send to the user.

·       Resource server: It is the entry point where the user enters the access token. If verified, the network greets users with a welcome note.

How does Token-based Authentication work?

Token-based authentication has become a widely used security mechanism used by internet service providers to offer a quick experience to users while not compromising the security of their data. Let’s understand how this mechanism works with 4 steps that are easy to grasp.

How Token-based Authentication works?

1. Request: The user intends to enter the service with login credentials on the application or the website interface. The credentials involve a username, password, smartcard, or biometrics

2. Verification: The login information from the client server is sent to the authentication server for verification of valid users trying to enter the restricted resource. If the credentials pass the verification the server generates a secret digital key to the user via HTTP in the form of a code. The token is sent in a JWT open standard format which includes-

·       Header: It specifies the type of token and the signing algorithm.

·       Payload: It contains information about the user and other data

·       Signature: It verifies the authenticity of the user and the messages transmitted.

3. Token validation: The user receives the token code and enters it into the resource server to grant access to the network. The access token has a validity of 30-60 seconds and if the user fails to apply it can request the Refresh token from the authentication server. There’s a limit on the number of attempts a user can make to get access. This prevents brute force attacks that are based on trial and error methods.  

4. Storage: Once the resource server validated the token and grants access to the user, it stores the token in a database for the session time you define. The session time is different for every website or app. For example, Bank applications have the shortest session time of about a few minutes only.

So, here are the steps that clearly explain how token-based authentication works and the main drivers driving the whole security process.

 

Note: Today, with growing innovations the security regulations are going to be strict to ensure that only the right people have access to their resources. So, tokens are occupying more space in the security process due to their ability to tackle the stored information in the encrypted form and work on both websites and applications to maintain and scale the user experience.  Hope the document gave you all the know-how of token-based authentication and how it helps in ensure the crucial data is being misused. 

 

Setting TLS Version For Azure App Services

If we are looking to set the minimum TLS version via the portal, we first have to open up our App Service and look down the left-hand menu for TLS/SSL settings.

On this screen, we can edit the TLS minimum version, which should really be 1.2 at all times.

And we are done! A very easy setting to change that adds a tonne of security benefits.

Thank you! Happy Learning.