Forum Replies Created

Viewing 15 posts - 391 through 405 (of 544 total)

  • RE: SSIS 2008 to 2005?

    SQLRNNR (2/2/2012)

    Charmer (2/2/2012)

    Hi,

    When i try to execute a package from 2008 to 2005, i get this error...

    Are you executing a 2008 package against a 2005 database or are you trying...

    February 2, 2012 at 6:49 am

    #1441776

  • RE: How to Pass a value from the table to the varaible?

    Thank you Guys...I got it

    January 31, 2012 at 1:56 am

    #1440407

  • RE: Removing Commas in derived Column?

    Jeff Moden (1/25/2012)

    phil.walter 85406 (1/24/2012)

    simply REPLACE([FIELD NAME],',','')

    It won't work for the third example the OP gave where the comma between two items must be preserved.

    Thanks Guys for the ideas given

    January 25, 2012 at 6:20 am

    #1438193

  • RE: whle loop in ssis?

    Evil Kraig F (1/24/2012)

    Charmer (1/24/2012)

    Hi friend,

    my source is oledb only...

    Than FOR XML is probably best. Why avoid the easy method?

    Could you gimme some samples to do this in script...

    January 25, 2012 at 1:40 am

    #1438129

  • RE: SQL server job agent?

    Steve Jones - SSC Editor (1/24/2012)

    Where are the variables? How are you setting them? You many or may not need to pass them in, depends on what you've done in...

    January 24, 2012 at 10:09 am

    #1437799

  • RE: Without DateTime Column?

    herladygeekedness (1/24/2012)

    Sounds like someone gave you lousy requirements!

    In my opinion, if there is no column in which to check the criteria, you cannot use that criteria.

    That said, not knowing where...

    January 24, 2012 at 10:04 am

    #1437791

  • RE: whle loop in ssis?

    Evil Kraig F (1/23/2012)

    Jeff Moden (1/23/2012)

    I have to ask... is a FOREACH loop in SSIS going to be as effecient as creating a result set in a stored procedure that...

    January 24, 2012 at 2:56 am

    #1437533

  • RE: Removing Commas in derived Column?

    Dev (1/23/2012)

    I am trying to guess the reason for Jeff’s question. I received few csv files from customer couple of day’s back, that had similar structure. It was...

    January 23, 2012 at 7:21 am

    #1437091

  • RE: Removing Commas in derived Column?

    Jeff Moden (1/23/2012)

    Charmer (1/23/2012)

    Hi Friends,

    i have a column having some records like ",Clayton" and "Township," and "Clayton, Dept" ...

    i want to remove unnecessary commas which is...

    January 23, 2012 at 6:53 am

    #1437058

  • RE: Synchronizing two Databases in SSIS?

    ramu.a (1/18/2012)

    hello but you tried with your colleague machine..That machine have local IP not for public IP. that is one mistake .

    take copy of original database Backup(having public...

    January 19, 2012 at 7:52 am

    #1435867

  • RE: Trnasfer SQL Server Objects Task

    padhis (1/19/2012)

    Are you getting any error message while executing the package?

    yes...the error is below..

    Failed to connect to the server

    Error code: 0x80131501. The validate method must succeed and indicate the result...

    January 19, 2012 at 5:23 am

    #1435746

  • RE: Synchronizing two Databases in SSIS?

    ramu.a (1/18/2012)

    if u have two different server with public IP u can synchronize that database...is possible...i did transaction replication.now its running successfully....

    oh..but i tried with one of my colleague machine..but...

    January 18, 2012 at 9:00 am

    #1435328

  • RE: Synchronizing two Databases in SSIS?

    is it possible synchronizing database from one server to another server....like client to my machine...because stairway explains with the local machine...so my doubt is whether it is possible for different...

    January 18, 2012 at 6:51 am

    #1435202

  • RE: Synchronizing two Databases in SSIS?

    ramu.a (1/18/2012)

    using replication we can transfer all the records from live database to Backup Database..

    please find stairways in our website...clear information provided .

    Thanks Buddy..it was very help full....but the...

    January 18, 2012 at 6:27 am

    #1435190

  • RE: Synchronizing two Databases in SSIS?

    Hi friends

    i used Transactional Replication and it worked on my local machine...but when i tried to do on another machine as a subscriber..it is not working...it creates the database but...

    January 18, 2012 at 5:50 am

    #1435171

Viewing 15 posts - 391 through 405 (of 544 total)