Forum Replies Created

Viewing 15 posts - 31 through 45 (of 54 total)

  • RE: Conversion from DTS to SSIS 2005/2008

    Thanks Dan. Its really helpful !!! 🙂

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 15, 2011 at 7:49 am

    #1312149

  • RE: search and replace SSIS package

    yosiasz (4/14/2011)

    I load them programmatically or by editing the config file?

    You just need to create separate configuration files for all the environment (dev, qa, test, prod). Change the variables and...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 15, 2011 at 7:31 am

    #1312128

  • RE: Derived Column error

    quillis131 (4/11/2011)

    Loading data from flat file to Sql table. I have a column X in table that needs to be updated with time stamp ( this column cannot be...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 12, 2011 at 4:13 am

    #1310277

  • RE: The BIT data type

    Great!!!

    I completely miss the concept of BIT and make it wrong ... :hehe:

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 8, 2011 at 4:05 am

    #1309036

  • RE: SSIS package variables not visable in Execute SQL Task

    MyDoggieJessie

    UPDATE _ReadyTables

    SET Loaded = 1

    WHERE [Table] = ?

    AND ETLDate = (

    SELECT ETLDate FROM dbo._ReadyTables

    WHERE [Table] = ? AND Loaded = 0 )

    I created a variable:

    Variable Name: User::FL_PRICE

    Direction: INPUT

    Data...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 8, 2011 at 3:46 am

    #1309028

  • RE: SSIS package variables not visable in Execute SQL Task

    Walter Tucholski (3/9/2006)

    I am using SSIS 2005 and have variables defined at the package level. When I try to execute a query in an Execute SQL Task it doesn't recognize...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 8, 2011 at 3:41 am

    #1309027

  • RE: Orcale OLEDB parameterized query

    Hey,

    In your case you are missing single quotes ('). Your query should be written inside Var_ZZ's expression property like this.

    "select A, B, C, D,ADDED_DATE, CLIENT_TYPE from Table1

    where CLIENT_TYPE <>...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 7, 2011 at 9:01 am

    #1308603

  • RE: Orcale OLEDB parameterized query

    Hey,

    What is the error that you are getting?

    You can also pass parameter in your OLEDB source adapter. Select Data Access mode as 'SQL Command' then write your query like...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 6, 2011 at 1:23 am

    #1307832

  • RE: Update Issue/Parent/Child package

    I dont think update statement will work like the way you wanted it to as rows are duplicated & it will update the record with 1st occurrence every time you...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 6, 2011 at 12:58 am

    #1307829

  • RE: Update Issue/Parent/Child package

    2) How i can create Parent/Child package(in SSIS), so at the same time i can insert Table1.ORDER_ID and Table2.LOC_ID. Any advise?

    Hey rocky,

    What is the need to create child...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 6, 2011 at 12:38 am

    #1307827

  • RE: Row Transpose to column using SSIS

    ishaan99 (4/5/2011)

    thanks yeah i know pivot transformation can be used but just wanted to see how thats set up in SSIS.

    This might help you-

    http://www.databasejournal.com/features/mssql/article.php/3646531/SQL-Server-2005-Integration-Services---Part-38---Pivot-Transformation.htm 😎

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 6, 2011 at 12:24 am

    #1307819

  • RE: Flat File Destination Issue

    copett86 (4/4/2011)

    I have a DataReader Source using ODBC driver(ADO.NET) for a connection that links to an outbound flat file destination. I use to have a data conversion step, but took...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 5, 2011 at 9:29 am

    #1307534

  • RE: Send Mail based on data count condition.

    Hi,

    Actually this can be achieved through number of ways. But what I was thinking will work best when you could create a tracker table in you DB.

    Something like this will...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    April 4, 2011 at 5:37 am

    #1306917

  • RE: using inner join on update statement

    Hi lrutkowski

    The way you are writing the script will work fine with SSIS 2008, though in your case i would rather suggest to use Script Task. You can update...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    March 13, 2011 at 6:25 am

    #1298104

  • RE: Loop through tables and transfer

    Andrew Williams (3/10/2011)

    Ok so from the postings:

    loop through the tables doing:

    1. Script task to create dynamic sql to create the table if it doesn't exist on destination.

    2. Run sql against...

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

    March 10, 2011 at 7:12 am

    #1297080

Viewing 15 posts - 31 through 45 (of 54 total)