Was able to get pas thro' the Excel permission rights but still.... stuck in Cannot create ActiveX Component...... for Excel in SSIS SQL2008 R2, Windows 2008 R2 machine.. Sometime back...

Hi yoginraval ,

Did you ever get a solution for your issue ?...

I am in the same boat.

I am trying to create an Excel file in Script task, and fails...

Yes. I do have a similar issue, the Package runs good in VS2008, ( SQL2008R2)( Debug / Release mode ) , but the same package

when configured as job complain only...

Hey Hi,

Can you mention which Tutorial ? I searched a lot on your blog / Ws... Pretty impressive,

Keep it up.

I have a similar issue, the Excel object creation...

VIOLA !!!

Thank you for all those who have contributed in helping me solve this issue, I chased it like a goose & finally got it working.

Creating a...

Nope,...Thanx for your quick reply... Who says NewBie's are Not Genius ?...

I tried doing your soln. InteractiveMode = False.

It Executes independently as a Package & in BIDS, ( It...

Hey Genius, Where's that Interactive Property of the package.... ? I think I have seen it somewhere .... But I have Not .....been able to find it after your reply...

I...

VioLA.....

Rename the old exe in the SQL 2005 path to a different name (Example:- C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTEXEC_Old.exe)

and works !

Hope this helps someone...

I can provide you some tried & tested snippet to call a SSIS Package from SP. You may have to enable the command shell scripting as shown in...

NOPE.....

The Soln.. Provided as above does not work for my requirement.

Let me spell out my requirement once again if it is mispleading..... Any MVP's ???

How to access the PACKAGE Generated...

Thanx again for Quick reply...

Hmmm..... Yes... your soln. makes sense Some what.....

Let me try this, I can treat it as a work around,

The reason I say so...

Wov Thanks for the Quick reply on a early release Day !!!.

Nope, The issue is :-

the Expression I provide earlier is evaluated BEFORE the Script task is...

Yes. Boss.. Thanx,.... It worked. I found that out mentioned by someone in the list that it works only for ado.net, ...... in a fine print & I was doing...

Unfortunately this Does Not Work.

The Code I have is

Public Sub Main()

'Dts.Variables("MyCaseSensitiveVariableName").Value

Dts.Log("...