Forum Replies Created

Viewing 15 posts - 46 through 60 (of 96 total)

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

    guru12 (8/5/2010)

    Hi Everyone..

    nobody are there to give reply for my question,its very urgent ,i would be thnkful to you,please give reply.

    Does the dll file returns the file name as output...

    [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 9:49 am

    #1202875

  • RE: Execution Time to be recorded when SSIS Package is run

    bsembhi (8/4/2010)

    Hi

    I am running my package on a weekly basis but the day and time is not fixed as its not put on a job, I can run it as...

    [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 4, 2010 at 2:00 pm

    #1202363

  • RE: How to Read TEXT data and emailing

    divyanth (8/4/2010)

    Do you want to read the Complete data in that field or just the 30000 characters ? If you want to read complete field i might be able...

    [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 4, 2010 at 1:30 pm

    #1202348

  • RE: How to Read TEXT data and emailing

    PaVeRa22 (8/4/2010)

    Baskar B.V (8/3/2010)

    Thanks for your reply, option 1 is an alternative solution, however my issue was resolved...:-)

    Please let us know how you resolved this issue so that it would...

    [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 4, 2010 at 1:00 pm

    #1202329

  • RE: Assigning a Value to a Package Variable

    I am select a number from a table, and I want to assign that resultset to a SSIS Package Variable. How would I do this, or what object would I...

    [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 3, 2010 at 3:06 pm

    #1201810

  • RE: How to Read TEXT data and emailing

    Thanks for your reply, option 1 is an alternative solution, however my issue was resolved...:-)

    Please let us know how you resolved this issue so that it would be useful for...

    [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 3, 2010 at 12:34 pm

    #1201742

  • RE: How to Read TEXT data and emailing

    Substring is not returning more than 8000 chars, i wanted to read 30000 chars data. tks

    Is it possible to push the data value to a .txt file temporarily 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]

    August 3, 2010 at 10:39 am

    #1201667

  • RE: How to Read TEXT data and emailing

    Did you try Substring function?

    [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 2, 2010 at 12:50 pm

    #1201184

  • RE: Doubt in SSIS Deployment

    Sanz (8/2/2010)

    I have an SSIS package (written by another person)that has been running for sometime now in Production. I need to change a value in one of the variables. After...

    [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 2, 2010 at 10:19 am

    #1201115

  • RE: Add output params to data flow using OLEDB Command?

    Jason Marshall (7/30/2010)

    I have some data coming through the data flow, then I'm trying to run a sproc with two output params for each row using OLEDB command. I...

    [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 30, 2010 at 3:25 pm

    #1200557

  • RE: Reporting Service Instance Question

    I got this resolved. When the instance is <machinename>\rrp i need to access it using the below web url.

    http://<machinename>/Reports$rrp

    and

    http://<machinename>/ReportServer$rrp

    [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 30, 2010 at 12:46 pm

    #1200509

  • RE: SSIS export to table in Excel - numerics exported as text

    allen davidson (7/30/2010)

    Thanks Baskar - If i understand correctly - run the create table in the SSIS data destination then copy the resuting tab and make changes to the...

    [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 30, 2010 at 12:38 pm

    #1200507

  • RE: SSIS export to table in Excel - numerics exported as text

    allen davidson (7/30/2010)

    Hi all, I have seen a few post around the subject of data type problems when exporting to Excel. My problem is INT data exporting as character data...

    [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 30, 2010 at 10:31 am

    #1200466

  • RE: Is it possible to loop through all user variables?

    chrisl-1031171 (7/30/2010)

    I use variables and expressions to create dynamic sql statements in my SSIS package. I am getting an error on a variable but when I use breakpoints Visual Studio...

    [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 30, 2010 at 9:48 am

    #1200446

  • RE: For each Loop container in SSIS

    We have One main folder and 12 different sub-folder. Each sub folder will have one file. These files are refreshed weekly. There is also an arcival proccess which will archive...

    [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 3:43 pm

    #1200075

Viewing 15 posts - 46 through 60 (of 96 total)