Forum Replies Created

Viewing 15 posts - 211 through 225 (of 1,118 total)

  • RE: Execute sql task

    keywestfl9 (1/25/2011)

    when i use odbc i get error in the query

    create table abc(select id from table1) ;

    i get syntax error between select and ;

    I'm not very familiar with Teradata, but...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 25, 2011 at 12:51 pm

    #1278127

  • RE: Http Connection Manager - Error Handling Questions

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 20, 2011 at 11:01 am

    #1276125

  • RE: Date conversions in script component

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 20, 2011 at 10:57 am

    #1276120

  • RE: Passing Row into custom class

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 20, 2011 at 10:50 am

    #1276110

  • RE: Http Connection Manager - Error Handling Questions

    pamozer (1/18/2011)

    I am passing through the server name/ URL through a variable which I believe is working fine. When it goes to the url I am getting the...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 20, 2011 at 10:36 am

    #1276088

  • RE: Is it possible to retrieve data from a specific row in an ado recordset in SSIS 2005?

    stricknyn (1/18/2011)

    Hello,

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 18, 2011 at 9:19 am

    #1274819

  • RE: Import 1.2 gig tab-delimited file into SQL Server 2005

    colladay (1/14/2011)

    Hello Everyone,

    The CR and \t characters are messing up 2 columns. I believe they are interpreted literally. I cannot fix this at the data entry...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 14, 2011 at 2:58 pm

    #1273820

  • RE: Splitting Text

    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....

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 14, 2011 at 2:45 pm

    #1273813

  • RE: Fail loop but continue processing

    Brian Carlson (1/13/2011)

    Koen (da-zero) (1/13/2011)

    You can force the execution result of the data flow to succeed, so your loop would always continue.

    However, this raises another problem: how to detect failure?...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 14, 2011 at 2:29 pm

    #1273804

  • RE: SSIS Package for Scrambling SSN Data

    dnyanesh.09 (1/13/2011)

    Hi,

    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...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 14, 2011 at 2:13 pm

    #1273798

  • RE: SSIS- source database migaration (from DB2 to oracle)

    What source component do you use in your data flow? Is it OLEDB Source or ADO.NET Data Source?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 14, 2011 at 2:02 pm

    #1273791

  • RE: Is it possible to retrieve data from a specific row in an ado recordset in SSIS 2005?

    dndaughtery (1/12/2011)

    I have a recordset which has a unique id int column. I want to be able to create another recordset based off of the value in one of the...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 14, 2011 at 1:59 pm

    #1273789

  • RE: Image Urls in XML File Source

    pamozer (1/12/2011)

    I currently have an Xml document that I am importing into multiple tables in my database. In this xml file are urls that lead to images that I need...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 14, 2011 at 1:52 pm

    #1273786

  • RE: SSIS FTP TASK - Change Remote Directory and Upload Files

    Use expression to dynamically modify FTP Task's RemotePath parameter to the location where you want to upload a file.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 14, 2011 at 12:37 pm

    #1273745

  • RE: 2 ForEach Loop Containers using the same ADO RecordSet. One turns red in debugger

    dndaughtery (1/14/2011)

    I have a pkg with 2 ForEach Loop Containers using the same ADO RecordSet. One turns red in the debugger but when I look in the progress tab to...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    January 14, 2011 at 12:34 pm

    #1273742

Viewing 15 posts - 211 through 225 (of 1,118 total)