Solved

SSIS package delete first row

Posted on 2013-06-18
1
600 Views
Last Modified: 2016-02-11
Hello,

I have a .txt file that contains A LOT of data that I need to import to my sql server database after some treatment. I have a few questions about what I can achieve with SSIS.

First one is that this .txt has a useless first line with the date and then the headers are in the second row... If I manually delete this row and save as a new txt I can add it as a new flat file source correctly, but if I try to treat the original txt (skip header row, skip data row) I can't make it turn into columns, they are simply in one (examples of how it should be and how it gets are attached).

Other question: This table it should generate from the file has lots of information in one place (that's why the high number of columns). I want to keep my database organized, so I would have one table for each category of information on that file. Is it possible to open this file only once, and then make some queries to separate each data and insert in the right table?

Sorry for the possibly stupid questions, but I never used SSIS before and I really need this asap =/


Thanks in advance!!
howitis-general.bmp
howitis-preview.bmp
howitshoulbe-preview.bmp
0
Comment
Question by:toddinho
1 Comment
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
ID: 39261962
You can select the start row in Flat file source.

Skip Rows
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question