No announcements
Found 2408803 threads
-
1 VotesHow to redirect error records from script component task?
With a script component, I wouldn't bother trying to redirect error rows.Answered | 5 Replies | 14582 Views | Created by JoJo_1 - Friday, June 24, 2011 9:08 PM | Last reply by DeepakKumarKalyanum - Saturday, June 25, 2011 8:32 AM
-
1 Votes
Can anyone recommend how I customize SSIS logging in Script Component
Hi, We can also log the data entries into the log table using control flow and exec sql task.Answered | 2 Replies | 937 Views | Created by Evgeniy.co.il - Thursday, October 3, 2013 8:59 AM | Last reply by Harry Bal - Thursday, October 3, 2013 5:23 PM -
0 Votes
How to update a column with a new value based on the number of records in script component?
Based on my research, I find the issue is caused by missing two line code in your script component script.Answered | 8 Replies | 1209 Views | Created by Satish Hongal - Friday, January 30, 2015 8:01 AM | Last reply by Katherine Xiong - Monday, February 2, 2015 12:57 PM -
1 Votes
Logging Script information into a .txt file
FOr what you are trying to do know the basic examples in the link I posted will also get you started in an afternoon.Answered | 7 Replies | 585 Views | Created by Cookm3 - Thursday, March 3, 2016 3:33 PM | Last reply by jrv - Thursday, March 3, 2016 4:29 PM -
2 Votes
Script Component
The input columns are the columns you need in your script for reading or writing.Answered | 2 Replies | 2067 Views | Created by Andrea Pirlo - Wednesday, April 10, 2013 7:24 AM | Last reply by SSISJoost - Wednesday, April 10, 2013 10:48 AM -
0 Votes
Is it possible to retrieve a record deleted with the log information logged in the log tables ?
Do you run this database in FULL recovery model , have you taken any log backup before this undesired transaction for your database ?Answered | 2 Replies | 6001 Views | Created by Chaithanya Reddy - Saturday, May 28, 2011 5:40 AM | Last reply by Mr. Wharty - Monday, May 30, 2011 1:48 AM -
0 Votes
Do lookup to a cache from a script component?
I'm kind a new to SSIS, but I have found the c# script component to be really useful; especially where I was finding difficult to perform ...Answered | 6 Replies | 5333 Views | Created by jagt70 - Thursday, July 28, 2011 1:15 PM | Last reply by jagt70 - Friday, July 29, 2011 10:44 AM -
0 Votes
difference between script task and script component transformation
Script Component is part of the Data Flow Task.Answered | 2 Replies | 2743 Views | Created by Sanam K M N - Saturday, December 29, 2012 7:13 AM | Last reply by SSISJoost - Saturday, December 29, 2012 1:52 PM -
0 Votes
Error in SSIS Script Component
Either way, I agree with SSISJoost, try to use Execute Sql Task, I prefer to make as much as possible use of the SSIS components.Answered | 3 Replies | 2465 Views | Created by Nisal Mihiranga - Sunday, February 16, 2014 3:26 PM | Last reply by Nisal Mihiranga - Wednesday, February 26, 2014 5:23 AM -
0 Votes
Need help with script component
Using the script component it took 15 minutes.Answered | 4 Replies | 3065 Views | Created by David Foard - Sunday, January 1, 2012 6:51 PM | Last reply by David Foard - Tuesday, January 3, 2012 2:27 PM -
0 Votes
How can I use total in calculation in method of Script Component?
BTW I want to do this using Script Component.Answered | 4 Replies | 4765 Views | Created by delphinek - Sunday, November 14, 2010 12:32 PM | Last reply by Todd McDermid - Wednesday, November 17, 2010 10:45 PM -
0 Votes
error handling in script component
how can i do that in script component?Answered | 23 Replies | 3913 Views | Created by Prakash.R - Thursday, September 15, 2011 10:49 AM | Last reply by Shailesh Rajak - Friday, September 16, 2011 2:25 PM -
0 Votes
Script component error
Add some logging (this.ComponentMetaData.FireInformation) to your script component.Answered | 5 Replies | 2307 Views | Created by vijaykmr - Friday, August 10, 2012 8:06 AM | Last reply by SSISJoost - Friday, August 10, 2012 11:39 AM -
0 Votes
How to calculative cumulative totals within a script component
This new new addition of ORDER BY clause in window functions really helps in performing running totals with single select statment but the user has requested for script ...Answered | 3 Replies | 1509 Views | Created by plantm - Friday, May 31, 2013 9:48 PM | Last reply by Harry Bal - Wednesday, June 5, 2013 5:09 PM -
0 Votes
Row level logging using script component inside a DFT Revisited
The only way I can see you generating multiple file names is if you are doing something with the log_file variable somewhere else in your code.Answered | 4 Replies | 1743 Views | Created by cat_ca - Thursday, February 21, 2013 7:21 PM | Last reply by Todd McDermid - Thursday, March 7, 2013 4:44 PM -
1 Votes
Multiple Inputs to Script Component
Then connect the output of union all to your script task as inputPlease Mark This As Answer if it solved your issue Please Vote This As Helpful if it helps to solve your ...Answered | 1 Replies | 1117 Views | Created by Hello_123456 - Thursday, July 12, 2018 4:14 AM | Last reply by Visakh16 - Thursday, July 12, 2018 5:10 AM -
0 Votes
Script Component after OLE DB Command
No The script component will execute even if there is no data for this you can use a separate variable in which you can record the count of rows and then ...Answered | 1 Replies | 2799 Views | Created by Krystof - Monday, October 10, 2011 12:34 PM | Last reply by Surender Singh Bhadauria - Monday, October 10, 2011 12:45 PM -
0 Votes
difference between script task and script component
Given that these are very different things its fairly intuitive to understand the difference between a Script Task and a Script Component.Answered | 7 Replies | 6710 Views | Created by v60 - Wednesday, February 9, 2011 7:47 AM | Last reply by SSISJoost - Wednesday, February 9, 2011 9:11 AM -
3 Votes
Script Component to check file exists
In your script component select column you need ID,FilePath and usage type is ReadOnly.Answered | 5 Replies | 1612 Views | Created by Neilcse - Friday, July 18, 2014 10:13 PM | Last reply by JamesEarnan - Saturday, July 19, 2014 11:03 PM -
0 Votes
Script component
see http://www.techbrothersit.com/2013/07/ssis-how-to-read-first-row-from-flat.html http://www.techbrothersit.com/2013/11/ssis-valida ...Answered | 1 Replies | 876 Views | Created by SqlBi_903 - Tuesday, October 13, 2015 4:13 AM | Last reply by Visakh16 - Tuesday, October 13, 2015 5:54 AM - Items 1 to 20 of 2408803 Next ›
No announcements
