Ms Sql Server Technology Discussions

[ghazni]

[quote name='mtkr' timestamp='1362884482' post='1303395816']


ne exe pkg tsk variables ni read chesthundemooo chusava mama!!!?
[/quote]
yeah chusa mama...........

[ghazni]

[quote name='ghazni' timestamp='1362885545' post='1303395935']
yeah chusa mama...........
[/quote]
variable undi package folder ani andulo path undi.......... adi ekada call chestunaro teliyadam ledu........

[ghazni]

[quote name='DARLING...' timestamp='1362883435' post='1303395697']
1. Config file Antey nuvvu pass chesey parameter bayata file nundi pass avtundi jus for instance:

Assume there is a query select * from tbl where I'd between ? And ? Ila Ichaav anukoo. Mee variable lo query untundi but daaniki values Maatram confit file nundi pass avtaayi. So nuvvu confit disable chesinappudu Aah values direct or variables thru pass chestaav.

2. Chk whether ur packages are in the right path, which u are defining in. Also ne patha proj lo unna packages ni pick cheskuntey tarvaatha changes chesinappudu avi effect avtaayi, so keep then in a seperate path and run them.
[/quote]
[quote name='mtkr' timestamp='1362884482' post='1303395816']


ne exe pkg tsk variables ni read chesthundemooo chusava mama!!!?
[/quote]

connection manager variable unadi chusukoledu....... connection manager lo vere path una how did it run the packages that were in my present project..............

patha packages ki veli chusa em changes effect avaledu...............

[mtkr]

[quote name='ghazni' timestamp='1362885870' post='1303395969']
variable undi package folder ani andulo path undi.......... adi ekada call chestunaro teliyadam ledu........
[/quote]


exec pkg tsk lo expressions lo eee declare chesina variables ni assign chesaremo chusavaaa??

[ghazni]

[quote name='mtkr' timestamp='1362886711' post='1303396091']
exec pkg tsk lo expressions lo eee declare chesina variables ni assign chesaremo chusavaaa??
[/quote]
[quote name='ghazni' timestamp='1362886070' post='1303396006']
connection manager variable unadi chusukoledu.......[b] connection manager lo vere path una how did it run the packages that were in my present project.[/b].............

patha packages ki veli chusa em changes effect avaledu...............
[/quote]

[vizagpower]

Guyss need SSIS Sample resumes . please,please pm me guys its urgent re !!!!!!!!!!!!!!!

[mtkr]

[quote name='vizagpower' timestamp='1362934809' post='1303398962']
Guyss need SSIS Sample resumes . please,please pm me guys its urgent re !!!!!!!!!!!!!!!
[/quote]
PM me ur mail id

[deals2buy]

[quote name='ghazni' timestamp='1362885138' post='1303395895']
nenu anni packages vere folder loki tisukuna ........ and project lo add chesetapudu existing files nunchey chesa..... aitey execute package connection manager lo ipudu una packages path istuna kani enta save chesina malli patha packages path key potundi...... aa execute package task lo unavi child packages.... kani master package execute chesinapudu na project lo una child packages ey execute avtunayi.......... naku adey kavali kani by any chance aa path change avakunda original packages lo changes kavu kada......
[/quote]

konni saarlu packages change cheyyadaniki permissions undavu kadaa...kotha copy okati create cheskoni test chesta nenu..maa dantlo Dev lo kuda only DBAs can change the existing package...

[ChampakDas]

  :D

[ChampakDas]

one more point even if you run the console command procedure it wont give any errors thats tricky part here
no errors ani chupistundi..even though there is allocation problem

[size=3]CHECKDB found 0 allocation errors and 0 consistency errors in database[/size]

[chelsea]

guys i need to improve my t-sql skills on line manchi ga pratice cheyyataniki any web sites ?

[ChampakDas]

help..
[quote name='chelsea' timestamp='1363281709' post='1303424127']
guys i need to improve my t-sql skills on line manchi ga pratice cheyyataniki any web sites ?
[/quote]

[loveindia]

[quote name='chelsea' timestamp='1363281709' post='1303424127']
guys i need to improve my t-sql skills on line manchi ga pratice cheyyataniki any web sites ?
[/quote]

there will not be any practice websites.. All you have to do download sample databases and work on them.. Download MURACH SQL SERVER 2005 & 2008 R2 PDF and try all exercises.. the best book I have read in recent times.

[chelsea]

[quote name='loveindia' timestamp='1363284887' post='1303424607']

there will not be any practice websites.. All you have to do download sample databases and work on them.. Download MURACH SQL SERVER 2005 & 2008 R2 PDF and try all exercises.. the best book I have read in recent times.
[/quote]


thanks ba nuvu training isthava free aithe naku PM the details

[loveindia]

[quote name='chelsea' timestamp='1363535048' post='1303439126']


thanks ba nuvu training isthava free aithe naku PM the details
[/quote]

nenu next batch start chesinappuudu istaanu.. free gaaney.. I take only money from consultancy people not students..