how to open a large text file to see data

HOW TO OPEN A LARGE TEXT FILE TO SEE DATA WINDOWS

When all operations are successful, then your import operation completes properly and your file has been successfully imported. “ Performing Operation”: Here operation is in progress. Step 12: After clicking on the “finish button” we can see the next window.

HOW TO OPEN A LARGE TEXT FILE TO SEE DATA WINDOWS

Now we are on final stage, here a windows “Complete the Wizard” will be visible. Here we did not saved a package so select Run immediately checkbox and click on “Next Button”. In this section you can save packages, then select checkbox “Save SSIS Package” and if you did not saved a package then select check box “Run Immediately”. Now click on next buttonĪfter clicking on the next button, a new windows will be visible with the name “Save and Run Package”. You can check your table preview on clicking “ Preview” Button. Here “ Append rows to the destination table” radio button is already selected and mapped. Here new window will open with the name “ Column Mappings”. data table.Īfter selecting your table, click on “ Edit Mapping” button. If you want to import data in the default table, then you can insert, otherwise you are selecting your database table. In this section, wizard automatically creates a table, here the default table name is “.”. Here I login with SQL Server authentication, so provide the “user name” and “ password” and select the next button.Īfter authentication process we will go to “ Select Source Tables and Views” window.

If you Login Windows Authentication, select first radio button “Use Windows Authentication” and if you login with SQL Server Authentication, then select “Use SQL Server Authentication”.

Here select an option where you will login your SQL Server. You are selecting your server name and now the option is “Authentication”. Now after selecting ”Microsoft OLE DB provider for SQL Server” select Server name, here my server name is “MCNDESKTOP16” because this is my local server name. In the destination we need to select “Microsoft OLE DB Provider for SQL Server”. After that click on next button.Īfter selecting the text file as in the following image, click next. After selecting flat file, select “ Tab” in “Header row delimiter” and uncheck the “Column name in the first data row”. In this window, select File name and browse the file where your file saved. Here in the data source option select “ Flat File Source”.Īfter selecting “ Flat File Source”, it will open some textboxes. Now after clicking on Import data option, a new window “ Welcome to SQL Server import and Export Wizard” will open. After that select Tasks, then select import data by pressing enter key. Go to database Oct_7_database and right click on the database. Now we can create a database table with 4 columns and 6 rows, it is optional because SQL server wizard automatically created a table when we import data. Here we are creating a database by query. You can create a SQL server database through query or manually, it is your choice. Now go to SQL server and create a database in SQL server. We created a text file and saved that file with DataFile name in the D: drive.Īfter the end of the first step, go for the second step wherein we are going to create a new database.

How to open a large text file to see data