Question: how to import data from text file to sql server using ssis?
Answer:  Know your file location! ...   Open up Visual Studio > File > New > Project > Integration Services > OK. ...   Drag a [Data Flow Task] onto the designer window and double click on the task.