Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

RE : SSIS deployment

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
rajneesh1978
Asked:
rajneesh1978
1 Solution
 
lozzamooreCommented:

Can you see from the logs or error message which line in the Script task is the culprit?
0
 
Reza RadCommented:
I think problem is in the script task,
could you paste your script here?
0
 
Alpesh PatelAssistant ConsultantCommented:
Can you paste error message and script code here?
0
 
rmm2001Commented:
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
 
rajneesh1978Author Commented:
Thannks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now