Viewing 15 posts - 12,796 through 12,810 (of 13,849 total)
So which bit are you asking for help on? Retrieving the string from an XML file (which appears to be masquerading as a CSV file) or using the retrieved string...
May 12, 2009 at 2:21 am
CozyRoc (5/11/2009)
Phil Parkin (5/11/2009)
I tried out Ramesh's code and have a follow-up question: what is the data type...
May 11, 2009 at 11:27 pm
Hi guys - I bet you thought that this was all over? :hehe:
I tried out Ramesh's code and have a follow-up question: what is the data type of 'CleanLine'? Looks...
May 11, 2009 at 7:31 pm
The last part of the error message actually states that the step succeeded too - it's just that there was an error in it.
Can you post the code for the...
May 11, 2009 at 6:06 pm
CozyRoc & Ramesh - great work, thanks for the help.
May 11, 2009 at 9:39 am
Ramesh (5/11/2009)
Here is that script:
Imports System
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Public Class ScriptMain...
May 11, 2009 at 9:16 am
CozyRoc (5/11/2009)
What is the issue when you try to use script component?
OK, I did this in a test environment to check. I have an OLEDB Source which just does a...
May 11, 2009 at 9:12 am
Thanks for the idea - tried it and:
The function REPLACE does not support the data type "DT_TEXT" for parameter number 1. The type of the parameter could not be explicitly...
May 11, 2009 at 8:14 am
Sorting a 10GB text file? I can imagine some complaints from the server ....
May 11, 2009 at 6:57 am
You should try the XML source adaptor in SSIS and see whether that can do it for you (it does not work for all XML variants).
If you are looking for...
May 11, 2009 at 6:46 am
- Create an int variable, scoped at package level, to hold the rowcount results.
- Use an Execute SQL task to run the count query and assign the result to rowcount
-...
May 9, 2009 at 1:40 am
Your sample data contains no commas, so each row will be interpreted as a single field.
May 7, 2009 at 6:19 pm
Maybe you could write to a single variable within the loop - just keep on appending messages to it as you iterate round - and then use the contents of...
May 7, 2009 at 10:11 am
Sure. Make sure that the variables you are using are scoped at the package level and then add your tasks to create the file and send the e-mail after the...
May 7, 2009 at 12:52 am
That's a real pain!
I think that you might have to import every row as a single text string and then use code (ie a Script component) to split the items...
May 7, 2009 at 12:30 am
Viewing 15 posts - 12,796 through 12,810 (of 13,849 total)