Viewing 15 posts - 9,346 through 9,360 (of 13,882 total)
So at the moment, I think that scripting out the variables would provide only a reference, not something that can be executed.
Apologies - I should have mentioned that this...
March 31, 2014 at 4:00 am
Koen Verbeeck (3/31/2014)
happycat59 (3/30/2014)
March 31, 2014 at 3:59 am
sandeep.patel1 (3/28/2014)
hi Phil Parkin,Can you please write the script code for doing this.
--
No.
Please do some research and at least try to make it work for yourself, then post back with...
March 28, 2014 at 1:00 am
If you are writing the value to a table somewhere, you can issue an ExecuteSQL query immediately after the data flow to retrieve it and assign it to an SSIS...
March 28, 2014 at 12:53 am
Eirikur Eiriksson (3/26/2014)
My 2 cent;An apostrophe is a valid character in a surname so that should be catered for.
I agree - if you remove these, you are changing people's names.
March 27, 2014 at 4:21 am
dan-572483 (3/25/2014)
March 26, 2014 at 1:19 am
dan-572483 (3/21/2014)
March 25, 2014 at 4:50 am
KoldCoffee (3/24/2014)
regarding prior reply about Unicode - I'm not getting error pertaining to Unicode/non-Unicode and 80,000 rows ARE transferring.How would I determine if it's line terminators?
So does it always fail...
March 25, 2014 at 4:48 am
aaron.reese (3/24/2014)
yup. You might need to use a script component or WMI. Here are a couple of linkshttp://www.bidn.com/blogs/mikedavis/ssis/157/ssis-wmi-event-watcher-check-file-exist-creation
http://www.bidn.com/blogs/DevinKnight/ssis/76/does-file-exist-check-in-ssis
Use a Script Task, not a Script Component.
Here's a C# snippet...
March 25, 2014 at 1:09 am
We don't use this tool, but it promises to do at least some of what you are looking for:
http://www.embarcadero.com/products/er-studio-data-lineage
Not free though ...
March 25, 2014 at 1:05 am
Informer30 (3/24/2014)
OK thanks -confused how csv files work then, they are flat files but unable to open in a csv viewer?
A CSV file is just a structured text file. Nothing...
March 24, 2014 at 11:29 am
No. How are you viewing the CSV? Use a decent text editor, not Excel.
March 24, 2014 at 8:59 am
Koen Verbeeck (3/24/2014)
aaron.reese (3/24/2014)
Next question. Which files need to be in SCC and which...
March 24, 2014 at 3:55 am
Or maybe let SSIS do all the work by defining @@@ as a column delimiter.
March 24, 2014 at 1:57 am
Viewing 15 posts - 9,346 through 9,360 (of 13,882 total)