deals2buy Posted April 12, 2013 Report Share Posted April 12, 2013 [quote name='loveindia' timestamp='1365718359' post='1303587308'] Aa package re open chesi save cheyyi inkosari.. i believe it should work, unless there are any changes in the names / parameters used.. If everything is exactly the same, then it will... [/quote]no it doesn't work....everytime you delete and add a package it creates an id for each package no matter if you create/open the package with the same name in the master package... So, child packages upload chesina taruvatha malli master package open chesi you need to point to the newly uploaded packages that way it points to the new id of the packages and runs successfully Link to comment Share on other sites More sharing options...
loveindia Posted April 12, 2013 Report Share Posted April 12, 2013 [quote name='Kaarthikeya' timestamp='1365777729' post='1303590929'] no it doesn't work....everytime you delete and add a package it creates an id for each package no matter if you create/open the package with the same name in the master package... So, child packages upload chesina taruvatha malli master package open chesi you need to point to the newly uploaded packages that way it points to the new id of the packages and runs successfully [/quote] when I meanted reopen, that was only in my mind le.. .. thanks for detailing.. btw appudey tellarindaaa neeku ikkada tagaladdav... nuvvu asalu ye company pm pls... kudiritey jagrattagaa untaa.. Link to comment Share on other sites More sharing options...
deals2buy Posted April 12, 2013 Report Share Posted April 12, 2013 ee Global variables thatangam endi vayya? environment maarchinappudalla anni packages lo manual ga maarchukuntu kurchovaala? Link to comment Share on other sites More sharing options...
deals2buy Posted April 15, 2013 Report Share Posted April 15, 2013 naa daggara currenlty script task dwaara oka txt file lo naaku kaavalsina specific records ni pull chesi database lo ki load chestunna but I want to use SQL instead of script task to do the same... currently ScriptTask>Deletes records that I dont want itself in the file> Load to database (txt file lo 10 columns unte database lo ki 9 columns ey load chestunna)-this involves file-staging-reporting tables Future ela cheste better antaaru using sql? is it good to add the column to existing staging table or create a new table with all the columns and load data and then to stage table? PS: performance level lo asking Link to comment Share on other sites More sharing options...
loveindia Posted April 15, 2013 Report Share Posted April 15, 2013 [quote name='Kaarthikeya' timestamp='1366044761' post='1303606158'] naa daggara currenlty script task dwaara oka txt file lo naaku kaavalsina specific records ni pull chesi database lo ki load chestunna but I want to use SQL instead of script task to do the same... currently ScriptTask>Deletes records that I dont want itself in the file> Load to database (txt file lo 10 columns unte database lo ki 9 columns ey load chestunna)-this involves file-staging-reporting tables Future ela cheste better antaaru using sql? is it good to add the column to existing staging table or create a new table with all the columns and load data and then to stage table? PS: performance level lo asking [/quote] modalettavaaa... saturday, sunday maatram atha patha lekunda potaav... Link to comment Share on other sites More sharing options...
deals2buy Posted April 15, 2013 Report Share Posted April 15, 2013 [quote name='loveindia' timestamp='1366045681' post='1303606305'] modalettavaaa... saturday, sunday maatram atha patha lekunda potaav... [/quote] Saturday and Sunday no DB man... Link to comment Share on other sites More sharing options...
deals2buy Posted April 16, 2013 Report Share Posted April 16, 2013 [b] Change Order of Column In Database Tables[/b] How to change the order of the column in database table? It happens many times table with few columns is already created. After a while there is need to add new column to the previously existing table. Sometime it makes sense to add new column in middle of columns at specific places. There is no direct way to do this in SQL Server currently. Many users want to know if there is any workaround or solution to this situation. First of all, If there is any application which depends on the order of column it is really not good programming and will create problem for sure in future. In ideal scenario there should be no need of order of column in database table. Any column can be any where and it can be used for any data process (INSERT, UPDATE, SELECT). There are few cases where order of column matters. Let us see the valid and invalid cases of dependence on order of column. If there is application of BULK INSERT or BCP the order of column matters when creating the table. This is valid reason for the case where order of column matters. If there is insert statement where column names are not specified the order of column will create issue, this case demonstrate lazy developer and inappropriate coding style. If you really want to insert your column at any specific place. There are two different ways to do that. [b]Method 1 : [/b]Add column in Management Studio using GUI and visual aid and create the table with necessary order of column. If table is too large, this put lock on entire table and create temporary outage for that table to be used. [b]Method 2 :[/b] Create new table with the name “New_YourTable” name with your desired table structure and column order. Insert values from your existing “YourTable” to this “New_YourTable”. Drop the existing table “YourTable” and rename “New_YourTable” to “YourTable”. This is again resource consuming exercise along with chance of getting something wrong if this is heavily used production server. [b]Method 3 :[/b] Just do not worry, keep the column as they are but you can create view on the base table with your desired column order. Link to comment Share on other sites More sharing options...
deals2buy Posted April 16, 2013 Report Share Posted April 16, 2013 paina post lo Method1 ardham enti asalu? also ee kinda daantlo cheppinattu naakem SSMS lo kanipinchatledu In SQl server 2008: Use SQL Server Management Studio (2008) and from the menu go to Tools -> Options -> Designers -> Table and database designers and Unselect default option “Prevent saving changes that require table re-creation” For DBA: Can change field order in “colorder” column in syscolumns table Is it because I don't have Admin privileges? Link to comment Share on other sites More sharing options...
loveindia Posted April 18, 2013 Report Share Posted April 18, 2013 Karthikeya, ekkada poyav.. I am missing your questions re.. SSIS package ni higher environments ki move chese appudu teeskovalsina jagrattalu mariyu passwords ela move chestaaroo steps veyyi okasari.. verey vallaki ivvali urgent ga... Link to comment Share on other sites More sharing options...
JUJUBI_JULABI Posted April 18, 2013 Report Share Posted April 18, 2013 ssrs report lo body lo page number ela use cheyali ? .. google lo unnavi not working Link to comment Share on other sites More sharing options...
deals2buy Posted April 18, 2013 Report Share Posted April 18, 2013 [quote name='loveindia' timestamp='1366297410' post='1303625822'] Karthikeya, ekkada poyav.. I am missing your questions re.. SSIS package ni higher environments ki move chese appudu teeskovalsina jagrattalu mariyu passwords ela move chestaaroo steps veyyi okasari.. verey vallaki ivvali urgent ga... [/quote]naa questions missing endi vaay? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] I posted lot of questions above [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] jaagrthalu ante naakem specific ga kanipinchale...also maa daggara packages vetiki passwords levu nenu few days back chesindi aithe 1) Save the package in an environment(say DEV) as file system object 2) Move the file to shared path 3) Then open the above saved File system objects which are the DTS packages in whateever environment u want PS: vere environment lo avi open chesetappudu if the file exists already, u need to rename it or delete or backup it somehow and add the new packages Also, oka tool untadi...DTS package mover ani...nenu ninnane chusa...I don't know if it is a third party tool..but andulo wizard dwaara migrate cheyyochu...which is an easy process AFAIK Link to comment Share on other sites More sharing options...
loveindia Posted April 18, 2013 Report Share Posted April 18, 2013 [quote name='Kaarthikeya' timestamp='1366298120' post='1303625895'] naa questions missing endi vaay? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] I posted lot of questions above [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] jaagrthalu ante naakem specific ga kanipinchale...also maa daggara packages vetiki passwords levu nenu few days back chesindi aithe 1) Save the package in an environment(say DEV) as file system object 2) Move the file to shared path 3) Then open the above saved File system objects which are the DTS packages in whateever environment u want PS: vere environment lo avi open chesetappudu if the file exists already, u need to rename it or delete or backup it somehow and add the new packages Also, oka tool untadi...DTS package mover ani...nenu ninnane chusa...I don't know if it is a third party tool..but andulo wizard dwaara migrate cheyyochu...which is an easy process AFAIK [/quote] passwords untey ela migrate cheyyalo kuda cheppu... cheppalekapotey cheppu chebrolu vellipotaa... Link to comment Share on other sites More sharing options...
loveindia Posted April 18, 2013 Report Share Posted April 18, 2013 [quote name='JUJUBI_JULABI' timestamp='1366297942' post='1303625872'] ssrs report lo body lo page number ela use cheyali ? .. google lo unnavi not working [/quote] 2008 r 2005 lo?? 2008 lo inbuilt undi kada.. Link to comment Share on other sites More sharing options...
Darling999 Posted April 18, 2013 Report Share Posted April 18, 2013 [quote name='loveindia' timestamp='1366297410' post='1303625822'] Karthikeya, ekkada poyav.. I am missing your questions re.. SSIS package ni higher environments ki move chese appudu teeskovalsina jagrattalu mariyu passwords ela move chestaaroo steps veyyi okasari.. verey vallaki ivvali urgent ga... [/quote] [b]jagrattalu: First check whether you have same MSDB folders(Wither SQL or File system) are Same,[/b] [b] During Deployment check the option Do not Save sensitivity data under pkg properties, if your pwd's are [/b] [b] dynamic.[/b] [b] Check [/b][b]for the config file locations in both environments to be the same where you would place them.[/b] [size=4] [/size][b]Check the package configuration settings before assigning them.[/b] [b]Password's" Keep all your pwds's in variables in DEV, create a config file to capture all those variables using package configurations. if you are deploying place them at correct locations. If DBA is deploying provide him with all the config file you create.[/b] [b]These should be fine [/b][size=4] [b]I guess.[/b][/size] [size=4][b]Let me know if any thing else needed[/b][/size] Link to comment Share on other sites More sharing options...
ChampakDas Posted April 18, 2013 Report Share Posted April 18, 2013 GUI lo table medha right click chesi design ki velli add a column aa otion oakte kanipichatledha or Designers -> Table and database designers feature aa ledha? [quote name='Kaarthikeya' timestamp='1366139434' post='1303613575'] paina post lo Method1 ardham enti asalu? also ee kinda daantlo cheppinattu naakem SSMS lo kanipinchatledu In SQl server 2008: Use SQL Server Management Studio (2008) and from the menu go to Tools -> Options -> Designers -> Table and database designers and Unselect default option “Prevent saving changes that require table re-creation” For DBA: Can change field order in “colorder” column in syscolumns table Is it because I don't have Admin privileges? [/quote] Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts