This is my very first step in SSIS and I am trying to migrate data from an excel sheet into my database.
I am following different tutorials and I am at the point where I need to set up my destination.
Therefore through Connection Manager I try to find my database and select it.
Unfortunately nothing happens on the server name dropdown. But I use daily my SQL Server database.
I typed in the server name and it was able to recognize it and populate the available databases after.