Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 1,118 total)

  • RE: SFTP through SSIS

    qhjghz (1/7/2009)

    Hi,

    I require to do a SFTP through SSIS. I have used WINSCP for this purpose. I have used the command-line utility for WINSCP and am able to upload the...

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

    January 7, 2009 at 7:17 am

    #922516

  • RE: SSIS Package to Export SQL Server 2005 table to XML file

    sinha929 (1/5/2009)

    Hi,

    Does any one know how to create SSIS Package to Export SQL Server 2005 table to XML file? I tried the Export and it does not have any destination...

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

    January 5, 2009 at 11:57 am

    #921344

  • RE: Changing database server dynamically?

    Chris Lee (1/3/2009)

    Hi,

    Thanks for helping out. Sorry I did not make question clear.

    I am trying to make package easy to deploy from development, QA and then to production. I created...

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

    January 3, 2009 at 7:51 pm

    #920806

  • RE: Changing database server dynamically?

    Chris Lee (1/2/2009)

    Hi,

    I have SQL 2005 SSIS SP2 on Windows 2003. Is there a way to detect and change database server name inside SSIS package? Thanks.

    Chris

    Your question is not very...

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

    January 3, 2009 at 7:49 am

    #920687

  • RE: Finding variable and connection manager uses

    GoofyKC (1/2/2009)

    I have some IS processes that are geting rather big and being a newbie I decide later (or more likely find in the forums) better ways to do things....

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

    January 3, 2009 at 7:45 am

    #920685

  • RE: File System Task - Rename using connection manager

    GoofyKC (1/2/2009)

    I hope I am not being thick, but I am trying to move a file from one folder to another and rename the file with some variable information. I...

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

    January 2, 2009 at 12:42 pm

    #920490

  • RE: Why can’t I store my BIGINT result in an Int64 variable?

    Ria (1/2/2009)

    Why can’t I store my BIGINT result in an Int64 variable?

    I've known for some time that to work with BIGINT values from SQL Server in SSIS, you needed...

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

    January 2, 2009 at 12:38 pm

    #920487

  • RE: IF statement

    pleasehelpme (12/31/2008)

    How do you use an IF statement in SSIS?

    I have a table that has a column [status] with values 1,2

    1 = downloaded to stage table

    2 = downloaded to final...

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

    December 31, 2008 at 12:38 pm

    #919797

  • RE: Error while calling the binary version of SSIS package

    Sreejith Sreedharan (12/30/2008)

    Hi,

    I have a SSIS package, it runs without any problem when I run the package through BIDS. Once I build the exe and call the binary I get...

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

    December 31, 2008 at 7:29 am

    #919636

  • RE: devide source table into four equal parts

    surendra (12/29/2008)

    I have One table with huge data.

    i AM PLANING APPLY THE PARALALISM.

    EXTRACT THE TABLE USING FOUR OLEDB SOURCES(SPLIT THE SOURCE TABLE INTO FOUR EQUAL PARTS).

    HOW TO GO BOUT IT?

    You...

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

    December 30, 2008 at 8:17 am

    #919067

  • RE: How to convert EDI PAD files into SQL Server using SSIS

    viji (11/6/2008)

    Hi,

    How to convert EDI PAD files into SQL Server using SSIS 2005

    any suggestions, links are highly appreciated.

    Thanks,

    Regards,

    Viji

    Check EDI Source component. You have to setup 852 configuration using simple XML...

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

    December 29, 2008 at 11:01 pm

    #918762

  • RE: "Set Global Variables" cannot run on this edition of Integration Services.

    Run your SQL Server 2005 installation and select you want to modify existing installation. Select SSIS option to be installed.

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

    December 26, 2008 at 1:59 pm

    #917929

  • RE: "Set Global Variables" cannot run on this edition of Integration Services.

    You have to install SSIS services. If you don't select the option, most of the components will not be deployed. To upgrade your version you have to download and install...

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

    December 24, 2008 at 2:09 pm

    #917567

  • RE: "Set Global Variables" cannot run on this edition of Integration Services.

    The right part of the screen is missing. This is where you should see your SSIS service. Anyway you have to initiate the SQL Server installation and include SSIS option...

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

    December 24, 2008 at 1:36 pm

    #917558

  • RE: "Set Global Variables" cannot run on this edition of Integration Services.

    sachinbb (12/24/2008)

    I have enterprise edition.

    This is what i get with Help > About...

    Microsoft SQL Server Management Studio

    9.00.1399.00

    Microsoft Analysis Services Client Tools2005.090.1399.00

    Microsoft Data Access Components (MDAC)

    2000.086.1830.00 (srv03_sp1_rtm.050324-1447)

    Microsoft MSXML

    2.6 3.0 4.0 6.0...

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

    December 24, 2008 at 1:10 pm

    #917551

Viewing 15 posts - 991 through 1,005 (of 1,118 total)