Forum Replies Created

Viewing 15 posts - 271 through 285 (of 1,118 total)

  • RE: Convert ActiveXScript task

    shirishjani (9/21/2010)

    so what is the changes that i need to apply with this

    once i take new activexscripttask from toolbox

    I don't think you have to make any changes. It should...

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

    September 21, 2010 at 9:03 am

    #1224916

  • RE: Convert ActiveXScript task

    Did you try using the standard ActiveX Script Task? It is for executing older DTS scripts and this script looks like it should execute properly.

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

    September 20, 2010 at 7:54 pm

    #1224469

  • RE: Sending Result set as Email via Script task

    Vijay,

    Check this post by Matt Masson.

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

    September 16, 2010 at 6:00 am

    #1222101

  • RE: Can multiple script components execute asynchronously?

    Hi David,

    Why not try to export the Excel file content into CSV file and then use script to process this text file? You will still need Excel to do the...

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

    September 15, 2010 at 1:56 pm

    #1221659

  • RE: Text File Import

    erngreen (9/14/2010)

    If you can give me a general idea. I might be able to resolve.

    Check this article by Todd McDermid. You have to apply the same process ,...

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

    September 14, 2010 at 7:23 am

    #1220656

  • RE: Text File Import

    erngreen (9/14/2010)

    This is sql server 2005

    This is the problem. The component is for 2008 and you are using 2005. You can easily modify the component to work for 2005 ,...

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

    September 14, 2010 at 7:12 am

    #1220644

  • RE: Text File Import

    What version of SQL Serve do you use? 2005 or 2008 ?

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

    September 13, 2010 at 2:21 pm

    #1220306

  • RE: Text File Import

    erngreen (9/13/2010)

    The installation goes smoothly but when I go to add it in BI Studio. I get an error.

    What is the exact error message?

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

    September 13, 2010 at 8:47 am

    #1220105

  • RE: Text File Import

    erngreen (9/13/2010)

    While I would like to use this component, I have been unable to get it to install in my enviornment.

    What's the issue? Have you tried asking a question in...

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

    September 13, 2010 at 8:04 am

    #1220058

  • RE: Text File Import

    erngreen (9/13/2010)

    here are just a couple of posts related to the problem.

    http://connect.microsoft.com/SQLServer/feedback/details/126493/uneven-column-count-import-using-ssis

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/53e3f59d-9442-43f9-99c5-37dd964408fc/

    Have you checked this component ?

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

    September 13, 2010 at 7:54 am

    #1220054

  • RE: Text File Import

    erngreen (9/13/2010)

    The flat file connection manager does not work for files with uneven column data. It works well in DTS but not in SSIS. The file is also delimited with...

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

    September 13, 2010 at 7:19 am

    #1220018

  • RE: Text File Import

    Hi,

    You should use Script Component, not Script Task and create Script Source. Two recommendations:

    - Explicitly define the columns from the source and then define each and every column in the...

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

    September 12, 2010 at 7:17 am

    #1219712

  • RE: How to export to Excel with dynamic column names?

    WayneS (9/9/2010)

    I'm working on some SSIS packages. The data is extracted by years loaded into a table - each year is processed separately.

    Part of the data extraction utilizes dynamic sql...

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

    September 9, 2010 at 1:53 pm

    #1218872

  • RE: Password Protect Excel Destination File

    Scott-361039 (9/9/2010)

    Hi

    I am looking for some help with the following please:

    I am passing out an excel file that will be emailed to a recipient and i would like to password...

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

    September 9, 2010 at 1:50 pm

    #1218870

  • RE: Pre-requisite for running DTEXEC command

    Hi Arunvijay,

    You have to install "Integration Services" on the target machine. This is an option in the SQL Server installation wizard.

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

    September 9, 2010 at 1:23 pm

    #1218866

Viewing 15 posts - 271 through 285 (of 1,118 total)