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 ««12

Problem referring to a SSIS variable inside Script task Expand / Collapse
Posted Wednesday, July 15, 2009 9:12 PM



Group: General Forum Members
Last Login: Today @ 2:01 PM
Points: 5,736, Visits: 13,587
touchmeknot123 (7/15/2009)

I am developing the SSIS package to parse a non-delimited file.
Can you please help me on the script which is to be written to parse the file ?


This should be set up as a new thread. When you do so, please post some sample data (showing the format of the source data and the desired output format). Wading straight into designing a script may be overkill ... but without seeing some sample data, we cannot give good advice.

Also, please explain further what you mean by 'parse'.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

I had some words with my wife, and she had some paragraphs with me.
Post #753932
Posted Thursday, April 14, 2011 1:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 1:09 PM
Points: 1, Visits: 16
Hi John Rowan!

I have a similar problem. I did what you said about the Propogate variable = false on all tasks inside the foreach container. But the execution still halts, it doesn’t go to the next item iteration of the loop. Am I missing something?

ForEach Loop
DataFlowTask(OnErorr Propogate=false)
DataFlowTask(OnErorr Propogate=false)
FileSystemTask(OnErorr Propogate=false)
SendEmailTask(OnErorr Propogate=false)

Problem: My SMT could fail with bad email address and to me that’s ok. For example: the first item in the collection has a bad email. I have a OnError event SendeEmailTask here to handle when the task fails. It executed the OnError SendEmail task fine. Then, the SQL task was executed. Then the whole package failed. It never went to the next item in the collection. I want my package to still go on to the next item in the collection but it stops the whole package. I added the propogate to all the tasks in the foreach container like you mentioned to do, but it stops on the first item of the collection because the email is bad.

SQL Task

Post #1093769
Posted Thursday, March 1, 2012 2:34 PM



Group: General Forum Members
Last Login: Tuesday, April 28, 2015 7:32 AM
Points: 2,790, Visits: 808
The reason it isn't found in the collection is because it is not in the collection. Go to the data sources listed in the Solution Explorer that point to that database and delete it. Then recreate it. When you do, it will ask you to put that data source in as a new collection item (unless it is already there and you wouldn't get that message if it was).

Post #1260455
Posted Tuesday, February 5, 2013 3:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 8:03 PM
Points: 7, Visits: 29
I have got dialogue box added to SSIS package,through script at the end,that populates when process is completed.

But it throws the below error when called from SSMS job “Script Task: Error: Exception has been thrown by the target of an invocation”

Script has just below code is in C#

System.Windows.Forms.MessageBox.Show(“Process has completed”);

Please clarify.
Post #1416123
Posted Thursday, June 19, 2014 8:13 AM


Group: General Forum Members
Last Login: Yesterday @ 12:32 PM
Points: 132, Visits: 295
Just wanted to comment, I had same problem and this worked like a charm....Thanks
Post #1583850
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse