Red Gate forums :: View topic - Create Table + Bulk Insert
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Create Table + Bulk Insert

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
andreandre



Joined: 16 Dec 2012
Posts: 1

PostPosted: Sun Dec 16, 2012 9:23 pm    Post subject: Create Table + Bulk Insert Reply with quote

Hi guys,

I have a .csv file wich has the following information (exactly like this):


List Name: User
Format Version:1.2.5.0
Date:12/11/2012 12:00:34
Equipment.:L6867000214
IP:172.21.12.62

User,Name,Total,B&W
[1600],[technical],76,76
[6611],[Daise],559,559
[900301],[Richard],0,0


I want to execute a create table and a bulk insert transaction but I don't know how to insert the information of the top lines of the .csv file like "Equipment.:L6867000214" and "IP:172.21.12.62". I need to create a collumn called "Equipment", other collumn called "IP" and insert this information (repeat L6867000214" and "172.21.12.62" in all records bulk inserted). The result must be like this:


IP,Equipment.,User,Name,Total,B&W, Color
172.21.12.62,L6867000214,[1600],[technical],76,76
172.21.12.62,L6867000214,[6611],[Daise],559,559
172.21.12.62,L6867000214,[900301],[Richard],0,0

I have no idea how to do that. Could anyone here help me out on this issue?

Thanks a lot!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group