Forum Replies Created

Viewing 15 posts - 61 through 75 (of 96 total)

  • RE: job which internally executes SSIS package runs forever.

    alpesh-419376 (7/29/2010)

    Hi,

    I have job which internally executes SSIS package. the issue is when i run this job it shows executing but do not actully runs the package which is...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 29, 2010 at 2:49 pm

    #1200062

  • RE: Log File

    In other words, let's say I've got a text file with a 1,000 records and 2 of those records are bad and can't be loaded. I'd like for 998...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 29, 2010 at 2:45 pm

    #1200061

  • RE: SSIS Date Not Formatting Correctly

    MostInterestingMan (7/27/2010)

    Hello,

    I have a straightforward package that uses an OLEDB Source to copy data using a query to a Flat File Connection Destination (.csv). The date field is not displaying...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 27, 2010 at 3:27 pm

    #1199007

  • RE: SSIS(Script Component): Assign values to global variables & pass to stored procedure

    As Phil mentioned this would be a flaw in the code as this event (post-execute) would get executed only for the final row in the pipeline.

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 27, 2010 at 1:53 pm

    #1198944

  • RE: No records in db after importing a 60GB db over the network

    SSIS is also just using SQL under the hood right? Why don't I have to use distributed queries then in SSIS?

    You can use distributed queries but then you need to...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 27, 2010 at 10:20 am

    #1198825

  • RE: SSIS help please!

    can you post how you are running the SSIS against sql 2000? Are you running the SSIS graph from your local machine and the connection settings pointing to the SQL...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 27, 2010 at 10:12 am

    #1198816

  • RE: No records in db after importing a 60GB db over the network

    if you have the flexibility of editing the ssis package if you need to restart the process.. then you can manually get the max value of the recordset that were...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 27, 2010 at 9:56 am

    #1198809

  • RE: How to do parllel ETL for identical sources

    sqlfavor (4/7/2010)

    I have identical source databases(SQL Server) that I want to perform parallel ETL into single DW. The number of source databases can vary, so some sort of dynamic connection...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 26, 2010 at 10:07 am

    #1198281

  • RE: SSIS(Script Component): Assign values to global variables & pass to stored procedure

    Can you check the data type of the variable "Error1"? Also is there a need to perform this inside data pump? You can do this in control flow itself and...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 26, 2010 at 9:32 am

    #1198262

  • RE: No records in db after importing a 60GB db over the network

    Is it also possible/necessary to adjust the max size of the transaction log? If yes, where can i do that?

    And will this dataflow task be able to resume in case...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 26, 2010 at 9:12 am

    #1198255

  • RE: No records in db after importing a 60GB db over the network

    Questions:

    - Is there a way to 'repair' the imported db? Since the data seems physically there on the hdd, and the row importing process went till 100%

    - Is there a...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 23, 2010 at 2:29 pm

    #1197768

  • RE: Getting empty string instead of NULL when importing to OLE DB destination with Keep Nulls true

    Did you check the checkbox that "Retain null values from the source as null values in the data flow" in the flat file connection manager?

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 22, 2010 at 3:46 pm

    #1197228

  • RE: maximum insert commit size in SSIS

    anand_vanam (7/21/2010)

    I am loading Data from a flat file to SQL Server Table.

    I execute the package by keeping maximum insert commit size property in OLEDB destination to 0 (zero)

    [OLE...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 22, 2010 at 1:40 pm

    #1197152

  • RE: Compare two variables --> do something if they are not equal

    peterzeke (7/21/2010)

    I'm trying to develop a package that first compares the record counts of two tables. If the counts don't match, then the next step is to replace the current...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 21, 2010 at 1:29 pm

    #1196452

  • RE: Connection issue: SSAS 2005

    The issue got resolved after running chkdisk on my laptop... It was popping up everytime when i reboot my machine.. I tried that once and the connection issue got resolved.

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    July 20, 2010 at 1:43 pm

    #1195778

Viewing 15 posts - 61 through 75 (of 96 total)