Viewing 15 posts - 211 through 225 (of 1,118 total)
keywestfl9 (1/25/2011)
when i use odbc i get error in the querycreate table abc(select id from table1) ;
i get syntax error between select and ;
I'm not very familiar with Teradata, but...
January 25, 2011 at 12:51 pm
pamozer (1/20/2011)
So I need to purchase ScriptTaskPlus to use this? Am I reading this correctly?Depends on CozyRoc Script Task Plus component for implementing parameters user interface.
Purchasing CozyRoc SSIS+ will...
January 20, 2011 at 11:01 am
The error you receive for the last test you made makes me think you have NULL input value and you are not checking for it. Try the following code:
Dim test...
January 20, 2011 at 10:57 am
This doesn't look like proper Script Component script. Your class has to inherit from UserComponent. The data being processed will be by default passed in <Your Input>_ProcessInputRow method, not your...
January 20, 2011 at 10:50 am
pamozer (1/18/2011)
January 20, 2011 at 10:36 am
stricknyn (1/18/2011)
Another thing I just thought of: Where was the data prior to getting it in a recordset? Reason I ask is because you may also be able...
January 18, 2011 at 9:19 am
colladay (1/14/2011)
The CR and \t characters are messing up 2 columns. I believe they are interpreted literally. I cannot fix this at the data entry...
January 14, 2011 at 2:58 pm
You can implement this requirement using data flow script, where based on the description column the input row is split into multiple rows according to the algorithm you have described....
January 14, 2011 at 2:45 pm
Brian Carlson (1/13/2011)
Koen (da-zero) (1/13/2011)
However, this raises another problem: how to detect failure?...
January 14, 2011 at 2:29 pm
dnyanesh.09 (1/13/2011)
Do any one know which component we can use from control flow of SSIS Package for Scrambling SSN data & i think it my be Script task.
Please suggest me...
January 14, 2011 at 2:13 pm
What source component do you use in your data flow? Is it OLEDB Source or ADO.NET Data Source?
January 14, 2011 at 2:02 pm
dndaughtery (1/12/2011)
January 14, 2011 at 1:59 pm
pamozer (1/12/2011)
January 14, 2011 at 1:52 pm
Use expression to dynamically modify FTP Task's RemotePath parameter to the location where you want to upload a file.
January 14, 2011 at 12:37 pm
dndaughtery (1/14/2011)
January 14, 2011 at 12:34 pm
Viewing 15 posts - 211 through 225 (of 1,118 total)