Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Integration Services (SSIS), Excel Rss

   Items 1 to 14 of 14   
 

Create/write to an Excel 2007/2010 spreadsheet from an SSIS package

Excel spreadsheets are useful for distributing data generated by SQL Server, but SSIS lacks direct support for writing Excel files. EPPlus is an open source .NET library that reads/writes Excel 2007/2010 files using the Open Office XML format (XLSX). It is a mature project, and plays well with SSIS.  Read more...
By Stan Kulp 2014/02/11 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 9,447 reads

Moving Data From Excel to SQL Server - 10 Steps to Follow

SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates the advantages of the graphical approach of SSIS. Andy Brown explains.  Read more...
By Additional Articles 2013/06/13 | Source: SimpleTalk | Category: excel
Rating: (not yet rated)  Rate this |   Briefcase | 6,909 reads

Using SSIS to export data from a 64 bit server to Excel 2007

Instructions on how to set up the connection string and SSIS package to allow a 64 bit server to export to a 32 bit version of Excel  Read more...
Rating: |  Discuss |   Briefcase | 5,847 reads

Importing Data From Excel Using SSIS - Part 1

Recently while working on a project to import data from an Excel worksheet using SSIS, I realized that sometimes the SSIS Package failed even though when there were no changes in the structure/schema of the Excel worksheet. I investigated it and I noticed that the SSIS Package succeeded for some set of files, but for others it failed. I found that the structure/schema of the worksheet from both these sets of Excel files were the same, the data was the only difference. How come just changing the data can make an SSIS Package fail? What actually causes this failure? What can we do to fix it?  Read more...
By Additional Articles 2012/10/08 | Source: MSSQLTips.com | Category: etl
Rating: (not yet rated)  Rate this |   Briefcase | 3,119 reads

Using Excel Macro (.xlsm) Enabled Files in SSIS

Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel...  Read more...
By 2012/07/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,895 reads

Protect the Excel files generated by SSIS package-Part I

It is not only the data within the database that requires protection but any report generated using SQL Server needs to be protected before being mailed  Read more...
Rating: |  Discuss |   Briefcase | 5,721 reads

SQL Server 2008,Windows 2008 x64 and Excel

Learn about how you might solve some issues running SSIS packages using Excel on a Windows 2008 x64 Machine.  Read more...
Rating: |  Discuss |   Briefcase | 7,089 reads

How to Read Excel Cells from SQL Server Integration Services

We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.  Read more...
Rating: |  Discuss |   Briefcase | 13,697 reads

Use SSIS to import one cell of an Excel file into SQL Server

Recently I needed to find a method to import one cell of an Excel sheet into SQL Server 2005 using a scheduled job on a 64 bit clustered environment. For example, I have a monthly sales report listing sales per product category, such as Books, Magazines, DVDs, etc. I only want to import the Total Sales amount into SQL Server and this number is located in an Excel file "sales.xls.sheet1.cell.B5". I used to use OPENROWSET to solve the problem, however OPENROWSET requires Microsoft Jet OLE DB Provider which is not available in 64 bit. In this tip I am going to talk about how to use SSIS to accomplish this task easily.  Read more...
Rating:  Rate this |   Briefcase | 3,821 reads

How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...
By M. Deschene 2009/10/16 (first published: 2008/01/09) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 53,533 reads

How To Retrieve Excel Schema Information Using SQL Server Integration Services (SSIS) 2005

How can we determine the sheet names in our SSIS package and process this variable number of sheets?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,938 reads

SSIS and Excel 2007

Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.  Read more...
Rating: |  Discuss |   Briefcase | 14,140 reads

How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...
By M. Deschene 2009/10/16 (first published: 2008/01/09) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 53,533 reads

How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...
By M. Deschene 2009/10/16 (first published: 2008/01/09) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 53,533 reads
   Items 1 to 14 of 14   
 
Tags
extract, transform, load (etl) (2)    
blogs (1)    
epplus (1)    
etl (1)    
sql server 2005 (1)