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 SubHopefully this helps!