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

ssis package execution error sql server 2008 Expand / Collapse
Author
Message
Posted Wednesday, December 18, 2013 4:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:36 PM
Points: 21, Visits: 72
hi, everyone,

i have created ssis packages and its working properly in local machine when i upload files from .net.
but not working in live machine when i upload files from .net(c#) and getting error .

"The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully."Script Component" failed validation and returned validation status "VS_ISBROKEN". One or more component failed validation. There were errors during task validation. "


pls i need help.


Thanks
Rajnidas
Post #1524037
Posted Wednesday, December 18, 2013 5:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
Do you rely on any specific assemblies in your code? (who might not be present on the other machine?)



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1524040
Posted Wednesday, December 18, 2013 5:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:36 PM
Points: 21, Visits: 72
no sir,

running project at same machine but live project machine.

thanks
Post #1524043
Posted Wednesday, December 18, 2013 5:06 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
rajnidas.y (12/18/2013)

running project at same machine but live project machine.


Care to explain a bit more?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1524046
Posted Wednesday, December 18, 2013 5:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:36 PM
Points: 21, Visits: 72

it was working in local machine but not in live production server .

thanks
Post #1524061
Posted Wednesday, December 18, 2013 5:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
rajnidas.y (12/18/2013)

it was working in local machine but not in live production server .

thanks


So, two different machines after all.
And no special assemblies used?

Does the server has the same .NET framework installed?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1524067
Posted Wednesday, December 18, 2013 6:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:36 PM
Points: 21, Visits: 72
.net frame are same in both machine

thanks
Post #1524078
Posted Wednesday, December 18, 2013 6:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
Open up the script component, build it, save it and then redeploy the package.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1524086
Posted Wednesday, December 18, 2013 9:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:36 PM
Points: 21, Visits: 72
Thanks for your response its working as your suggest.
Post #1524441
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse