No announcements
Found 2431843 threads
-
2 VotesHow to import-csv to a table
I can see that the command text gets populated well but the values are not evaluated INSERT INTO TMP_APPLE_EXPORT (PRODUCT_ID,QTY_SOLD,QTY_AVAILABLE) ...Answered | 5 Replies | 11017 Views | Created by duanewilson - Wednesday, August 4, 2010 8:40 PM | Last reply by Jayesh Yeragi - Friday, April 25, 2014 2:15 AM
-
0 Votes
Importing Csv files as multiple tables
You can get multiple tables in a query only, but you can not load them into workbook or model as it does not make any sense.Answered | 2 Replies | 2618 Views | Created by Minority Report - Sunday, December 31, 2017 4:26 PM | Last reply by Tom J Sun - Wednesday, January 3, 2018 6:00 AM -
1 Votes
Automate Import of CSV files
http://stackoverflow.com/questions/6061075/how-can-i-load-a-large-flat-file-into-a-database-table-using-ssis Knowledge is the ...Answered | 4 Replies | 3616 Views | Created by ProfessorFudger - Tuesday, January 26, 2016 1:03 PM | Last reply by ryguy72 - Sunday, February 21, 2016 2:32 PM -
0 Votes
SQL 2014 - How to import all CSV files in a folder into a single table.
I have confirmed location and CSV type.Answered | 6 Replies | 21177 Views | Created by Akhil85 - Tuesday, May 17, 2016 12:26 PM | Last reply by Akhil85 - Thursday, May 19, 2016 2:48 PM -
0 Votes
Importing CSV files into Multiple Tables in One Database
Using the example you provided, i am confident that I can create the package using one path into one table but not sure ...Answered | 2 Replies | 2586 Views | Created by Y_Tyler - Wednesday, February 26, 2014 5:49 PM | Last reply by Y_Tyler - Wednesday, February 26, 2014 7:17 PM -
0 Votes
Import csv into fact table
Hello, I have a csv/txt file with a lot of rows (in millions) that need to be loaded into a data ...Answered | 1 Replies | 2604 Views | Created by Shaiwin - Wednesday, April 17, 2013 10:26 PM | Last reply by Bendare2 - Thursday, April 18, 2013 12:23 AM -
1 Votes
transform csv file before importing into stage table
Hi, I was able to use the Unpivot transform task and it comes into the table with the correct format.Answered | 9 Replies | 2485 Views | Created by ScottCabral - Tuesday, December 16, 2014 3:51 PM | Last reply by ScottCabral - Wednesday, December 17, 2014 4:17 PM -
2 Votes
importing data to csv file
Thanks Reza, I am able to do.. but how to handle the "," with in the data like if address has a comma within it then data after comma will go ...Answered | 3 Replies | 5324 Views | Created by Eswararao C - Tuesday, May 17, 2011 4:27 AM | Last reply by Reza Raad - Tuesday, May 17, 2011 5:07 AM -
0 Votes
Importing CSV file problem.
Personally, if the CSV files aren't too large I would write a simple powershell script to parse the files and add in any missing fields.Answered | 3 Replies | 2149 Views | Created by Johnny Bell Jnr - Wednesday, January 2, 2013 12:53 PM | Last reply by Johnny Bell Jnr - Thursday, January 3, 2013 1:38 PM -
0 Votes
Import multiple .csv to multiple sql 2005 tables
I was planning on putting each format in it's own folder and the .csv files from each format folder into a separate table, so 3 tables ...Answered | 5 Replies | 4239 Views | Created by tanksoldier - Wednesday, July 14, 2010 10:30 PM | Last reply by Nik - Shahriar Nikkhah - Thursday, July 15, 2010 5:56 PM -
0 Votes
Import-csv file for robocopy
I agree with jrv, do some reading to get a basic understanding of the concepts The script I posted was just an example of how to enclose the data in ...Answered | 9 Replies | 9427 Views | Created by Piet200 - Wednesday, January 28, 2015 2:50 PM | Last reply by Piet200 - Friday, January 30, 2015 8:30 AM -
0 Votes
Import csv file
you shall have it text qualified in this case if the supplying party objects then no choice but to replace the line endings in it with a different delimiter as pre-processing step, ...Answered | 1 Replies | 918 Views | Created by Rajkm - Friday, May 15, 2015 3:03 PM | Last reply by ArthurZ - Friday, May 15, 2015 3:10 PM -
0 Votes
How can I Import-Csv a csv file that has multi-line fields
Lac*, Yes, its better that you post a copy of the csv file that you'd like to process it.Answered | 6 Replies | 3257 Views | Created by lacrosse1991 - Wednesday, February 3, 2016 10:19 PM | Last reply by hpotsirhc - Thursday, February 4, 2016 2:05 PM -
0 Votes
How to create CSV file
You can then just change the details in the csv file and then import them again.Answered | 1 Replies | 3436 Views | Created by Amarneh - Wednesday, January 21, 2009 1:39 PM | Last reply by Paul Steynberg - Wednesday, January 21, 2009 4:10 PM -
0 Votes
Creating a Staging Table from CSV file directly
[You can replace couple of things with user::variables] Now, things like how to create such command and verifying the existence of table, ...Answered | 7 Replies | 10510 Views | Created by MSCRMrocks - Thursday, August 30, 2012 6:12 AM | Last reply by Prasoon Pathak - Thursday, August 30, 2012 8:36 PM -
1 Votes
Importing .CSV file to Sql Server
You also can try bulk insert SQL to import .CSV file Please refer to - ...Answered | 4 Replies | 11995 Views | Created by sinner1988 - Wednesday, May 30, 2012 10:00 PM | Last reply by BIWORK - Thursday, May 31, 2012 4:53 AM -
0 Votes
Is there an easy way to import data from a csv file to a table?
Hi Linn, You can use Import and Export wizard in SSMS to import CSV to database table ...Answered | 4 Replies | 7212 Views | Created by lkubler - Monday, June 10, 2013 1:44 PM | Last reply by SQLWork - Wednesday, June 12, 2013 12:38 PM -
0 Votes
SSIS how to import lists of .csv file name and files and .csv by using import column
Database table: CREATE TABLE [dbo].Answered | 2 Replies | 2888 Views | Created by Paul40H - Monday, September 19, 2016 8:52 PM | Last reply by Seif Wang - Wednesday, September 21, 2016 2:28 AM -
2 Votes
importing .csv files
Writing a log file after processing each .csv that contains the .csv filenames then have the script check for the string in the log file before doing the ...Answered | 5 Replies | 8923 Views | Created by rob.irvin - Thursday, September 13, 2012 9:25 PM | Last reply by Yan Li_ - Monday, September 17, 2012 9:42 AM -
0 Votes
SSIS - Import from CSV to Staging Table
--The CSV file contains data as ...Answered | 3 Replies | 2875 Views | Created by Kazmi512 - Friday, April 15, 2016 6:50 AM | Last reply by Eric__Zhang - Monday, April 18, 2016 6:48 AM - Items 1 to 20 of 2431843 Next ›
No announcements
