On which table the SSIS SQL Server logs are stored?
On which table the SSIS SQL Server logs are stored?
I am experiencing an error failed to retrieve data from data base. it is an oracle table. Is there a limit on the number of fields that can be a report. My table has 321 fields and I do not have all of them in the report yet.
Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??
write a database figure to implement the master detained relationship.
definion of tcp
What is live lock, deadlock and what is Lock escalation?
when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.
How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error.
How will you Handle Error in SQL SERVER 2008?
In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?
why we are using shift key in unix shell script
I have table name'temp' in that I wanted to add some partial data for a particular column name 'policyno' where data is existing in that column. Ex.Policyno like 'R-KT-SK- EA-134526' like 100 records. In that 100 records some policynos are just like 134527 I mean with out prefix like'R-KT-SK-EA-' now I wanted add this prefix as 'R-KT-SK- EA-134527' for some 50 records. How can I add partial data?