No announcements
Found 1134300 threads
-
0 VotesSplit one CSV into multiple
So what I’m looking for is the ability to split a csv into multiple, based on a single column, and give it a name of my choosing (aside from the building ...Answered | 12 Replies | 3622 Views | Created by hellbus - Monday, August 20, 2018 6:34 PM | Last reply by hellbus - Tuesday, August 21, 2018 2:14 PM
-
0 Votes
Splitting multiple tables stacked in one csv file.
Hi Joe, one query can only return one table.Answered | 2 Replies | 3353 Views | Created by Joe Jordans - Monday, August 10, 2020 4:55 AM | Last reply by Ehren - MSFT - Tuesday, August 25, 2020 6:58 PM -
0 Votes
import a CSV file to split one column to two
Hi, here is an example how to split single value into multiple columns by using derived column transformation.Answered | 3 Replies | 1221 Views | Created by sourises - Tuesday, June 28, 2016 7:19 PM | Last reply by Aamir Shahzad Warraich - Tuesday, June 28, 2016 8:09 PM -
0 Votes
HELP - Splitting a large CSV into Smaller CSVs based on field value
Inside loop add a Data flow with file source to point to your CSV.Answered | 2 Replies | 2898 Views | Created by Anotherspot - Monday, July 7, 2014 6:58 AM | Last reply by Visakh16 - Monday, July 7, 2014 9:19 AM -
5 Votes
How do I split a Large CSV file into Multiple CSV's Using Powershell
I think this might be what you want: Import-Csv applications.csv | Group Application | foreach { $_.Group | Export-Csv ...Answered | 4 Replies | 3307 Views | Created by Karunanidhi Mishra - Thursday, October 30, 2014 9:06 AM | Last reply by jrv - Thursday, October 30, 2014 4:29 PM -
0 Votes
Split one data file (MDF) to multiple files
If your SQL Server Installation is SQL Server 2005 U can use Table Partitioned to split large table itu multiple files.Answered | 2 Replies | 10228 Views | Created by sql_guy - Monday, May 18, 2009 11:50 AM | Last reply by Andrian Setiawan - Monday, May 18, 2009 12:04 PM -
1 Votes
How to split one worksheet into multiple worksheets?
The result was one worksheet of data for each iteration of the query.Answered | 7 Replies | 13276 Views | Created by williamwong - Thursday, February 18, 2016 2:52 PM | Last reply by albertan6106 - Thursday, August 8, 2019 5:40 AM -
0 Votes
Split the Flatfile data into multiple Flatfiles
chk the Jamie's blog for the same..This may give you some idea...Answered | 4 Replies | 2291 Views | Created by Forum Solution - Thursday, September 20, 2012 10:30 AM | Last reply by SSISJoost - Thursday, September 20, 2012 12:30 PM -
0 Votes
Extracting Data from Multiple csv Files to create one CSV FIl
Pick any one and start.Answered | 12 Replies | 3045 Views | Created by Lockett916 - Thursday, June 30, 2016 3:12 PM | Last reply by jrv - Friday, July 1, 2016 5:49 PM -
0 Votes
Importing CSV files into Multiple Tables in One Database
You stated that I will be able to to load both in one package.Answered | 2 Replies | 2585 Views | Created by Y_Tyler - Wednesday, February 26, 2014 5:49 PM | Last reply by Y_Tyler - Wednesday, February 26, 2014 7:17 PM -
3 Votes
Combining Multiple CSV Files with Powershell
The following example takes two valid csv files, one with 'FirstName' and 'LastName', and the second with 'City' columns.Answered | 24 Replies | 32417 Views | Created by alan_the_geek - Wednesday, December 7, 2011 11:47 AM | Last reply by jrv - Tuesday, May 24, 2016 10:35 PM -
1 Votes
Hyper-V Replica Broker to multiple CSVs
We are in the initial planning/setting up phase for Replicas on a DR site using Failover clusters and I have just come across this issue - we have multiple CSVs ...Answered | 10 Replies | 5205 Views | Created by Brian Gilmore - Monday, February 16, 2015 9:50 PM | Last reply by richsmif - Tuesday, October 31, 2017 2:27 PM -
4 Votes
Copy multiple .csv files into one workbook
That worked to get them into one Excel Workbook.Answered | 12 Replies | 23719 Views | Created by CSafreed - Monday, May 3, 2010 10:38 PM | Last reply by OldDog1 - Friday, March 25, 2011 3:47 PM -
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 | 1197 Views | Created by Harshac - Monday, January 27, 2020 7:46 PM | Last reply by Harshac - Friday, February 7, 2020 4:34 PM -
1 Votes
multiple conditional split
You can configure the Script Component to have multiple outputs, and use this as a Conditional Split - but it will take even more effort than using the Conditional Split.Answered | 6 Replies | 3321 Views | Created by devpan - Saturday, September 26, 2009 7:36 PM | Last reply by Todd McDermid - Monday, September 28, 2009 3:32 PM -
0 Votes
Exporting multiple email addresses to CSV
You can also script it use for multiple email address from a file.Answered | 11 Replies | 16501 Views | Created by RTEAL - Wednesday, January 19, 2011 4:03 AM | Last reply by AndroidV - Friday, October 25, 2013 9:03 AM -
0 Votes
Split data into multiple worksheets
What split?Answered | 10 Replies | 1063 Views | Created by _H_R - Tuesday, August 2, 2016 3:00 PM | Last reply by jrv - Thursday, August 4, 2016 6:25 PM -
0 Votes
Reports Split into Multiple Pages?
If you set KeepTogether = False, then it'll be multiple pages (depending upon what 'page size' you set for your report in other areas), if True, then it'll try to keep it ...Answered | 1 Replies | 3226 Views | Created by [MattB] - Wednesday, November 9, 2011 3:32 PM | Last reply by Sherry Kissinger - Wednesday, November 9, 2011 5:03 PM -
0 Votes
how to split a multiple VCF card
There are multiple solution available for converting VCF to PST file format.Answered | 4 Replies | 2958 Views | Created by how to split a multiple vcf card - Thursday, November 8, 2012 10:44 AM | Last reply by Henrik Jordan - Wednesday, July 18, 2018 10:35 AM -
0 Votes
Split one row into multiple rows
Hi, I have a row like below Date, A, B, ...Answered | 2 Replies | 10261 Views | Created by bonosungho - Friday, January 27, 2012 2:31 AM | Last reply by Vinay Valeti - Friday, January 27, 2012 5:19 AM - Items 1 to 20 of 1134300 Next ›
No announcements
