Jump to content

Ms Sql Server Technology Discussions

9Pardhu

By 9Pardhu
in Old Discussions

 Share

Recommended Posts

gundugadu Hero

gundugadu

Posted
Posted

[quote name='chelsea' timestamp='1349367938' post='1302581448']
hmm avuna ba inka chala mandi vunnari mktr,srivennala abbo pedda list naku sariga teliyadu e thread ni active ga vuchudamu
[/quote]
yendi vay
eee gundugadini marchipoyav
cheppadam
nenu bhi sql developer ne

Link to comment
Share on other sites
  • Replies 1.6k
  • Created
  • Last Reply

Top Posters In This Topic

  • deals2buy

    643

  • Darling999

    178

  • mtkr

    118

  • loveindia

    112

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

loveindia
loveindia

[quote name='calmandquiet' timestamp='1362496130' post='1303368874'] Calling SSAS thopulu [b]AFAIK Facts & Dimensions are base tables and based on those tables you build Cubes[/b] ----what

loveindia
loveindia

[quote name='calmandquiet' timestamp='1362496304' post='1303368889'] SSIS Packages to import data daily from OLTP Applications to data [size=4]warehouse Evvaraina chesara ?????[/size] [/quote] c

deals2buy
deals2buy

nice posts rey loveindia, Littlemoon, DARLING

Desamudhuru Sr. Hero

Desamudhuru

Posted
Posted

[quote name='ravi87' timestamp='1353957594' post='1302855482']
Joblu runuuuu avtledduuu baa sql agent thooo

Message
Executed as user: xxx\sqlserviced. Microsoft ® SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright © Microsoft Corporation 2010. All rights reserved. Started: 11:55:58 AM Error: 2012-11-26 11:55:58.22 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2012-11-26 11:55:58.56 Code: 0xC0202009 Source: Pkg Connection manager "SQLServerConnection" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D


Description: "Login failed for user 'X'.".---> edi main anipistundhi baaaaaa prob


End Error Error: 2012-11-26 11:55:58.56 Code: 0xC020801C Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SQLServerConnection" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2012-11-26 11:55:58.56 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C. End Error Error: 2012-11-26 11:55:58.56 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2012-11-26 11:55:58.56 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:55:58 AM Finished: 11:55:58 AM Elapsed: 0.469 seconds. The package execution failed. The step failed.
[/quote]
sorry baa try chesanu solution em dorakaledu

Link to comment
Share on other sites
Desamudhuru Sr. Hero

Desamudhuru

Posted
Posted

[quote name='gundugadu' timestamp='1353958273' post='1302855647']
yendi vay
eee gundugadini marchipoyav
cheppadam
nenu bhi sql developer ne
[/quote]
two tables loni column names compare cheyali ela ba ?? Script vunte ekada veyagalava ?? Ol try chesa execute avadam ledu task.

Link to comment
Share on other sites
JUJUBI_JULABI Celebrity

JUJUBI_JULABI

Posted
Posted

[quote name='Desamudhuru' timestamp='1353959442' post='1302855978']
two tables loni column names compare cheyali ela ba ?? Script vunte ekada veyagalava ?? Ol try chesa execute avadam ledu task.
[/quote]
t sql la aytey join use cheyy, ssis lo lookup use cheyy .. checksum option kuda consider chesko ..

Link to comment
Share on other sites
Darling999 Celebrity

Darling999

Posted
Posted

[quote name='ravi87' timestamp='1353957594' post='1302855482']
Joblu runuuuu avtledduuu baa sql agent thooo

Message
Executed as user: xxx\sqlserviced. Microsoft ® SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright © Microsoft Corporation 2010. All rights reserved. Started: 11:55:58 AM Error: 2012-11-26 11:55:58.22 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2012-11-26 11:55:58.56 Code: 0xC0202009 Source: Pkg Connection manager "SQLServerConnection" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D


Description: "Login failed for user 'X'.".---> edi main anipistundhi baaaaaa prob


End Error Error: 2012-11-26 11:55:58.56 Code: 0xC020801C Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SQLServerConnection" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2012-11-26 11:55:58.56 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C. End Error Error: 2012-11-26 11:55:58.56 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2012-11-26 11:55:58.56 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:55:58 AM Finished: 11:55:58 AM Elapsed: 0.469 seconds. The package execution failed. The step failed.
[/quote]

ne pkg lo pwd ni hardcode cheyi lekapotey config file okati pass cheyyi id pwd petti scheduling appudu and deploy appudu save with user key ani edo untundi adi select cheyyi.
. or package deply chesey appudu do not save sesitive data ani pettu

ila chestey vastadi

Link to comment
Share on other sites
ChampakDas LEGEND

ChampakDas

Posted
Posted

manu junnu [img]http://www.bewarsetalk.net/discus/movieanimated3/bemmi.lol1.gif[/img]

P.S: sry for posting this useless post in this thread
[quote name='manmadudhu' timestamp='1353683905' post='1302845352']
seyyar vaay
[/quote]
[quote name='9pardhu' timestamp='1353951181' post='1302854646']
changed....
[/quote]

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='9pardhu' timestamp='1353951181' post='1302854646']
changed....
[/quote]
"Microsoft SQL Server Technology - Discusions" ani pettu mama..suddeng ga Ms anesariki ardham kaaledu

Link to comment
Share on other sites
Desamudhuru Sr. Hero

Desamudhuru

Posted
Posted

[quote name='deals2buy' timestamp='1353970914' post='1302857530']
"Microsoft SQL Server Technology - Discusions" ani pettu mama..suddeng ga Ms anesariki ardham kaaledu
[/quote]
Hi enti mrng nundi raledu. Emaindi XOOM di ??

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='Desamudhuru' timestamp='1353971088' post='1302857554']
Hi enti mrng nundi raledu. Emaindi XOOM di ??
[/quote]


office lo vaayinchestunnaru sFun_duh2 aa Xoom kuda inka em telaledu sFun_duh2 deenemma daridram annitlo sFun_duh2

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[b] Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3[/b]


http://blog.sqlauthority.com/2012/11/26/sql-server-sends-backups-to-a-network-folder-ftp-server-dropbox-google-drive-or-amazon-s3/

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[b] Find Weekend and Weekdays from Datetime in SQL Server 2012[/b]


[i][b]“How do we know if today is a weekend or weekday using SQL Server Functions?”[/b][/i]
Well, I assume most of us are using SQL Server 2012 so I will suggest following solution. I am using SQL Server 2012′s CHOOSE function. It is
[color=blue]SELECT [/color][color=magenta]GETDATE[/color][color=gray]() [/color][color=black]Today[/color][color=gray],[/color]
[color=magenta]DATENAME[/color][color=gray]([/color][color=black]dw[/color][color=gray], [/color][color=magenta]GETDATE[/color][color=gray]()) [/color][color=black]DayofWeek[/color][color=gray],[/color]
[color=black]CHOOSE[/color][color=gray]([/color][color=magenta]DATEPART[/color][color=gray]([/color][color=black]dw[/color][color=gray], [/color][color=magenta]GETDATE[/color][color=gray]()), [/color][color=red]'WEEKEND'[/color][color=gray],[/color][color=red]'Weekday'[/color][color=gray],[/color]
[color=red]'Weekday'[/color][color=gray],[/color][color=red]'Weekday'[/color][color=gray],[/color][color=red]'Weekday'[/color][color=gray],[/color][color=red]'Weekday'[/color][color=gray],[/color][color=red]'WEEKEND'[/color][color=gray]) [/color][color=black]WorkDay
GO[/color]
[img]http://www.pinaldave.com/bimg/getdatedisplay2.jpg[/img]
You can use the choose function on table as well. Here is the quick example of the same.
[color=blue]USE [/color][color=black]AdventureWorks2012
GO[/color]
[color=blue]SELECT [/color][color=black]A.ModifiedDate[/color][color=gray],[/color]
[color=magenta]DATENAME[/color][color=gray]([/color][color=black]dw[/color][color=gray], [/color][color=black]A.ModifiedDate[/color][color=gray]) [/color][color=black]DayofWeek[/color][color=gray],[/color]
[color=black]CHOOSE[/color][color=gray]([/color][color=magenta]DATEPART[/color][color=gray]([/color][color=black]dw[/color][color=gray], [/color][color=black]A.ModifiedDate[/color][color=gray]), [/color][color=red]'WEEKEND'[/color][color=gray],[/color][color=red]'Weekday'[/color][color=gray],[/color]
[color=red]'Weekday'[/color][color=gray],[/color][color=red]'Weekday'[/color][color=gray],[/color][color=red]'Weekday'[/color][color=gray],[/color][color=red]'Weekday'[/color][color=gray],[/color][color=red]'WEEKEND'[/color][color=gray]) [/color][color=black]WorkDay[/color]
[color=blue]FROM [/color][color=black][Person].[Address] A
GO[/color]
[img]http://www.pinaldave.com/bimg/getdatedisplay1.jpg[/img]
If you are using an earlier version of the SQL Server you can use a CASE statement instead of CHOOSE function.

Link to comment
Share on other sites
deals2buy Celebrity

deals2buy

Posted
Posted

[b] Auto Generate Script to Delete Deprecated Fields in Current Database[/b]


[color=blue]SELECT [/color][color=red]'ALTER TABLE ['[/color][color=gray]+[/color][color=black]po.name[/color][color=gray]+[/color][color=red]'] DROP CONSTRAINT [' [/color][color=gray]+ [/color][color=black]so.name [/color][color=gray]+ [/color][color=red]']'[/color]
[color=blue]FROM [/color][color=black]sysobjects so[/color]
[color=blue]INNER JOIN [/color][color=black]sysconstraints sc [/color][color=blue]ON [/color][color=black]so.id [/color][color=blue]= [/color][color=black]sc.constid[/color]
[color=blue]INNER JOIN [/color][color=black]syscolumns col [/color][color=blue]ON [/color][color=black]sc.colid [/color][color=blue]= [/color][color=black]col.colid[/color]
[color=gray]AND [/color][color=black]so.parent_obj [/color][color=blue]= [/color][color=black]col.id [/color][color=gray]AND [/color][color=black]col.name [/color][color=gray]LIKE [/color][color=red]'dep[_]%'[/color]
[color=blue]INNER JOIN [/color][color=black]sysobjects po [/color][color=blue]ON [/color][color=black]so.parent_obj [/color][color=blue]= [/color][color=black]po.id[/color]
[color=blue]WHERE [/color][color=black]so.xtype [/color][color=blue]= [/color][color=red]'D'[/color]
[color=blue]ORDER BY [/color][color=black]po.name[/color][color=gray], [/color][color=black]col.name [/color]
[color=blue]SELECT [/color][color=red]'ALTER TABLE ['[/color][color=gray]+[/color][color=black]table_schema[/color][color=gray]+[/color][color=red]'].['[/color][color=gray]+[/color][color=black]Table_name[/color][color=gray]+[/color][color=red]'] DROP COLUMN [' [/color][color=gray]+ [/color][color=black]Column_name [/color][color=gray]+ [/color][color=red]']'[/color]
[color=blue]FROM [/color][color=black]INFORMATION_SCHEMA.COLUMNS[/color]
[color=blue]WHERE [/color][color=black]column_name [/color][color=gray]LIKE [/color][color=red]'dep[_]%'[/color]
[color=blue]ORDER BY [/color][color=black]Table_name[/color][color=gray], [/color][color=black]Column_name[/color]

Link to comment
Share on other sites
ravi87 Jr Artist

ravi87

Posted
Posted

[quote name='DARLING...' timestamp='1353965683' post='1302856878']

ne pkg lo pwd ni hardcode cheyi lekapotey config file okati pass cheyyi id pwd petti scheduling appudu and deploy appudu save with user key ani edo untundi adi select cheyyi.
. or package deply chesey appudu do not save sesitive data ani pettu

ila chestey vastadi
[/quote]


Thanks bro.... i changedddd protectttt levellllll , working fine....

Link to comment
Share on other sites
ravi87 Jr Artist

ravi87

Posted
Posted

[quote name='Desamudhuru' timestamp='1353959373' post='1302855957']
sorry baa try chesanu solution em dorakaledu
[/quote]


try chesavuuu baa.. thanks ... :) finally got it... protect level change cheyali mama ...

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...