Forum Replies Created

Viewing 15 posts - 406 through 420 (of 544 total)

  • RE: Synchronizing two Databases in SSIS?

    Pankaj Shere (1/17/2012)

    I would use transactional replication, its pretty easy to set up from the GUI. Also this article explains the entire replication process in detail, http://msdn.microsoft.com/en-us/library/ms151198.aspx

    Hi,

    my need is to...

    Thanks,
    Charmer

    January 18, 2012 at 3:57 am

    #1435101

  • RE: Synchronizing two Databases in SSIS?

    Daniel Bowlin (1/17/2012)

    I think it would be better to just set up replication.

    how to do replication?

    Thanks,
    Charmer

    January 17, 2012 at 9:54 am

    #1434710

  • RE: Transfer SQL Server Objects Task

    Robert Murphy UK1 (1/17/2012)

    This task is a nightmare! Sure you cant backup/restore or detach/reattach?

    Check out all the options for this task I'm sure it will be one of them thats...

    Thanks,
    Charmer

    January 17, 2012 at 9:54 am

    #1434709

  • RE: Variables in SQL Command

    John Mitchell-245523 (1/12/2012)

    What is the value of @[User::JurisID] at runtime?

    John

    Thanks for the response buddy....it worked...

    Thanks,
    Charmer

    January 12, 2012 at 2:19 am

    #1432301

  • RE: Data conversion in script component?

    Martin Schoombee (1/10/2012)

    You will have to test it in different scenarios to ensure that it works.

    I understand that creating a data conversion task for every package is a little...

    Thanks,
    Charmer

    January 10, 2012 at 7:44 am

    #1431165

  • RE: Variables in Flat file Connection?

    aaa-322853 (1/10/2012)

    Don't think this is SSIS. Certainly sounds like permissions to me.

    When you see this error are you running the package in bids from your own machine or using...

    Thanks,
    Charmer

    January 10, 2012 at 7:35 am

    #1431151

  • RE: Variables in Flat file Connection?

    JasonYousef (1/10/2012)

    So what's the error message? is it a permission issue or can't find the path?

    I'm not sure if you can connect using the '$' sign to a hidden share,...

    Thanks,
    Charmer

    January 10, 2012 at 6:11 am

    #1431049

  • RE: Data conversion in script component?

    Martin Schoombee (1/6/2012)

    Data from an Excel source is always unicode, so unless your destination table's columns are all unicode you have no choice but to use the data conversion task...

    Thanks,
    Charmer

    January 10, 2012 at 4:13 am

    #1430983

  • RE: Variables in Flat file Connection?

    Brian Kukowski (1/6/2012)

    Is creating a mapped drive an option in your environment ?

    no its a different server..

    Thanks,
    Charmer

    January 10, 2012 at 2:38 am

    #1430948

  • RE: SQL Server 2008 Client Import Export Wizard

    nazareena.sulthana (1/9/2012)

    Iam getting the same overflow error.

    By chaning the datasource to Microdoft OLE DB provider for SQL Server inserted properly the values in one table which was failiing....

    Thanks,
    Charmer

    January 10, 2012 at 2:34 am

    #1430946

  • RE: SQL Server 2008 Client Import Export Wizard

    nazareena.sulthana (1/6/2012)

    Thanks for the response

    yes iam using Microsoft SQL Server Native Client 10.0

    Actually SQL database is in MS SQL Server 2005 and import wizard

    iam using MSSQL Server 2008...

    Thanks,
    Charmer

    January 6, 2012 at 4:30 am

    #1429549

  • RE: SQL Server 2008 Client Import Export Wizard

    use data conversion transformation to check with all the date type formats...

    if it ain't solve the problem try to use derived column transformation with some replace and sub strings...like i...

    Thanks,
    Charmer

    January 6, 2012 at 4:20 am

    #1429538

  • RE: SQL Server 2008 Client Import Export Wizard

    nazareena.sulthana (1/6/2012)

    Thanks for the response

    yes iam using Microsoft SQL Server Native Client 10.0

    Actually SQL database is in MS SQL Server 2005 and import wizard

    iam using MSSQL Server 2008...

    Thanks,
    Charmer

    January 6, 2012 at 4:06 am

    #1429530

  • RE: SQL Server 2008 Client Import Export Wizard

    can you post some of your sample date values in here..?

    if your value is like this YYYY-MM-DD-HH.MM.SS.000000.

    it will not be supported by the SQL...

    so try to change the...

    Thanks,
    Charmer

    January 6, 2012 at 3:58 am

    #1429528

  • RE: SQL Server 2008 Client Import Export Wizard

    nazareena.sulthana (1/6/2012)

    Actually Iam using Import export wizard to migrate the data from DB2 to SQL Server 2008.

    As i said before i used in my mapping for timestamp (135) to DT_DBTIMESTAMP...

    Thanks,
    Charmer

    January 6, 2012 at 3:32 am

    #1429519

Viewing 15 posts - 406 through 420 (of 544 total)