Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Importing rows from SQL Server to Excel 2007 using SSIS Expand / Collapse
Author
Message
Posted Wednesday, August 08, 2012 2:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 5:01 AM
Points: 190, Visits: 1,052
My System config if needed

Database: SQL Server 2008

OS:Windows 2008 Server

Microsoft Office 2007

64 bit M/c

I have followed following steps .

1. Added OLEDB Source to configure the Table Or View

2.Then added the Excel destination and Selected Excel 2007

when i check the package after running the package the excel file is in Microsoft Office Excel 97 - 2003

i have gone couple of technical documents.

I need to make changes in OLE DB Source

where i need to select provider as 'Native OLE DB\Microsoft Office 12.0 Access Database Engine OLE DB Provider' and select

Extended Properties=Excel 12.0

My Question,doubt and having problem is i am changing these details in source where a table or view is configured

Confused a lot
Post #1341727
Posted Friday, August 10, 2012 11:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 5:01 AM
Points: 190, Visits: 1,052

Please refer this if any body has problem with this kind of issue.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ef9fda20-4948-4e3d-920c-3cee07b55ed3?prof=required

Post #1343566
Posted Friday, August 10, 2012 11:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, April 12, 2014 9:02 PM
Points: 351, Visits: 887
That's a pretty long thread. Can you mark one of the posts as the accepted answer so people will know what there specifically fixes the issue without having to retrace all your steps?
Post #1343569
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse