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.