No announcements
Found 3472394 threads
-
0 VotesRead HTML Table and verify table data wih data in CSV file
Hi I have a HTML Table.Answered | 1 Replies | 5561 Views | Created by dotnet_beginner_butlikeitsofar - Monday, May 24, 2010 2:00 PM | Last reply by Vishnu [MSFT] - Monday, May 24, 2010 3:27 PM
-
1 Votes
Export table data with BLOB column in CSV file
Perhaps try the BCP tool ...Answered | 1 Replies | 16321 Views | Created by Irfan_masood - Wednesday, May 23, 2012 4:57 AM | Last reply by Matt Neerincx [MSFT] - Wednesday, May 23, 2012 2:21 PM -
0 Votes
Import csv-data to existing table
So how is your stored procedure is inserting the row, Is a bulk insert/bcp/Openquery command is used, or some custom made task is doing so.Answered | 2 Replies | 1705 Views | Created by Jhonny86 - Thursday, October 17, 2013 8:05 AM | Last reply by Harsh Kumar - Thursday, October 17, 2013 8:52 AM -
0 Votes
Generating csv from a table
select Col1, stuff(( select ', ' + Col2 from Test I where I.Col1=O.Col1 and I.Col3=O.Col3 order by Col2 for xml path(''), root('x'), ...Answered | 2 Replies | 2642 Views | Created by sqlbeginner - Friday, August 19, 2011 1:24 AM | Last reply by sqlbeginner - Friday, August 19, 2011 2:10 AM -
0 Votes
Copy data in large table
Hi, How about trying to generate the INSERT statements for the table using this approach - How to: Migrate a Database by Using the ...Answered | 1 Replies | 3873 Views | Created by owdev - Monday, September 17, 2012 8:24 AM | Last reply by Carlos Sardo - Monday, September 17, 2012 8:42 PM -
0 Votes
how to copy schema of a table with out copying the data.
hmm, you should rephrase your question, but imho your looking for a simple one: SELECT * INTO NewEmptyTable FROM YourTable WHERE 0 = 1 ...Answered | 1 Replies | 2584 Views | Created by Chaithanya Reddy - Monday, September 12, 2011 9:44 AM | Last reply by Stefan Hoffmann - Monday, September 12, 2011 9:47 AM -
0 Votes
copy data from a table's cell
You can access any table cell according to its name.Answered | 1 Replies | 4211 Views | Created by Sherif Magdi - Monday, March 16, 2009 1:01 PM | Last reply by Daniel Middel - Monday, March 16, 2009 1:39 PM -
0 Votes
How to insert table data into csv file
create table ww ( col1 int, col2 varchar(50), col3 varchar ...Answered | 4 Replies | 1843 Views | Created by Naveen Eshwar - Thursday, December 13, 2012 6:02 AM | Last reply by Uri Dimant - Thursday, December 13, 2012 7:46 AM -
0 Votes
SSIS Export Table data to CSV in Chucks of 10,000
Hi, Did you mean that you want to export each chunk of 10,000 records to a separate CSV file?Answered | 3 Replies | 2433 Views | Created by SQLSearcher99 - Wednesday, January 16, 2019 10:47 AM | Last reply by SQLSearcher99 - Wednesday, January 23, 2019 2:02 PM -
0 Votes
Is there an easy way to import data from a csv file to a table?
Use Execute SQL task - to purge your table (Truncate statement) and then Data Flow task with Flatfile Source and OLE DB destination .Answered | 4 Replies | 7378 Views | Created by lkubler - Monday, June 10, 2013 1:44 PM | Last reply by SQLWork - Wednesday, June 12, 2013 12:38 PM -
1 Votes
importing data from a CSV file to an SQL Table , Not working well
do you have any ideas on how to solve this issue ?Answered | 6 Replies | 1218 Views | Created by RaniaD - Tuesday, February 27, 2018 11:39 AM | Last reply by Liju Lalithangathan - Wednesday, February 28, 2018 12:35 PM -
0 Votes
T-Sql query to import data from CSV to sql Azure table.
Using C# you can directly bulk insert the data from the file to Azure SQL Server, just like a local server.Answered | 7 Replies | 1830 Views | Created by Anil kumarG - Wednesday, September 23, 2015 6:01 PM | Last reply by pituach - Saturday, September 26, 2015 8:07 PM -
0 Votes
copy data from datatable to database table
this link is really helpful.Answered | 1 Replies | 2727 Views | Created by sqldeveloper2008 - Friday, July 13, 2012 8:03 AM | Last reply by RohitArora - Friday, July 13, 2012 8:17 AM -
1 Votes
How to merge/replace data in a table when importing new data from csv
I believe I understand how the lookup transformation works not sure how to apply it exactly to what I am trying to do without duplicating my insert logic as it splits ...Answered | 4 Replies | 2726 Views | Created by JasonDWilson77 - Wednesday, February 18, 2015 3:43 PM | Last reply by JasonDWilson77 - Friday, February 20, 2015 4:59 PM -
0 Votes
How to export certain columns from a SQL table out to CSV file
Hi all I have a requirement to export data from a SQL Server 2012 table, to a CSV file.Answered | 3 Replies | 4622 Views | Created by ANSA_Naz - Monday, August 24, 2015 3:24 PM | Last reply by Milan Das - Monday, August 24, 2015 4:15 PM -
0 Votes
Problem in loading data from SQL table to CSV file
Hello Sai, In the query you are using for the extract, replace the Message field with the following REPLACE(REPLACE([Message],CHAR(10), ''), CHAR(13), '') AS ...Answered | 3 Replies | 1711 Views | Created by Sai.N - Tuesday, May 7, 2013 6:02 AM | Last reply by Mayorlag - Tuesday, May 7, 2013 10:46 AM -
0 Votes
Inserting data from Csv file
I'd use a Data Flow with a Flat File Source defined with ONE column - a long string column.Answered | 7 Replies | 2982 Views | Created by mm6991 - Friday, February 17, 2012 6:17 PM | Last reply by Todd McDermid - Saturday, February 18, 2012 1:19 AM -
2 Votes
Pipeline copy activity failed while copying data from .csv to azure sql
The error means your csv file has more columns than your specified schema.Answered | 2 Replies | 1554 Views | Created by Naresh kadali - Wednesday, December 5, 2018 9:53 AM | Last reply by Naresh kadali - Thursday, December 6, 2018 9:34 AM -
0 Votes
Updating list of tables from CSV file based on columns in CSV
I would recommend you check the commercial COZYROC Data Flow Task Plus.Answered | 4 Replies | 1747 Views | Created by harish babu y - Tuesday, June 16, 2015 10:59 AM | Last reply by ryguy72 - Wednesday, June 17, 2015 4:29 PM -
8 Votes
Copy Table from another table
Here's how:Suppose you're trying to copy the authors table of the Pubs SQL Server database with data and structure.Answered | 8 Replies | 80126 Views | Created by Muralidharan - Monday, May 16, 2005 7:38 AM | Last reply by Khilitchandra Prajapati - Friday, July 13, 2012 1:56 PM
No announcements
