Forum Replies Created

Viewing 15 posts - 601 through 615 (of 1,118 total)

  • RE: SSIS Performance Stats

    One more resource:

    Speed up your ETL with 4 new SSIS performance videos from Microsoft

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

    September 11, 2009 at 1:05 pm

    #1052519

  • RE: SSIS Performance Stats

    growla (9/11/2009)

    Hi,

    I'm in the middle of writing a proposal and was just wondering if someone could direct me to somewhere outlining some statistics on SSIS performance. Something along the...

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

    September 11, 2009 at 12:59 pm

    #1052516

  • RE: How to call DLL functions from SSIS

    sleepycasper (9/11/2009)

    Hi all,

    We are using SSIS and would like to call some functions from DLL.

    Someone had mentioned like late binding and com intrepret.

    Any ideas?

    Thanks and regards.

    Does your DLL expose...

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

    September 11, 2009 at 12:55 pm

    #1052511

  • RE: Using custom data source in the package

    Bhavesh (9/7/2009)

    Hi all,

    I've just started to learn basics of SSIS. I'm trying to read excel document without using OLEDB provider rather use 3rd party .net component to read excel dataset.

    Can...

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

    September 11, 2009 at 12:48 pm

    #1052508

  • RE: New To SSIS

    gangadhara.ms (9/10/2009)

    Hi All,

    I am new to SSIS package 2005 ,pls let me know the link where i can learn quickly.

    Thanks for your help.

    I would recommend checking one of these books...

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

    September 11, 2009 at 12:41 pm

    #1052503

  • RE: Flat file source working

    forum member (9/9/2009)

    Hi,

    Thanks for the reply, Can you please help in understanding on how the suitable code page can identified to set in the flat file source

    Thanks

    But the setting...

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

    September 9, 2009 at 5:43 pm

    #1051501

  • RE: speeding up ssis package that writes to ms access

    elaine (8/13/2009)

    I have an ssis package that has several data flow tasks to select from sqlserver 2005 tables and output to an Access mdb. The provider in the connection...

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

    September 9, 2009 at 4:21 pm

    #1051483

  • RE: VSTA script issue to retrieve schema information with OLE DB and DataTable

    You have to open the script in edit mode and look for Add Reference command there.

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

    September 9, 2009 at 9:47 am

    #1051241

  • RE: How to delete files from the ftp after the files transfer is complete

    forum member (9/9/2009)

    Hi

    Please help on how to delete the files in ftp after file transfer is complete using FTP Task

    Thanks for the help

    You have to insert another FTP Task as...

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

    September 9, 2009 at 6:57 am

    #1051037

  • RE: VSTA script issue to retrieve schema information with OLE DB and DataTable

    You have to Add Reference to System.Xml library. The command is somewhere in the Project menu.

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

    September 9, 2009 at 6:54 am

    #1051032

  • RE: Need to create script task to check for the source files-Arrival

    Paul_J (9/7/2009)

    Sorry I actually don't think the File System Task supports checking if a file exists.

    Paul,

    This is the custom File Watcher Task, not the File System Task. And it supports...

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

    September 7, 2009 at 7:41 pm

    #1050269

  • RE: Executing Package on 64 bit machine

    amit (9/7/2009)

    The package on both the machines are different but have the same functionality with diffrent sql connection.

    the common is the asp.net code on both the machines

    What is the package...

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

    September 7, 2009 at 11:00 am

    #1050178

  • RE: Executing Package on 64 bit machine

    amit (9/7/2009)

    DontSaveSensitive

    You said you are using SQL Server credentials to login. But with this setting unless you provide the password with external configuration file, the connection will not work.

    You said...

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

    September 7, 2009 at 10:08 am

    #1050168

  • RE: Executing Package on 64 bit machine

    amit (9/7/2009)

    This particular code executes properly when executed on 32 bit windows 2003 with no errors

    Its throwing error on 64 bit machine only.

    package functionality is importing excel data into sql...

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

    September 7, 2009 at 8:54 am

    #1050144

  • RE: Flat file source working

    The code page is user configurable in the flat file connection manager.

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

    September 7, 2009 at 5:25 am

    #1050052

Viewing 15 posts - 601 through 615 (of 1,118 total)