Solved

RE : SSIS deployment

Posted on 2011-03-24
5
252 Views
Last Modified: 2013-11-10
Hi,

I have created one SSIS package having Script task executing through .Net. Everything is working fine. I just want to test the same on another machine. So, i have created the Manifest file and configuration file. Deployed the package as file system in another machine but i am recieving the below error.

object reference not set to an instance of an object

Can you please let me know why i am recieving this error.

Thanks
0
Comment
Question by:rajneesh1978
5 Comments
 
LVL 7

Expert Comment

by:lozzamoore
Comment Utility

Can you see from the logs or error message which line in the Script task is the culprit?
0
 
LVL 30

Expert Comment

by:Reza Rad
Comment Utility
I think problem is in the script task,
could you paste your script here?
0
 
LVL 21

Expert Comment

by:Alpesh Patel
Comment Utility
Can you paste error message and script code here?
0
 
LVL 7

Accepted Solution

by:
rmm2001 earned 500 total points
Comment Utility
Are you calling a component on your new machine that your development machine didn't have? Are you using a hardcoded path to refer to something inside your script?  If you haven't already - put some logging inside the package. Write to the output window or to a file after each part of the code executes so you can figure out where it's failing. If you can run the packags out of bids on the new machine, stick a breakpoint in the script and run in 32bit mode and debug and step through to see what's up.
0
 

Author Closing Comment

by:rajneesh1978
Comment Utility
Thannks
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now