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

How to use .xlsb file in SSIS 2005 Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 5:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 3:57 AM
Points: 93, Visits: 237
Hi,

I have .xlsb file. It has been used as a source and to insert the data to staging table using ssis 2005.

Please let me know how to use .xlsb file in SSIS 2005

Regards
SqlStud
Post #1352119
Posted Thursday, August 30, 2012 9:05 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, September 8, 2013 9:25 AM
Points: 96, Visits: 495
Hi sqlstud,

Right click in the Connection Managers window and select New File Connection. Next, click browse and select the xlsb file. You can then use code like (VB)
Public Sub Main()
Try
Dim MyCon As ConnectionManager = Dts.Connections("Book1.xlsb")
'Enter your code here
Dts.TaskResult = ScriptResults.Success
Catch ex As Exception
MsgBox(ex.Message)
Dts.TaskResult = ScriptResults.Failure
End Try
End Sub
Hopefully this helps!


Regards:
Mordred
Keep on Coding in the Free World
Post #1352302
Posted Friday, August 31, 2012 4:49 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 3:57 AM
Points: 93, Visits: 237
Hi,

I am using SSIS 2005. IF SSIS 2008, we have MS Office 2007 provider

So,As usual, created new OLEDB connection by choosing the provider Microsoft.ACE.OLEDB.12.0 and set Extended Properties=Excel 12.0;

But got the attached Error


Regards
SqlStud


  Post Attachments 
xlsb Error.jpg (9 views, 25.40 KB)
Post #1352695
Posted Tuesday, September 4, 2012 4:02 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 3:57 AM
Points: 93, Visits: 237
Hi,

IS there any solution?
Post #1353793
Posted Friday, September 21, 2012 10:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:27 PM
Points: 7,127, Visits: 12,657
Sometimes the error messages can be red herrings, but other times they say exactly what needs to be done. Have you tried doing what the error message suggested?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1362857
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse