No announcements
Found 3195926 threads
-
0 VotesWhy daily copy task from Table Storage empty CSV file?
My destination Data lake CSV file is empty after scheduled Copy task is run.Answered | 3 Replies | 556 Views | Created by Kenny_I - Saturday, December 10, 2016 9:56 AM | Last reply by Alexandre Gattiker - Tuesday, December 13, 2016 5:25 PM
-
0 Votes
Exporting data from SQL SERVER tables to a new CSV file daily
You can also use power shell for achieving this, below is the example http://msexchange.me/2013/08/03/export-to-csv-from-sql-table/Sukhija VikasAnswered | 11 Replies | 5467 Views | Created by SQL2012BI - Monday, September 10, 2012 9:27 AM | Last reply by The Tech Wizard - Sunday, March 9, 2014 4:37 AM -
0 Votes
Loading from CSV file to Sqlserver Table
All the script components work only on the CSV file but not the underlying table.Answered | 5 Replies | 5485 Views | Created by NedunuriRajesh - Friday, August 23, 2013 10:41 PM | Last reply by NedunuriRajesh - Thursday, August 29, 2013 6:52 PM -
0 Votes
Destination Flat File creates empty row at end of csv file
If you do not want that you could use a script task to delete the last line after the data flow task.Answered | 1 Replies | 5542 Views | Created by JSanden - Friday, February 4, 2011 8:17 PM | Last reply by Sudeep Raj - Friday, February 4, 2011 8:37 PM -
0 Votes
Copy Task for Empty Sub directories, Copy Count and Files List
Copy task .Answered | 4 Replies | 1114 Views | Created by Venh - Thursday, May 14, 2020 5:48 PM | Last reply by ranta - Tuesday, May 19, 2020 2:45 PM -
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 | 10853 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
exporting data from hive table to csv file.
The CREATE TABLE command moves the data file to the /hive/warehouse/<TableName> directory on default storage for the cluster.Answered | 2 Replies | 10995 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
Updating list of tables from CSV file based on columns in CSV
Check this article which talks about dynamic columns in CSV file.Answered | 4 Replies | 1712 Views | Created by harish babu y - Tuesday, June 16, 2015 10:59 AM | Last reply by ryguy72 - Wednesday, June 17, 2015 4:29 PM -
0 Votes
Creating a Staging Table from CSV file directly
We just want to pass the input csv using which the table should be created dynamically.Answered | 7 Replies | 10746 Views | Created by MSCRMrocks - Thursday, August 30, 2012 6:12 AM | Last reply by Prasoon Pathak - Thursday, August 30, 2012 8:36 PM -
0 Votes
from csv file to access 2003 table.. unicode , nonunicode conversion error
In fact, when I imported the csv file, I did check the advanced editor for this flat file and the output columns are all [DT_STR].Answered | 5 Replies | 3162 Views | Created by cat_ca - Monday, August 23, 2010 4:43 PM | Last reply by cat_ca - Monday, August 23, 2010 6:09 PM -
0 Votes
Azure Table Storage Excel CSV Error
Also ...Do I need to include the Timestamp column in my excel file?Answered | 6 Replies | 2431 Views | Created by DDL19 - Tuesday, August 1, 2017 9:27 PM | Last reply by Md Shihab - Sunday, August 6, 2017 8:22 AM -
0 Votes
Copy file from Web App to Storage
Hi David, Modify your webapp at the points you read/write to wwwroot and read/write from/to the blob storage instead (see link from ...Answered | 8 Replies | 3403 Views | Created by Davide D'Angelo - Tuesday, May 15, 2018 10:46 AM | Last reply by Sandeep BR - Saturday, May 26, 2018 7:32 PM -
0 Votes
Automatic Updating Table from CSV file
The job can have 2 steps; 1. use BCP to load the csv file into a staging table, who's schema is exactly the same as the file ...Answered | 2 Replies | 8783 Views | Created by Steigeisen - Tuesday, July 23, 2013 11:33 PM | Last reply by Sanil Mhatre - Wednesday, July 24, 2013 2:51 AM -
1 Votes
Copy JSON files from Blob storage as csv to Data lake
Hi VairavanS In ADLA, my problem was extracting the files in 3 columns at first as strings (Id, Timestamp, Includes) which caused the last column to be over size ...Answered | 3 Replies | 955 Views | Created by okmijn - Friday, June 1, 2018 6:06 AM | Last reply by VairavanS (Azure) - Monday, June 4, 2018 5:30 PM -
0 Votes
Mapping a CSV file fields
KevinATF, I try to create a table like yours and try to made a test with 2 csv files.Answered | 6 Replies | 449 Views | Created by KevinATF - Friday, April 20, 2018 8:07 PM | Last reply by .theDBguy - Monday, April 23, 2018 8:18 PM -
2 Votes
Copy File from Azure Storage Fileshare to FTP
Logic Apps help you connect legacy, modern, and cutting-edge systems more easily.Answered | 2 Replies | 1006 Views | Created by Sohi420 - Wednesday, December 18, 2019 1:50 AM | Last reply by Lily Lii - Wednesday, December 18, 2019 7:53 AM -
0 Votes
SSIS -import date from csv file and convert to null if date empty.
Hi, You can use derived column to achieve your task, Refer to link below for knowing more on derived column.Answered | 1 Replies | 5312 Views | Created by pandaKid - Wednesday, October 30, 2013 8:44 AM | Last reply by Naveen Kumar K.R - Wednesday, October 30, 2013 9:00 AM -
2 Votes
Send notifiEcation on a Empty CSV file
It will not be the FILE adapter but we will be taking the data from the SFTP server.Answered | 15 Replies | 991 Views | Created by Sid_2014 - Thursday, June 9, 2016 1:24 PM | Last reply by Rachit Sikroria - Thursday, June 16, 2016 6:50 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 | 7324 Views | Created by lkubler - Monday, June 10, 2013 1:44 PM | Last reply by SQLWork - Wednesday, June 12, 2013 12:38 PM -
0 Votes
How to copy data from CSV to Table
it is me be because of some NULL or special character which have been separated value in starting Row or column...Please re-look the file and import again.Answered | 3 Replies | 2052 Views | Created by ryguy72 - Friday, September 13, 2013 1:53 AM | Last reply by ryguy72 - Friday, September 13, 2013 3:31 AM - Items 1 to 20 of 3195926 Next ›
No announcements
