Forum Replies Created

Viewing 15 posts - 931 through 945 (of 1,118 total)

  • RE: Task for Zipping Files?

    John Bates (1/27/2009)

    Hi experts,

    Does SSIS 2005 have a task that will zip a file?

    Thanks, John

    Check the Zip Task. It is part of the SSIS+ commercial library, which includes many other...

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

    January 28, 2009 at 1:09 pm

    #934106

  • RE: Pass data between dataflows

    stricknyn (1/27/2009)

    Hi all,

    I have a dataflow (We'll call it Audit) which performs some audits and sends the "good records" to one flow and the bad records to an output file.

    I...

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

    January 28, 2009 at 1:04 pm

    #934105

  • RE: Data Convesrion Task + OLE DB Destination is too slow

    riga1966 (1/27/2009)

    I tried SQL Server Destination component

    and got an error:

    Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT ...

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

    January 27, 2009 at 10:48 am

    #933379

  • RE: "Key not valid for use in specified state.". You may not be authorized to access this information

    george sibbald (1/27/2009)

    thanks for the reply. Please bear with me -

    I've gone for option one but have hit the following problems:

    I set protection level at encryptsensitivewithpassword and set a...

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

    January 27, 2009 at 10:41 am

    #933374

  • RE: Data Convesrion Task + OLE DB Destination is too slow

    riga1966 (1/27/2009)

    I also noticed in my OLE DB Destination

    in "Data access mode" I used "SQL command" option to make mapping easier so that

    I only see the columns to which I...

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

    January 27, 2009 at 10:37 am

    #933370

  • RE: Data Convesrion Task + OLE DB Destination is too slow

    riga1966 (1/26/2009)

    I have a Data Conversion Task

    that converts data from raw table SRC_CUSTOMER where all the fields are varchar(255)

    to real data types. Then the records that passed the conversion

    get inserted...

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

    January 27, 2009 at 9:55 am

    #933322

  • RE: Use variable in query

    Helical Johan (1/27/2009)

    Hi, can I use a variable inside a query as column?

    Is it possible? How?

    Thanks.

    If you use "Execute SQL Task", setup your SQLSourceType to be Variable. Specify the...

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

    January 27, 2009 at 9:49 am

    #933316

  • RE: "Key not valid for use in specified state.". You may not be authorized to access this information

    george sibbald (1/27/2009)

    Hi, I am a noob as far as SSIS is concerned so go easy on me.

    I have set up a transfer login task between two servers, both of...

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

    January 27, 2009 at 9:35 am

    #933294

  • RE: Open excel 2007 file and refresh all data, rename file with actual datetime, copy file to destination folder.

    Jagger (1/26/2009)

    Hi,

    Is it possible to use integration service in order to open excel 2007 file, then to refresh all data (pivot tables ), rename file with current datetime and...

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

    January 26, 2009 at 7:03 am

    #932575

  • RE: File Watcher Task - Multiple File Masks

    lucky (1/23/2009)

    CozyRoc (1/23/2009)

    lucky (1/23/2009)

    CozyRoc (1/23/2009)

    lucky (1/22/2009)

    Ray M (1/22/2009)

    Thats fine that they are using the same location. But makes them unique?

    How do you know what site file belongs to?

    Thanks Ray for...

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

    January 25, 2009 at 11:23 am

    #932414

  • RE: File Watcher Task - Multiple File Masks

    lucky (1/23/2009)

    CozyRoc (1/23/2009)

    lucky (1/22/2009)

    Ray M (1/22/2009)

    Thats fine that they are using the same location. But makes them unique?

    How do you know what site file belongs to?

    Thanks Ray for replying back.

    As...

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

    January 23, 2009 at 9:12 am

    #931862

  • RE: File Watcher Task - Multiple File Masks

    lucky (1/22/2009)

    Ray M (1/22/2009)

    Thats fine that they are using the same location. But makes them unique?

    How do you know what site file belongs to?

    Thanks Ray for replying back.

    As mentioned in...

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

    January 23, 2009 at 12:20 am

    #931658

  • RE: SSIS Accessing the properties of another Component from within a Script Component

    Damien (1/21/2009)

    Hi Guys,

    I have been trying to find out how to access the properties of one component from within a script task. Below is more exact scenario:

    I have a...

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

    January 23, 2009 at 12:15 am

    #931656

  • RE: Recommended Connection Manager type for ORACLE databases

    DBUSER (1/21/2009)

    Hi,

    I am new to SSIS 2008. I worked on SQL Server 2000 DTS packages a while ago.

    I would like to know what will be the best...

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

    January 23, 2009 at 12:08 am

    #931654

  • RE: Import a zip file from a HTTP page

    steveb (1/21/2009)

    I am trying to build a SSIS package that will check out a http url for a zip file, this file should be then downloaded and then transferred...

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

    January 23, 2009 at 12:05 am

    #931653

Viewing 15 posts - 931 through 945 (of 1,118 total)