oledb command

-

how oledb command transformation works how give parameter values

thx regards dinesh vv

here go:

ole-db command transformation

mcts, mcitp - please mark posts answered appropriate.



SQL Server  >  SQL Server Integration Services



Comments

Post a Comment

Popular posts from this blog

Top N or Bottom N filter based on a parameter

-
i have report parameter selection filtering data, either "highest" or "lowest".  if pick "highest" want top n, if "lowest" want bottom n.  how can set in filter ? j. way there many ways set report accomplish this. e.g asuming "n" fixed, you'll set report parameter has 2 hard-coded values "top" , "bottom" , based on user selects, can write report dataset query if (parameter value = "top") select top n ...... else if (parameter value = "bottom") select top n ......order <ordered column name> desc (again there other ways of doing too) else (whatever business logic needs go here, if @ all) if wanted keep n input parameter well, in addition above top/bottom filter, you'll add input filter (preferably free-text input) accept n , build dynamic sql string concatenating input parameter value in logic above. hope gets on right track. cheers! -muqadder. ...
Read more

Motherboard replacement

-
running windows 10 technical preview, need replace motherboard can run the  sysprep  command restoring pc ? or there easier  or more preferred way ? thanks if replace motherboard within same family of chipsets (i.e. intel > intel or amd > amd), should okay restarting pc twice. carey frisch Windows 10 Insider Preview  >  Windows 10 Insider Preview General
Read more

Security ID 6281 l3codeca.asm

-
on new windows 2008 r2 terminal server, seeing event id 6281 source microsoft windows security. "code integrity determined page hashes of image file not valid. file improperly signed without page hashes or corrupt due unauthorized modification. invalid hashes indicate potential disk device error. file name: \device\harddiskvolume3\windows\system32\l3codeca.acm" http://social.technet.microsoft.com/forums/en-ca/winservergen/thread/009c3e66-f99e-40b6-97ca-05f33ad26239  pointed to  http://msdn.microsoft.com/en-us/windows/hardware/gg487338.aspx which describes vista file dated 2006/08/25. 1 on server dated 2009-07-13. kb891122 lists l3codeeca.acm older version. won't install on w2k8-r2 anyway. i don't want see security errors in event log. ignoring event not solution. there current fix this? thanks, bob. on tue, 21 feb 2012 00:29:04 +0000, bobh2 wrote: gopi, said, ignoring problem not solution. not want see errors in event logs...
Read more