Ms Sql Server Technology Discussions

[gundugadu]

[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

[Desamudhuru]

[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]
baa try chesanu solution em dorakaledu

[Desamudhuru]

[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.

[JUJUBI_JULABI]

[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 ..

[Darling999]

[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

[ChampakDas]

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]

[deals2buy]

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

[Desamudhuru]

[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 ??

[deals2buy]

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


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

[deals2buy]

[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/

[deals2buy]

[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.

[deals2buy]

[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]

[ravi87]

[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....

[Nikkar Narayana]

[img]http://gifsoup.com/view3/4326507/jaffas2-o.gif[/img]

[ravi87]

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


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