Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-01-12 : 09:44:51
|
| Hi,I have a .csv file which I would liek to place it's data into a sql server table.In ssis package I am creating a flat file connection but in this connection I am unable to get to the data properly.As I can not place a sample .csv file into this section, I will just explain the .csv file as follows:Row A1, A2 and A3 has some NOT useful text.Row 4 has field names but they seem to be concatenated next to each other.Then the actual data starts from row 5. In each column from row 5 onwards, the values are placed in their own column.IN the connection manager, I have tried using different settings but can you see what settings I have to use to get to the data please? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-12 : 12:48:01
|
| did you try using an excel source instead?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-01-13 : 06:05:16
|
| do you mean to use an excel source even if my source is .csv ? |
|
|
|
Jules_S
Starting Member
13 Posts |
Posted - 2012-01-13 : 07:17:45
|
| If you don't need the column headings (field names) then in the connection manager for the file, you can ignore the first four rows by changing the "Header rows to skip" value under the "Format" section on the "General" page of the connection manager editor. From the way you describe the file it sounds as though the field names are not separated with the same character delimiter as the data rows. You would need to edit the file and change this if you need the headers - as far as I'm aware you can't specify different delimiters for header rows and data rows |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-01-13 : 07:37:12
|
quote:
Originally posted by arkiboys
do you mean to use an excel source even if my source is .csv ?
This file seems to be complex to pull out it's data using ssis.Is it possible I can send you a sample of this data in a file so that you can analyse the format and let me know the bet route to take please?If so, how can I send the file to you please?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-13 : 09:57:14
|
quote:
Originally posted by arkiboys
quote:
Originally posted by arkiboys
do you mean to use an excel source even if my source is .csv ?
This file seems to be complex to pull out it's data using ssis.Is it possible I can send you a sample of this data in a file so that you can analyse the format and let me know the bet route to take please?If so, how can I send the file to you please?Thanks
upload file in some shared server and post the link here------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
download a .csv file into a sql server table