No announcements
Found 3472497 threads
-
0 VotesHow to copy data from CSV to Table
if you want to go via Wizard please follow the link and use as test import in test table.Answered | 3 Replies | 2056 Views | Created by ryguy72 - Friday, September 13, 2013 1:53 AM | Last reply by ryguy72 - Friday, September 13, 2013 3:31 AM
-
1 Votes
Data Factory Copy - CSV Source
For your first question, your guess is right that it should be caused by the too short column in target SQL table.Answered | 3 Replies | 4137 Views | Created by some guy who needs help - Friday, August 7, 2015 4:40 PM | Last reply by Yingqin - Tuesday, August 11, 2015 2:04 AM -
0 Votes
Not able to copy data from a csv file to a table in Sql Server 2008
Also check this step by step article on loading the CSV file.Answered | 7 Replies | 10857 Views | Created by msrahman - Wednesday, November 23, 2011 4:14 PM | Last reply by Subhash.Subramanyam - Monday, November 28, 2011 4:52 AM -
0 Votes
Import data from csv to SQL server table
Hi Use this function and script to bulk copy data from csv to sql Notify that first you need to create ...Answered | 5 Replies | 3363 Views | Created by oleolehoohoo - Thursday, March 3, 2016 7:37 PM | Last reply by MTorabi - Monday, March 7, 2016 8:29 AM -
0 Votes
exporting data from hive table to csv file.
The CREATE EXTERNAL TABLE command does not move the data file.Answered | 2 Replies | 11007 Views | Created by Ak Ansari - Tuesday, May 2, 2017 8:17 AM | Last reply by Ak Ansari - Tuesday, May 16, 2017 9:26 AM -
0 Votes
How to load the data from CSV file in temp table at run time?
Hello, You can use the OPENROWSET (Transact-SQL) function to read CSV file, then you can transform the data in the SELECT and you can insert the ...Answered | 3 Replies | 4497 Views | Created by Incredible15 - Thursday, May 28, 2015 2:01 PM | Last reply by Olaf Helper - Thursday, May 28, 2015 4:59 PM -
3 Votes
loading data from csv file to table
Hi, hope you mean to delete all the data in the table.If so, 1. open ssms (sql server managment studio) 2. open query editor ...Answered | 5 Replies | 3055 Views | Created by baba k - Tuesday, March 20, 2012 6:03 AM | Last reply by Mohamed Irshad - Tuesday, March 20, 2012 8:49 AM -
0 Votes
How to load data from CSV file in temp table in C#
Hi, Check the below method it creates a DataTable out of csv file, it reads the first row as the column names, simply call by passing the path to the file and it returns a ...Answered | 2 Replies | 4551 Views | Created by Incredible15 - Monday, June 15, 2015 2:02 AM | Last reply by Marco Ruiz - Monday, June 15, 2015 9:34 PM -
0 Votes
how to copy table data from one database to another database table?
thanks for your reply. one more thing how can i do the same task into other server . i mean from one sever to other sever data transfer.. plz let me?Answered | 8 Replies | 5435 Views | Created by Vasu Thota - Thursday, October 21, 2010 7:15 AM | Last reply by Vasu Thota - Thursday, October 21, 2010 11:51 AM -
0 Votes
How to copy data from one table into multiple tables
How to copy data from one table into multiple tables.Answered | 9 Replies | 3725 Views | Created by Rajesh cpa - Wednesday, November 6, 2013 1:33 PM | Last reply by Uri Dimant - Sunday, November 10, 2013 8:26 AM -
0 Votes
Loading from CSV file to Sqlserver Table
I have solved the problem and now data is reading from CSV at a faster pace.Answered | 5 Replies | 5491 Views | Created by NedunuriRajesh - Friday, August 23, 2013 10:41 PM | Last reply by NedunuriRajesh - Thursday, August 29, 2013 6:52 PM -
0 Votes
How to prevent hidden table from exporting in CSV
RenderFormat.Name="CSV", True, False) didn't work in CSV export either.Answered | 3 Replies | 1639 Views | Created by AmolBadhe - Thursday, December 15, 2016 3:58 AM | Last reply by Yuliana Gu - Tuesday, December 20, 2016 6:13 AM -
0 Votes
Return csv-String from Table
Are you looking for the below stored procedure, alter procedure get_csvFormat(@tablename varchar(30)) as begin declare @cols nvarchar(3000),@sqlstrs ...Answered | 2 Replies | 1708 Views | Created by gpc442 - Wednesday, August 14, 2013 8:50 AM | Last reply by Chongtham Rajen Singh - Wednesday, August 14, 2013 10:37 AM -
0 Votes
Break down table data into multiple csv files
can you please give step by step explanation how to create a ssis package to split table into muliple CSV files with only 25000 rows in each file?Answered | 5 Replies | 1343 Views | Created by Harshac - Monday, January 27, 2020 7:46 PM | Last reply by Harshac - Friday, February 7, 2020 4:34 PM -
0 Votes
Copy data from Table A to Table B
I currently data used in the whole DB is 6888kb per row around and I have around 35,000 rows.Answered | 6 Replies | 2467 Views | Created by SQL ALTER Table Statement Help - Wednesday, July 4, 2012 3:18 PM | Last reply by SQL ALTER Table Statement Help - Thursday, July 5, 2012 6:35 AM -
0 Votes
How to Export data from SQL SERVER multiple Table Data To Single CSV file like Excel
How to Export data from SQL SERVER multiple Table Data To Single CSV file like pipe delimited format.Answered | 6 Replies | 2024 Views | Created by Niraj Sevalkar - Thursday, April 3, 2014 5:05 AM | Last reply by Olaf Helper - Wednesday, September 18, 2019 5:38 AM -
3 Votes
How to copy table data from another server?
How are you getting on with the advice / links I have already supplied?Answered | 7 Replies | 3115 Views | Created by OldEnthusiast - Saturday, March 3, 2012 10:43 AM | Last reply by Kieran Patrick Wood - Saturday, March 3, 2012 11:29 AM -
0 Votes
Copy data from InMemory-Table to Normal Table
Copying data is independent of the internal storage systemOlaf Helper [ Blog] [ Xing] [ MVP]Answered | 1 Replies | 846 Views | Created by Shaik Chandol - Friday, February 6, 2015 11:31 AM | Last reply by Olaf Helper - Friday, February 6, 2015 11:33 AM -
2 Votes
loading data from csv
In the 3rd table how are where are each columns getting the value from??Answered | 11 Replies | 3233 Views | Created by baba k - Wednesday, March 28, 2012 6:14 AM | Last reply by Sudeep Raj - Friday, March 30, 2012 11:47 AM -
0 Votes
Copy data from 2 tables
0 Insert into database2.TOTable (note the columns are different) -- ...Answered | 8 Replies | 4290 Views | Created by ski_freak - Thursday, September 2, 2010 2:11 PM | Last reply by gowithwind - Monday, September 6, 2010 3:29 PM - Items 1 to 20 of 3472497 Next ›
No announcements
