No announcements
Found 955640 threads
-
0 VotesLoop through excel file sheets in ssis
If you have to filter the list for only worksheets or only named ranges, you may have to write custom code in a Script task for this purpose.'Answered | 15 Replies | 9952 Views | Created by Naveen Mbv - Thursday, February 12, 2015 10:22 AM | Last reply by Naveen Mbv - Monday, February 16, 2015 7:13 PM
-
1 Votes
Loop through array of Excel sheets
Sub Test() Sheets.Select With Sheets(1) .Range("A1") = "Nr" .Range("A2") = 9 ...Answered | 2 Replies | 604 Views | Created by ryguy72 - Sunday, July 31, 2016 3:03 AM | Last reply by ryguy72 - Tuesday, August 2, 2016 3:03 PM -
0 Votes
Loop Query Through Date Range
Here are my two Cents, please see this link: How to import data from Excel to SQL Server and Exporting SQL Server Data to ...Answered | 2 Replies | 2029 Views | Created by Dan86 - Thursday, August 29, 2013 5:30 PM | Last reply by Saeid Hasani - Thursday, August 29, 2013 7:15 PM -
0 Votes
Loop through Excel files in SSIS
Take a Foreach loop and inside it take a DFT Edit the For Each Loop: Collection: Foreach ADO.NET Shema Rowset ...Answered | 8 Replies | 6653 Views | Created by Milli_22 - Tuesday, November 3, 2009 2:43 PM | Last reply by Sudeep Raj - Tuesday, November 3, 2009 5:01 PM -
0 Votes
Loop through Excel workbooks and sheets.
Hi, this might be helpful How to Read Excel Sheet Data after Skipping Rows in SSIS Package by using Script Task - SSIS ...Answered | 8 Replies | 1255 Views | Created by aivoryuk - Friday, May 27, 2016 10:25 AM | Last reply by aivoryuk - Friday, June 3, 2016 1:42 PM -
0 Votes
Loop through Excel File with multiple worksheets
Have a For Each loop with file Enumerator to loop through files 2.Answered | 3 Replies | 2677 Views | Created by Vikash Karra - Thursday, June 29, 2017 6:28 PM | Last reply by Visakh16 - Friday, June 30, 2017 5:07 PM -
2 Votes
Looping through month in a range of dates?
SELECT DATEDIFF(MONTH,'19000101','20090101') For more information, I would suggest you have a look at the link ...Answered | 3 Replies | 52522 Views | Created by rbhatup - Friday, November 25, 2011 3:01 PM | Last reply by KJian_ - Monday, November 28, 2011 7:49 AM -
1 Votes
How to loop through unique values in the pivot table filter field?
On the pivot table tab of Excel under the 'pivot table name' is a dropdown called 'options'.Answered | 5 Replies | 670 Views | Created by egrantz - Friday, January 30, 2015 5:57 PM | Last reply by Dogubob - Wednesday, February 4, 2015 6:35 PM -
0 Votes
loop through the excel files in folder and sub folder
Take a look at the Foreach Loop.Answered | 1 Replies | 1136 Views | Created by Alpula Srinivas - Wednesday, January 28, 2015 1:23 PM | Last reply by Andy Tauber - Wednesday, January 28, 2015 4:43 PM -
1 Votes
Looping through two unions of non-contiguous ranges
Each separate range of the Union is an Area and you work in the Areas of the Unions.Answered | 2 Replies | 3407 Views | Created by NiklasKokeritz - Thursday, February 16, 2012 2:38 PM | Last reply by OssieMac - Thursday, February 16, 2012 8:08 PM -
0 Votes
How to loop through Excel files in SSIS
can you provide me some link by which i can perform this task first i want to know about how can we add data of five different file having same column ...Answered | 10 Replies | 8146 Views | Created by Ajay Singh Rawat - Tuesday, April 17, 2012 10:57 AM | Last reply by Christa Kurschat - Tuesday, April 17, 2012 12:20 PM -
0 Votes
How to loop through records in a query and write to Excel?
The looping code, even if corrected, is looping with recordset rs, but the code inside the loop is getting values from MyRecordset.Answered | 6 Replies | 1261 Views | Created by ryguy72 - Wednesday, May 11, 2016 3:45 PM | Last reply by ryguy72 - Wednesday, May 11, 2016 6:21 PM -
0 Votes
Range & Filters
Once filtered , I want t be able to find the row number for the filtered data Well, you have to get the Range of the filtered data!Answered | 2 Replies | 428 Views | Created by py1 - Tuesday, October 27, 2015 11:09 AM | Last reply by py1 - Tuesday, October 27, 2015 1:47 PM -
0 Votes
Link Multiple Excel doc to access, loop through SubFolders
SubPlanner, use the code mentioned below to loop through sub folders.Answered | 5 Replies | 544 Views | Created by SubPlanner - Wednesday, November 30, 2016 3:15 PM | Last reply by .theDBguy - Thursday, December 1, 2016 6:25 PM -
6 Votes
Need fastest for loop to export to excel.
Here are some very good examples for using Range ion Excel ...Answered | 15 Replies | 588 Views | Created by ID GO - Saturday, April 2, 2016 8:40 AM | Last reply by Cyrille Précetti - Monday, April 4, 2016 7:32 AM -
1 Votes
Excel "Filtered Range Copy to Word" bug
You are right that it has nothing to do with auto filter.Answered | 4 Replies | 2937 Views | Created by Abhimanyu Sirohi - Tuesday, February 14, 2012 5:36 AM | Last reply by Abhimanyu Sirohi - Wednesday, February 15, 2012 12:31 PM -
0 Votes
loop in a loop with excel
Hi Abdus, For this requirement, you could loop cells and using Range.Find method to find the corresponding value in specify range.Answered | 3 Replies | 552 Views | Created by Abdus Sattar - Tuesday, January 5, 2016 2:18 PM | Last reply by Starian chen - Thursday, January 7, 2016 2:27 AM -
0 Votes
How Do I get SSIS To Stop Looping Through Excel Rows After Last Populated Record?
Another way is to specify the range in select statement which can be done in two ...Answered | 3 Replies | 1140 Views | Created by jsorrisone - Friday, January 23, 2015 8:58 PM | Last reply by Visakh16 - Sunday, January 25, 2015 7:08 AM -
0 Votes
Looping through Summary Tasks in VBA
Some of the data I do need at the individual task level for reporting but for those I run a seperate module through the entire project to fill down the custom ...Answered | 5 Replies | 1799 Views | Created by pd240 - Thursday, May 18, 2017 12:39 PM | Last reply by John - Project - Friday, May 26, 2017 1:50 AM -
0 Votes
How to write a for-loop to search a range?
Hi , We could not compare a entire row at one time, instead we need to compare them cell by cell, please refer to following ...Answered | 2 Replies | 3372 Views | Created by 2Chucky - Thursday, February 26, 2009 7:12 PM | Last reply by 2Chucky - Friday, March 6, 2009 6:58 PM - Items 1 to 20 of 955640 Next ›
No announcements
