Skip to main content

How to create dynamic connection manager in SSIS

 STEP-1

  • Create variables for User Id and Password as shown below.



STEP-2
  • On the connection Manager right click and create a New connection
  • After Creating, right click on the created connection > Properties
  • On Properties click the 3 dots at the right end as shown below.



  • Now select the Properties as shown on the left and assign variables to the properties which you created as shown below in the right

  • Once the connection is created, you will see the fx before the connection as shown below





Comments

Popular posts from this blog

Convex Lens Vs Concave Lens

What is a Lens A lens is a transparent object that transmits light across it, and its working principle depends on the   law of refraction (Snell’s law) . Applications: Concave Lens help with Far-Sight Convex Lens help with Near-Sight

Herbal Plants

Herbal plants to grow in home Different types of keerai ----- http://www.indiandietrecipes.com/2016/03/pictures-of-various-types-of-greens-or.html Pirandai ----good for bone joins---- https://youtu.be/k2DGubyXLAE Valarai Keerai Benifits ----- https://youtu.be/33HIfLJKTqA Sesma seeds ---- https://easyayurveda.com/2011/02/24/sesame-and-sesame-oil-benefits-total-ayurveda-details/

What is Verbal and Non-Verbal communication

TYPES OF COMMUNICATIONS: