Forum Replies Created

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

  • RE: DT_DBTIMESTAMP Not Displaying Properly in .CSV Destination File

    MostInterestingMan (8/10/2010)

    Hello,

    I have a date column with data type DT_DBTIMESTAMP that I am exporting to .csv. In the Flat Connection Manager the data type is correct and I can see...

    [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]

    August 10, 2010 at 4:41 pm

    #1205084

  • RE: Can we schedule SSIS packages using SQL Agent on a server where SSIS is not installed

    sree-879715 (8/10/2010)

    Hi,

    Is there a way to create a package on the server where I have SSIS installed and export it to another server where we dont have SSIS and schedule...

    [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]

    August 10, 2010 at 1:20 pm

    #1205003

  • RE: Code reuse in script component

    stricknyn (8/10/2010)

    Hi All,

    I have a script component which contains a function that will be used by many script components in my package. I was just looking for some pointers...

    [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]

    August 10, 2010 at 12:55 pm

    #1204994

  • RE: Assigning NULL Value to string variable failing.

    Which is very obvious as .value has a return type of String hence casting.

    Here you may avoid Convert.ToString() as .ToString() is appended to take care of the conversion.

    We can't avoid...

    [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]

    August 10, 2010 at 9:31 am

    #1204865

  • RE: Timeline chart

    I have tried a stacked bar chart in SSRS, and can almost get what I need, although the axis cannot be labelled with times, only with duration. I have also...

    [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]

    August 9, 2010 at 3:27 pm

    #1204431

  • RE: dynamic changing connection string to retrieve .sql files

    No problem. You are welcome.

    [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]

    August 9, 2010 at 1:10 pm

    #1204350

  • RE: Dynamic T-SQL Script To Drop Tables

    sunshine-587009 (8/6/2010)

    I get the result set of what is inside the table twice. The temp tables are still there. 🙁

    Yes. I didnot notice that. Is there a need of storing...

    [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]

    August 6, 2010 at 2:24 pm

    #1203784

  • RE: Dynamic T-SQL Script To Drop Tables

    -- NOTHING WORKS BELOW THIS LINE

    exec 'Select SqlCmdLine from #SQLCmd'

    Can you try this?

    exec ('Select sqlcmdline from #sqlcmd') ?

    [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]

    August 6, 2010 at 1:58 pm

    #1203769

  • RE: Assigning NULL Value to string variable failing.

    Other option is to declare the variable as type "Object".

    Then you have convert it back to string and store that in a string variable in an activex script like below..

    ...

    [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]

    August 6, 2010 at 10:30 am

    #1203659

  • RE: DTS Packages on SQL Server 2005 64bit

    Jpotucek (8/6/2010)

    The Server I am migrating the packages FROM and the Server that the packages are going TO are on two different and seperate Networks at two different hosting facilities....

    [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]

    August 6, 2010 at 9:32 am

    #1203613

  • RE: DTS Packages on SQL Server 2005 64bit

    I have a sql server 2005 on a 32 bit platform and we run about 20 DTS packages in backward compatibility mode.. in other words, the DTS packages show up...

    [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]

    August 6, 2010 at 9:09 am

    #1203596

  • RE: Do not Fail Package - SSIS

    Janie.Carlisle (8/6/2010)

    Sounds like an interesting option although I am not sure how to do it. What is happening now is the package is going into SAP and extracting data from...

    [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]

    August 6, 2010 at 8:58 am

    #1203585

  • RE: Question Regarding SaveToDtsServer Method.

    SwedishOrr (8/5/2010)

    The reference material I'm looking at is under the C# example space at http://technet.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.savetodtsserver.aspx. Specifically, the line I'm curious about is "app.SaveToDtsServer(p, null, @"File System\myFolder2", "yourserver");"

    What is "File...

    [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]

    August 5, 2010 at 3:02 pm

    #1203150

  • RE: Do not Fail Package - SSIS

    Janie.Carlisle (8/5/2010)

    I inherited a package that generally runs well and gets the job done. However, occasionally when doing a date conversion from SAP date to SQL datetime, it encounters 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]

    August 5, 2010 at 2:58 pm

    #1203148

  • RE: Dynamic Flat File connection with wildcard

    geilecj (8/5/2010)

    So, I assume a for-each loop will be needed for each filetype...

    I have done it this way before but just becomes a PAIN when you have 15 for loops...

    [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]

    August 5, 2010 at 11:15 am

    #1202978

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