Category Archives: SSIS
Creating a SQL Connection in SSIS
First you need to have a database already if you don’t you can download a sample adventureworks2016.bak database or any other data base. Open SSMS Select windows authentication In the object explorer right click on databases, then click on Restore Database In the window which appears select device and then click on elipses … After clicking ellipses click on Add and select the location of the .bak file After selecting the location of the file click on it and select ok OR Create an own data base table Open SSIS And create / open an existing integration project Select connection manager on the right in solution explorer Right click on it and select new connection This window appears in this window select OLEDB Click on ADD and then this window appears Here click on new Select the provider And type the server name used in SSMS Select database from dropdown Click on test connection to check if everything is good Click on ok The new connection can be seen in connection manager
Share Story :
SEARCH BLOGS:
Anil Shah, CEO
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.