No announcements
Found 3195926 threads
-
0 Votes
Upload CSV file to multiple tables
check this out http://plexussql.blogspot.com/2010/06/looping-through-csv-files-using-ssis.html it's a CSV file to a single ...Answered | 2 Replies | 4801 Views | Created by Amaka - Friday, July 16, 2010 2:22 AM | Last reply by Nik - Shahriar Nikkhah - Friday, July 16, 2010 3:37 AM -
1 Votes
Load a CSV file with potential new columns into SQL Server table
Hi Joss, I would start by setting up a Data Flow Task to create your .csv file.Answered | 3 Replies | 860 Views | Created by Joss83 - Tuesday, December 6, 2016 2:34 PM | Last reply by Eric__Zhang - Wednesday, December 7, 2016 2:51 AM -
0 Votes
how to get the empty lines between the todays data and tommorows data in csv file using ssis package
Besides the Script Task you could also try something with the FLAT FILE Destination Component.Answered | 8 Replies | 1257 Views | Created by lakshmisudha - Wednesday, April 17, 2013 4:21 AM | Last reply by SSISJoost - Wednesday, April 17, 2013 9:52 AM -
0 Votes
Read/Write CSV file from Azure Blob Storage using Python
You may refer to the suggestions mentioned in the SO link.Answered | 1 Replies | 13716 Views | Created by SudiptoNag - Friday, November 10, 2017 7:10 AM | Last reply by SumanthMarigowda-MSFT - Friday, November 10, 2017 4:45 PM -
1 Votes
Getting error on null and empty string while copying a csv file from blob container to Azure SQL DB
You can use dataflow and check if you want to write NULL, empty string or convert to another value.Answered | 2 Replies | 1274 Views | Created by zzzsharepoint - Sunday, December 15, 2019 2:39 PM | Last reply by dataflowuser - Sunday, December 15, 2019 7:10 PM -
0 Votes
Is there a way to add audit columns to sql dw tables while copying from blob storage?
I was able to use auto create option along with csv files in blob storage.Answered | 5 Replies | 893 Views | Created by Kuharan Bhowmik - Wednesday, November 27, 2019 8:35 AM | Last reply by Vaibhav.Chaudhari - Friday, November 29, 2019 12:45 PM -
0 Votes
Problem with FST moving multiple CSV files
You are passing Daily*.csv to file system task.Answered | 7 Replies | 2286 Views | Created by Radhai - Thursday, April 4, 2013 1:08 PM | Last reply by Nitesh Rai - Thursday, April 4, 2013 1:59 PM -
3 Votes
How to copy multiple files using task
As I alrady said, disk operations will not benefit from Multithreading or -tasking.Answered | 9 Replies | 5217 Views | Created by Mou_kolkata - Monday, April 25, 2016 9:26 AM | Last reply by Sudip_inn - Sunday, December 8, 2019 4:13 PM -
0 Votes
process daily file
processing daily is nothing but scheduling the job.Answered | 3 Replies | 1516 Views | Created by john shaji - Tuesday, February 5, 2013 2:43 PM | Last reply by Eileen Zhao - Tuesday, February 12, 2013 8:21 AM -
0 Votes
Copy multiple containers from Storage Account
I also have a foreach step and within that step I have an activity Copy Data The Copy Data contains a ...Answered | 12 Replies | 1015 Views | Created by RalJans - Friday, August 31, 2018 7:05 AM | Last reply by RalJans - Sunday, September 2, 2018 12:25 AM -
0 Votes
Creating CSV files for multiple tables with tables names in a table
I then have the arrow pointing from the SQL Execution Task into a Data Flow Task Inside the Data Flow ...Answered | 2 Replies | 3262 Views | Created by NEW2BI - Friday, June 11, 2010 3:23 PM | Last reply by NEW2BI - Saturday, June 12, 2010 1:00 AM -
0 Votes
Importing .csv file where file name changes
[Daily_File] from ' + @fullpath1 + ' with (FIELDTERMINATOR = ''\t'', FIRSTROW = 2, ROWTERMINATOR=''0x0a'')' exec (@cmd1) This the previous day's ...Answered | 6 Replies | 4454 Views | Created by Diango - Monday, June 30, 2014 10:43 PM | Last reply by ryguy72 - Tuesday, July 15, 2014 10:17 PM -
0 Votes
Convert .csv file to .xls file using Script task in SSIS 2008
If you want to use a Script Task then you could better ask this question in a .Net forum.Answered | 2 Replies | 13767 Views | Created by Supreeth TR - Tuesday, January 8, 2013 10:49 AM | Last reply by SSISJoost - Tuesday, January 8, 2013 1:09 PM -
0 Votes
SSIS 2008 – Read roughly 50 CSV files from a folder, create SQL table from them dynamically, and dump data.
The control flow has two components, Script Task which reads the file name from the source folder and the data flow task.Answered | 10 Replies | 1413 Views | Created by Ankit Himmatlal Shah - Saturday, April 18, 2015 1:17 PM | Last reply by Harry Bal - Tuesday, April 21, 2015 7:23 PM -
0 Votes
Loading multiple .csv files into a table using SSIS
Assuming that the files follow a naming convention, you could use the For Each Loop container to open flat file sources for the files needed for a ...Answered | 4 Replies | 3772 Views | Created by vtripathi - Thursday, March 27, 2014 10:24 AM | Last reply by COZYROC - Thursday, March 27, 2014 8:12 PM -
1 Votes
Copy 100s of SQL tables
If you need to copy the data to identical tables in another database daily, I would highly suggest using replication.Answered | 10 Replies | 834 Views | Created by Raj_MSBI - Wednesday, June 1, 2016 4:07 PM | Last reply by Stan210 - Thursday, June 2, 2016 4:35 PM -
3 Votes
multiple tasks work with single file in a storage account
ResourceFiles are about downloading the files from storage though, which means before each of your tasks start, if you specify a ResourceFile on ...Answered | 6 Replies | 1067 Views | Created by PaulHKim - Wednesday, October 19, 2016 5:13 PM | Last reply by PaulHKim - Monday, October 31, 2016 2:49 PM -
0 Votes
Importing CSV files into Multiple Tables in One Database
All will have the same fields, just coming from different programs.Answered | 2 Replies | 2712 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
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 | 2921 Views | Created by mm6991 - Friday, February 17, 2012 6:17 PM | Last reply by Todd McDermid - Saturday, February 18, 2012 1:19 AM -
1 Votes
Copy Azure Tables Between Storage Accounts
Unfortunately transferring to/from tables is no longer supported in AzCopy.Answered | 5 Replies | 10785 Views | Created by KenAtDIFZ - Friday, July 10, 2015 5:30 PM | Last reply by SumanthMarigowda-MSFT - Monday, November 18, 2019 5:28 AM
No announcements