No announcements
Found 2252412 threads
-
0 VotesSome doubts about picking data from excel sheet with SSIS
Hi friends i have some of the doubts while picking the data fro the excel sheet. some time the excel ...Answered | 4 Replies | 5983 Views | Created by SQL_BOSS - Monday, May 9, 2011 7:21 PM | Last reply by Reza Raad - Monday, May 9, 2011 7:56 PM
-
0 Votes
Import Excel sheet with SSIS
suggest is 1) some Excel magic: First, convert your original table into the form as you provided on the second picture. This way you'll have the data in ...Answered | 2 Replies | 2918 Views | Created by Sami CHNITER - Thursday, July 5, 2012 9:06 AM | Last reply by Zoltán Horváth - Thursday, July 5, 2012 11:49 AM -
0 Votes
Need to import data from Excel sheet using SSIS
I'm new to SSIS and I got a requirement to import data from Excel sheet to PROD database. I searched and looked at few articles and found the way ...Answered | 4 Replies | 616 Views | Created by Ravi Neelam - Friday, July 22, 2016 9:43 AM | Last reply by Seif Wang - Monday, July 25, 2016 8:39 AM -
0 Votes
Need to load data into formatted excel sheet from ssis
I need to be able to load data from sql server into a excel sheet with headers and fonts and columns etc formatted. I have used file file system task to ...Answered | 2 Replies | 6523 Views | Created by jjk201026 - Thursday, July 8, 2010 3:20 PM | Last reply by Nik - Shahriar Nikkhah - Thursday, July 8, 2010 5:46 PM -
3 Votes
Delete a existing excel sheet from ssis
Refer this link,Answered | 3 Replies | 5555 Views | Created by Murali dhar - Thursday, August 28, 2014 3:13 AM | Last reply by Valentino Vranken - Thursday, August 28, 2014 6:27 AM -
2 Votes
Import data from excel sheet
Hi Sarat, It is possibel the selectively import the data from the excel source.What you need is to create some sort of scenario for the ...Answered | 5 Replies | 2022 Views | Created by sarat sahoo - Monday, November 26, 2012 11:32 AM | Last reply by santhubt - Monday, November 26, 2012 2:40 PM -
0 Votes
SSIS Load Data from Multiple Sheet
Hi Experts , I am working on SSIS 2012. Objective :: Load Multiple Sheet Data of Excel into SQL table ...Answered | 1 Replies | 5727 Views | Created by Rihan8585 - Tuesday, March 12, 2013 9:37 AM | Last reply by SSISJoost - Tuesday, March 12, 2013 9:56 AM -
0 Votes
Sharepoint 2010 - Retrieve Data from Excel Sheet
OleDbConnection conn = new OleDbConnection(connstr); string strSQL = "SELECT * FROM [Sheet$]"Answered | 1 Replies | 2647 Views | Created by Melih Şimşek - Wednesday, September 5, 2012 1:09 PM | Last reply by Hemendra Agrawal - Wednesday, September 5, 2012 1:29 PM -
3 Votes
SSIS package picking unnecessary Null records for all rows from excel sheet
Hi I have 93 rows in the excel sheet but my SSIS package is piclking 229 rows actually after 93 row it is picking only NULL for all the ...Answered | 4 Replies | 5324 Views | Created by SQL_BOSS - Tuesday, May 10, 2011 12:38 AM | Last reply by SQL_BOSS - Tuesday, May 10, 2011 12:51 PM -
0 Votes
Import data from Excel sheet to SQL table SSIS package?
Have you tried OPENDATASOURCE command SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', ...Answered | 6 Replies | 4279 Views | Created by ashuthinks32 - Tuesday, September 20, 2011 7:09 AM | Last reply by Uri Dimant - Tuesday, September 20, 2011 9:29 AM -
0 Votes
SSIS excel sheet to table
That data value does not look like an Excel date/time value. Can you post some other examples, and ensure they're accurate?Answered | 2 Replies | 2767 Views | Created by Sreenu11 - Wednesday, July 27, 2011 5:21 AM | Last reply by Todd McDermid - Wednesday, July 27, 2011 4:42 PM -
0 Votes
Rename Excel Sheet using SSIS
Hello All, I have an excel sheet which is stored in .xls format i.e 97-2003 document. Every month i get this excel workbook with ...Answered | 3 Replies | 6529 Views | Created by Anji1407 - Monday, September 9, 2013 8:55 PM | Last reply by Ch. Rajen Singh - Tuesday, September 10, 2013 2:15 PM -
0 Votes
SQL Import Data From Excel sheet
good evening actually i am trying to import data from excel sheet into table , but i have an error and this is report of ...Answered | 2 Replies | 1337 Views | Created by ahmed mohamed labib - Thursday, October 1, 2015 2:19 PM | Last reply by ahmed mohamed labib - Saturday, October 3, 2015 3:00 PM -
0 Votes
Getting data from Excel file with unknown sheet name
Hi, We can create a package variable to store the sql clause, and set the data access mode of Excel Source to "SQL Command from a ...Answered | 3 Replies | 5671 Views | Created by fleo - Monday, October 26, 2009 8:27 PM | Last reply by fleo - Monday, November 2, 2009 12:43 PM -
0 Votes
Comparing Excel Sheet data with SQL Table
Hi whether it is possible to compare the excel sheet data with the sql table ? any c# code or tool ...Answered | 3 Replies | 17810 Views | Created by David Billa - Tuesday, January 29, 2013 7:18 AM | Last reply by SathyanarrayananS - Tuesday, January 29, 2013 7:56 AM -
0 Votes
Import Excel Sheet Data into List
then the Code should Import the whole Excel sheet data in that list but if list is filled with data then the code first delete that List(Test) ...Answered | 1 Replies | 8714 Views | Created by zubairmasihullah - Tuesday, March 22, 2011 5:07 AM | Last reply by nirhua165 - Tuesday, March 22, 2011 7:48 AM -
0 Votes
Sheet Names from EXCEL
I want to read the sheetnames from a excel spread sheet and i want it to appear in the same order as they exist in the spread sheet. We do not have ...Answered | 1 Replies | 11448 Views | Created by sridr1 - Friday, May 30, 2008 5:46 AM | Last reply by Kiran Polimetla - Friday, October 17, 2008 10:57 AM -
2 Votes
Decouple power pivot data from Excel sheet?
Vertipaq mode). What this means is that you *can* decouple the PowerPivot data (and data model) from the Excel workbook, and you can then ...Answered | 3 Replies | 4351 Views | Created by JustinRush - Monday, February 13, 2012 1:22 PM | Last reply by Javier Guillen - Monday, February 13, 2012 1:57 PM -
0 Votes
Some Share folder doubts
Hi, please, I need help for some share doubts. 1. When I create a share I need to maintain this with the program after ...Answered | 1 Replies | 3930 Views | Created by Micheli - Wednesday, December 10, 2008 2:07 AM | Last reply by TorstenM - Wednesday, December 10, 2008 8:36 AM -
0 Votes
How to read Data from multiple tabs of excel Sheet using SSIS
Hi, I found something ...Answered | 8 Replies | 8115 Views | Created by Ved_Prakash_ - Friday, January 4, 2013 7:54 PM | Last reply by Angel9999 - Saturday, November 23, 2013 10:09 PM - Items 1 to 20 of 2252412 Next ›
No announcements
