SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS Script Task Issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bandi
Flowing Fount of Yak Knowledge

India
2217 Posts

Posted - 04/29/2014 :  09:35:20  Show Profile  Reply with Quote
We have one script task. There am using ADO Connection to execute INSERT/UPDATE statements in the Script task...


The package is executing well from the development tool( Visual Studio 2012). After deploying package to DB server, then it throws exception while running ADO Code.....

What can be the problem for exception?
How to resolve this issue?

--
Chandu

James K
Flowing Fount of Yak Knowledge

3704 Posts

Posted - 04/29/2014 :  15:54:47  Show Profile  Reply with Quote
What is the exception? Does it give you a call stack? If I had to guess, I would think it has to do with differences in either permissions or connection strings resulting in the inability of the ADO code to access the database. Are you accessing the same database from Dev Studio and in the deployed scenario?
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2217 Posts

Posted - 05/07/2014 :  02:14:47  Show Profile  Reply with Quote
Hi James,
Thank you for the response...

We were getting generic message "Exception has been thrown by target invocation".

if the Script task is having MessageBox then we are getting the above error.

What can be the problem?

NOTE: We used Script task of SSDT 2012


--
Chandu
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2217 Posts

Posted - 05/15/2014 :  01:03:38  Show Profile  Reply with Quote
Alternative solution for the above issue,
1) For MessageBox issue, We have removed MessageBox.Show() code line... Instead of PopUp message we logged that information to
DB table.....

2) we found out that the Exception was because of my web service call( i.e. Port enable issue between two servers)

--
Chandu
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000