2 part question.
i have a fixed width file that i import daily using ssms import data tool. i would like to start getting my teeth wet with automating this process.
i first open the text file with excel. manipulate with excel and then import. I thought that ssis would be the proper way to go about this.
i would like to start out with the easiest tool sql 2014 provides that can control import and exporting and automation. would sql server data tools be the right way to start.
part 2 question... im not sure where the data tools are. i have just about everything install for sql 2014 but don't see sql server "data tools"
i see data profile viewer and some visual studio stuff.
so 1) best easiest way to start doing this
2) where is the dern program to complete the suggested route.
i want to use only apps provided by sql server 2014