Forum Replies Created

Viewing 15 posts - 451 through 465 (of 543 total)

  • RE: How to add new column in SSIS Package at run time

    Jeff Moden (12/6/2011)


    Charmer (12/6/2011)


    hxkresl (12/4/2011)


    OK, thank you very much for replying!!!

    so, I've changed my approach. I've manually added the column in source file and on destination sql table as...

  • RE: SSAS

    Henrico Bekker (12/6/2011)


    http://lmgtfy.com/?q=SQL+server+Analysis+services

    so you want me to google right? anyway..thanks

  • RE: How to add new column in SSIS Package at run time

    hxkresl (12/4/2011)


    OK, thank you very much for replying!!!

    so, I've changed my approach. I've manually added the column in source file and on destination sql table as smallint.

    My...

  • RE: How to Increment a Row?

    Evil Kraig F (12/5/2011)


    Charmer,

    how are you dealing with concurrency concerns here, IE: Two people are doing the same thing at once, both receive the value (for example) 00004081, and they...

  • RE: How to Increment a Row?

    that's what my problem is...it takes the 1st row instead of current value of JurisID...

    i don't know where i am missing logic ....

    below is what i am using in Script...

  • RE: How to get rid off it?

    GSquared (11/29/2011)


    Charmer (11/29/2011)


    yeh...the thing which i am looking for is, how do they restrict a database for any alteration... ?

    because i could select and update any records...but i couldn't alter...

  • RE: How to get rid off it?

    yeh...the thing which i am looking for is, how do they restrict a database for any alteration... ?

    because i could select and update any records...but i couldn't alter any columns...

    was...

  • RE: How to get rid off it?

    Dev (11/29/2011)


    Charmer (11/29/2011)


    The error was "you don't have permission to create or drop a table"...i remember it was not exactly but something like that...

    It simply means you can't...

  • RE: How to get rid off it?

    yes i was working on a development server not production.....

  • RE: How to get rid off it?

    The error was "you don't have permission to create or drop a table"...i remember it was not exactly but something like that...

  • RE: Last 5 rows

    Dev (11/21/2011)


    Charmer (11/21/2011)


    Hi friends,

    How to add a file into this?

    my DDLs are stored in a notepad...

    How can i import into this..?

    What? Where? How? Didn't get anything...

    If it's not...

  • RE: Last 5 rows

    the DDLs are related to the question that i started..

    so i would like to know how to import files?

  • RE: Last 5 rows

    Hi friends,

    How to add a file into this?

    my DDLs are stored in a notepad...

    How can i import into this..?

  • RE: Last 5 rows

    yes...Duplicate is allowed for RlsID in both the tables...the table structure they created was very worst...

    the table 2 does not have any datatime column...so i am not able to get...

  • RE: Last 5 rows

    i have two tables....1st one has columns name RlseId and a datetime column..

    2nd table has TrackID(primary key,automatic generated) , RlseId(foreign key of 1st table) and RlsTrackId...but no date time column...

    whenever...

Viewing 15 posts - 451 through 465 (of 543 total)