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
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.