Forum Replies Created

Viewing 15 posts - 706 through 720 (of 1,118 total)

  • RE: Error: 'System.Transactions.Diagnostics.DiagnosticTrace'

    Can you execute as local admin? Your domain admin might not have all the permissions needed for the package execution.

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

  • RE: Error: 'System.Transactions.Diagnostics.DiagnosticTrace'

    Can you post the error?

    It looks like permission issue. Can you try to execute the package with full permissions (administrative account) ?

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

  • RE: How to deploy packakes to a sql server

    Patrick.I (7/3/2009)


    I have a package that export thata from csv to sql server.

    How can i deploy it directly to another server?

    Is this possible?

    Also what do i need to do if...

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

  • RE: FTP Task in SSIS package

    forum member (7/7/2009)


    Hi,

    when i run under msdb,integration services the package works but when i run same thing under sql server it doesnt work any idea

    Please suggest me on how...

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

  • RE: Evaluate variable and dynamically set Connection Manager Expression

    DBASkippack (7/6/2009)


    My Connection Manager called ExcelConnecton (to an Excel connection) is wired to an Expression that points to a Directory & Filename. I'm using a .dtsConfig file to set...

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

  • RE: Error: 'System.Transactions.Diagnostics.DiagnosticTrace'

    Can you give more details what is: BANCS_LOAD_EXEC_TABLE

    The error message looks very strange. This doesn't look like normal table.

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

  • RE: ssis webservice and certificate

    keywestfl9 (7/1/2009)


    Thanks for the documentation.

    Can you please tell me if i have to do the input parameter from a table column value, how do i do it?

    You have to load...

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

  • RE: ssis webservice and certificate

    keywestfl9 (6/30/2009)


    Thanks a lot.

    i think i can't use web service task as i have pass parameter and i dont think web service accepts parameter from table.

    if i have to do...

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

  • RE: Inserting Bad Data as NULL with OLE DB Destination

    Michael Esposito (6/30/2009)


    Under our old DTS packages, bad data (like 32-12-2009) would be inserted into our tables as NULL values. However, in SSIS, it is just being skipped and never...

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

  • RE: ssis webservice and certificate

    keywestfl9 (6/29/2009)


    i am trying to use webservice task in my ssis package.

    the webservice i am accessing need an certificate.

    how do i do i thru Webservice task in ssis? Please...

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

  • RE: 64 bit runtime issue

    Okay, now tell us what exceptions do you get in the script when you precompile?

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

  • RE: SSIS Package Iterative Connection question

    bbrickey (6/25/2009)


    I'm creating a little schema structure that gathers information from databases on multiple servers in the environment. I'd like to make a list table with Server names to...

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

  • RE: 64 bit runtime issue

    nabajyoti.b (6/25/2009)


    hi there,

    i am having issues while running the package from 64 bit environment

    Actually it fails to enter data into the excel file; the typical jet driver issue.

    However, i cannot...

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

  • RE: excel preview showing integer values null in a alphanumeric column

    hi.shobhit76 (6/25/2009)


    Hi,

    When i load my excel sheet onto a connection manager in an excel source and preview the data present in my excel sheet then i get integer values shown...

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

  • RE: Send a Mail with Attachment with Script Task

    nero.ch (6/25/2009)


    hey

    is it possible to send a mail with multiple attachments with the script task?

    thanks for any help

    Yes, it is possible. Check MailMessage class and Attachments property. Also check here...

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

Viewing 15 posts - 706 through 720 (of 1,118 total)