Forum Replies Created

Viewing 15 posts - 241 through 255 (of 1,118 total)

  • RE: Setup Send Mail task

    sqlgreenhand (11/24/2010)

    Thank you for the response.

    As a "green hand", I have questions

    What is the extension"STX" for the two scripts file (05/08)?

    Also, is "Script task plus" a must to run...

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

    November 24, 2010 at 3:48 pm

    #1255370

  • RE: Setup Send Mail task

    sqlgreenhand (11/23/2010)

    Thanks for the info.

    I do not have Exchange server nor Outlook, do I have to install them.

    All my email activities are on the Internet provider server.

    Thank you again.:unsure:

    You can...

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

    November 23, 2010 at 10:12 pm

    #1254883

  • RE: Flat file connection to UNIX file share

    Hi Tim,

    What is the complete error message that you get?

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

    November 18, 2010 at 1:24 pm

    #1252727

  • RE: transfering files from an sftp site

    klineandking (11/14/2010)

    Good evening guys, i want to transfer some flat files from an fstp site that i set up.

    server name: "nik.vix.com"

    username: klinevix

    password:@23$~jack

    can u guys show how to do this in...

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

    November 18, 2010 at 1:11 pm

    #1252719

  • RE: Call SSRS report from ssis

    PSB (11/15/2010)

    I need to call a ssrs report from SSIS using a script task that has a File_ID as a parameter from the SSIS package.

    I have created the ssrs report...

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

    November 18, 2010 at 1:10 pm

    #1252718

  • RE: Double precision float DT_R8 column error

    PSB (11/8/2010)

    No it did not.

    This is very terse description. Can you provide more details what's happened? Did you get an error or what?

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

    November 8, 2010 at 8:45 am

    #1247699

  • RE: Double precision float DT_R8 column error

    PSB (11/5/2010)

    I don't have any control over the source excel file. Is there any way I can convert it ?

    Can you try the following:

    1. Right-click on the Excel Source component...

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

    November 5, 2010 at 7:47 am

    #1247131

  • RE: Unsupported data type on parameter binding 0

    Check this discussion.

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

    November 4, 2010 at 11:37 am

    #1246725

  • RE: Double precision float DT_R8 column error

    PSB (11/4/2010)

    Hi,

    I have a double precision float column named Fax from an excel 20077 source and its of type DT_R8 but the value is 222-666-9999 . When I run...

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

    November 4, 2010 at 11:16 am

    #1246704

  • RE: Call SSRS from SSIS using script task

    PSB (11/3/2010)

    How do we call ssrs report from ssis and email the report as excel to the recipients ?

    Thanks,

    Check this publication.

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

    November 4, 2010 at 11:13 am

    #1246701

  • RE: Confusion regarding using variables in Script Component

    Neil,

    You have made these two errors:

    1. If you specify a variable in ReadOnlyVariables or ReadWriteVariables, you should not use VariableDispenser to manage the variables. The variables are already available in...

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

    October 29, 2010 at 8:27 am

    #1244230

  • RE: For Each Loop works on first pass but not on second

    I would recommend you use the event log to post trace messages from your script, to find out what is going on with your arrays. Otherwise it is a blackbox...

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

    October 21, 2010 at 12:55 pm

    #1240524

  • RE: Extracting data (SAP Source in SSIS-2008)

    This looks like a bug in the Microsoft connector. I would recommend you contact them or post step-by-step report in SQL Connect.

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

    October 21, 2010 at 12:52 pm

    #1240521

  • RE: FTP Task

    You have to specify for the remote parameter something like this: <your folder>/abc*.csv

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

    October 21, 2010 at 12:07 pm

    #1240495

  • RE: Lookups with huge datasets

    If you can use third-party solutions, check the commercial CozyRoc Lookup Plus component. It can use Distributed Cache, based on the Windows AppFabric caching service. The solution can potentially handle...

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

    October 13, 2010 at 6:09 pm

    #1236582

Viewing 15 posts - 241 through 255 (of 1,118 total)