Forum Replies Created

Viewing 15 posts - 811 through 825 (of 1,118 total)

  • RE: Script task + xml imput

    chatwithkrishan (4/29/2009)


    Public Sub Main()

    sqlconn = New SqlConnection("data source=ss;initial catalog=ss;uid=sa;pwd=sa")

    sqlcmdFinal = New SqlCommand("test", sqlconn)

    ...

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

  • RE: How to get Current configuration file name and path, package tasks list in execution order and package running path from the Script task in SSIS

    smadeswaran (4/29/2009)


    Is it possible to get the following from the Script task in SSIS

    1. Current configuration file name and path when it is passed using dtexec command.

    2. Current package tasks...

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

  • RE: Precedence Constraints

    aprasy (4/28/2009)


    Thanks for your reply. I dont know how to run the second data flow task while the first data flow task is done. Can u clear this? I...

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

  • RE: Dynamic Oracle Connection with SSIS

    Amith Vemuganti (4/27/2009)


    Hello All,

    I have an SSIS package sourcing Oracle database. I could connect with no issues when I give the connection details directly, however, I have connection issues when...

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

  • RE: XML insertion into SQL Server using Integration Services

    JamesNZ (4/27/2009)


    CozyRoc (4/27/2009)


    JamesNZ (4/26/2009)


    Thanks for that.

    Based off those links you provided I've managed to create the attached (see screenshots).

    I managed to get the Insert working just fine, but couldn't manage...

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

  • RE: XML insertion into SQL Server using Integration Services

    JamesNZ (4/26/2009)


    Thanks for that.

    Based off those links you provided I've managed to create the attached (see screenshots).

    I managed to get the Insert working just fine, but couldn't manage to get...

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

  • RE: XML insertion into SQL Server using Integration Services

    JamesNZ (4/25/2009)


    I've got the attached package which successfully inserts a whole heap of data from XML into a SQL Server table.

    My problem lies is that if the XML has...

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

  • RE: Using Script Task Editor with out Microsoft Visual Studio for Applications

    george.auckland (4/24/2009)


    Do I have to have Microsoft Visual Studio for Applications installed in order to user Script Task Editor, or is there another way to execute a script.

    Your question is...

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

  • RE: SQL Server Agent Error - Package exports data to XML and uploads to FTP

    SQLBuddy (4/23/2009)


    Hi All,

    I have a pakcage that exports data from SQL to XML file, then uploads the same to the FTP server.

    I can execute the package successfully from both the...

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

  • RE: Dynamic OLEDB destinations

    Did you have to do programmatic building of data flows? What is the solution you have come up?

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

  • RE: Dynamic OLEDB destinations

    vishal.gamji (4/13/2009)


    I have a task at hand of migrating 1000 tables from AS400 to SQL Server. I automated the part of bringing the data into a Raw area, but now...

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

  • RE: Executing SSIS package without BIDS

    Panks (4/22/2009)


    Just wanted to know how do i execute a ssis package without BIDS.

    I have tried the following and failed:

    1) By job - Job does not give execute SSIS package...

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

  • RE: Precedence Constraints

    aprasy (4/22/2009)


    Hi All,

    I have a question about Precedence Constraints in data flow task. My scenario is i have used multicast to connect multiple destination....

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

  • RE: Download fies from FTP Location(UNIX) using FTP Task

    dhamo_2 (4/20/2009)


    Hi,

    I have set of files in FTP location (UNIX). I dont know how to move this files to my local folder.

    If anyone has some idea please let me...

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

  • RE: Downloading files using SSIS

    Matthew Cushing (4/17/2009)


    The client I'm working with won't do anything that isn't SFTP, so I had to figure out a way to run a script.

    I have a simple script I'm...

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

Viewing 15 posts - 811 through 825 (of 1,118 total)