Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How Can I Decrypt DTSRUN Parameters


SELF NOTE:
Use DTSRUNDec.exe utilities

Instructions:
put '
sum -r/size 18641/11513 section (from "begin" to "end")
sum -r/size 34729/8334 entire input file




View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Could Someone Decrypt This?
hi all,
i have this password column that i ve no idea how it's been encrypted... i need to come out with encrypt and decrypt function for this string :-
AE435A2BE08D1797362FF3CDD6E541AA6851819C

is it possible to decrypt this when i dont have the password string? if not possible then i will try to get the password string so that any experts here could help me to come out with the encryption and decryption function.

thanks guys

~~~Focus on problem, not solution ¯(º_o)/¯ ~~~

View Replies !   View Related
Decrypt
Hi,
When I run the package it gives the following error warning.
Not sure how and where to fix this.
P.S. The package runs successfully and loads data but not sure why I get this error.
Thanks

Error: 2007-08-29 06:00:13.70
Code: 0xC0016016
Source:
Description: Failed to decrypt protected XML node "DTSassword" 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

View Replies !   View Related
How Can I Decrypt From Oracle ?
Hello.
Sorry for my English.
I have 2 DB from Oracle 9 and 10 that have encrypted files (DES and 3DES) like Output. The problem is that i must take this file, open,read and insert data into SQL Server 2000, make some operation and after Crypt the data and send they to the Oracle system.
Someone can help me, how to do ? In SQL server there's some tool that Uncrypt DES crypted file ?

Any suggest will be appreciated.

Diego
:eek:

View Replies !   View Related
RC4 Encrypt And Decrypt
Hi Guys.


I am looking for TSQL code for RC4 encryption and decryption.

I found VBcode for RC4 encryption, it will take atleast 2 days for me to go thru that and rewrite the whole code in SQL.

If anyone has the code, please provide me.

(I know sql does accept extended ASCII characters)

Thanks
-MAK

View Replies !   View Related
PGP Decrypt In DTS Routine
Does anyone know how to decrypt a PGP encrypted file in a DTS routine?

Thanks.
Danielle

View Replies !   View Related
Encrypt On CLR Decrypt In SQL?


Hi folks,
I'm trying to encrypt a small token of data on my client c# application and have it decrypted by SQL on the server side, the problem is i cannot find articles on the subject. I don;t really want to get involved with certificates but base the system on a simple symmetric key that is shared by both parties.

I'm attempting to use the TRIPLE_DES algorithm on both sides and thus far have used the decryptbypassphrase on the server side with the data encrypted on the client side by .Net with no initialization vector setup.

If anyone can recommend any articles or have example (client and server side) code for this situation it would be greatly appreciated.

Many thanks in advance

Simon

View Replies !   View Related
Failed To Decrypt...Help!
All,

I have a file-deployed set of SSIS packages. Each of the packages is set to EncryptSensitiveWithPassword and I have the same password set on each Package. I run the packages with an account other than the authoring account using DTEXEC and the one package calls the rest of the packages. When I run either through a SQL Agent job, or at the command line, I get the following error: "Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information." I get this error repeatedly.

It is possible that my package is running successfully. However, DTEXEC returns a number other than 0, indicating failure. So, of course regardless of success or not, I need to resolve this error so I can distinguish between real errors and success from the return of DTEXEC. If anyone was any ideas what the problem could be, please let me know.

Thanks

View Replies !   View Related
Encrypt In .net, Decrypt In Sql
Does anyone know what my .net app guys need to share with me if encryption was done in the .net app but decryption needs to occur in certain sql queries? I read about master keys, certificates, symmeteric keys, algorithms etc but dont know how that stuff would carryover from the framework into sql. All I know is that the algorithm is AES_256,they must be adding authentication to the encryption and i know the hash algorithm, and symmetric keys are involved. Will they be sharing certain kinds of files with me that need to be registered in the db? Will I have to use CLR if I want the two worlds to come together?

View Replies !   View Related
Encrypt/decrypt Data
We like to secure datas.
Only a few people are autorized to read this information, but today, these informations are readable with a simple query with a query analyzer for exemple.

I'd like to encrypt datas with reversible function in one field of a table

Is there a function able to do this kind of work in SQLServer V7 or 2000 ?

View Replies !   View Related
How To Decrypt Encrypted Procedure
How to decrypt encrypted procedure?Any help is thankful.

View Replies !   View Related
Encrypt/decrypt MS SQL 2005
hi guyz!! is it posible to ecnrypt data everytime i insert it to a table and decrypt it everytime I select it using the MS SQL 2005 alone?

like for example i have this query statement below

insert username,password users values ('daimous','my_password')

what i want is every time i insert a value to the password column that value should be encrypted first.


select username,password from users

everytime i select the value of the password column should decrypted.
Thanks in advance!!!

View Replies !   View Related
How To Decrypt Encrypted UDF In SQL 2000
How to decrypt encrypted UDF in SQL 2000
can any body help me?

View Replies !   View Related
Decrypt Stored Procedures
does anyone know how to decrypt an encrypted stored procedure???


regards,
resh

View Replies !   View Related
Decrypt Stored Procedures
Has anyone heard of a way to decrypt encrypted stored procedures in SQL 7.0 or 2000? The sp_decrypt_object procedure worked pretty well in 6.5 but not in 7.0.

Thanks.

View Replies !   View Related
Encrypt -> Decrypt Into SQL Server
Hi,
Please help!!!!!!!
Is there are ways to encrypt data in the table (SQL Server 7) and then retrieve (decrypt) this information?

Thanks

View Replies !   View Related
How To Encrypt And Decrypt My Password
hi,
in my login form i have the password field.so i am sending password to my database table but while sending password has to be encrypted and while returning it has to be decrypted,is it possible to do in database if means please show me some example please

View Replies !   View Related
Decrypt Sql Server 2005 Sp
hi,

how can i decrypt a stored procedure in sql server 2005?
THX

View Replies !   View Related
How To Decrypt An Excel File Within DTS
Hello everyone,

As the tittle says, I'd like to know if there's a way to decript an excel file from DTS and then save this change in order to manipulate the data inside it. If the file is protected, and you try to make a query over some sheet, you'll have an Exception saying that the file couldn't be deciphered.

Any suggestion?

regards

View Replies !   View Related
Db_datareaders Can Decrypt Data?
Hi... I want to encrypt data using a symmetric key + certificate, but it appears anyone with simply "db_datareader" can view the decrypted data?Is this correct?

Recreation steps:

1. As a System Admin, log into a SQL 2005 Database Engine.
2. Create some login that you also have access to. Ensure it does not already exist, or inherit any permissions from some existing NT-group. (From here on out, I will refer to it as the "underpriveleged user".)
3. Create a new database of any name.
4. Run the following query against the database:

CREATE TABLE [dbo].[MyTable](
[MyColumn] [varbinary](50) NULL
) ON [PRIMARY]
GO
CREATE USER [DOMAINUserName]
FOR LOGIN [DOMAINUserName] WITH DEFAULT_SCHEMA=[dbo]
sp_addrolemember 'db_owner', 'DOMAINUserName'

5. Now open another SSMS and connect as that underpriveleged user.
6. Change the database to the name you provided in Step 3.
7. Run these commands as the underpriveleged user...

CREATE MASTER KEY ENCRYPTION BY PASSWORD='DbMK_pwd'

CREATE CERTIFICATE MyCertificate WITH SUBJECT='Some Text'
CREATE SYMMETRIC KEY MyKeyName
WITH ALGORITHM = DESX
ENCRYPTION BY CERTIFICATE MyCertificate

OPEN SYMMETRIC KEY MyKeyName
DECRYPTION BY CERTIFICATE MyCertificate
INSERT INTO MyTable(MyColumn)
VALUES (EncryptByKey(Key_GUID('MyKeyName'), 'MyValue'))
SELECT Convert(varchar,DecryptByKey(MyColumn)) FROM MyTable
CLOSE SYMMETRIC KEY MyKeyName

8. Now switch back to the System Admin session, and revoke most of the underpriveleged account's permissions...

sp_droprolemember 'db_owner', 'DOMAINUserName'
GRANT SELECT ON dbo.MyTable TO [DOMAINUserName]

9. Switch once again to the underpriveleged session, and run the following:

OPEN SYMMETRIC KEY MyKeyName DECRYPTION BY CERTIFICATE MyCertificate
SELECT *, Convert(varchar,DecryptByKey(MyColumn)) FROM MyTable
CLOSE SYMMETRIC KEY MyKeyName


Why does this work? The user only has select access against the table, and no explicit permissions to the certificate or key. I have even disconnected as this user, tried again, restarted SQL Server... it is still able to decrypt the text.

Or what should I be doing to ensure only those with access to the key/certificate can decrypt the cipher text?

View Replies !   View Related
Is There Any Way To Decrypt The Login Info?
Hi all.

The new feature of login encryption still tortured me and my company's fellow :(

We can't use the server's profile nor server's login audit functionality.
The reason is.. they do not want any additional feature to the server even if it's just a small task.

So..

I know that self signed certi generated whenever the MSSQL server started. My question is..

1. Where is that self-signed certification. Is it loaded to memory or physical hard disk.

2. Is there any special 'store' for this self-signed certification?
I tried to find this certi from all of my store using the certutil.exe but couldn't find this certi.

3. Is there any api that find and decrypt this login info?

Thank you.

View Replies !   View Related
Encrypt/ Decrypt Network Traffic.
I can sucessfully encrypt/ decrypt 1 column, but Im under the impression there is also a way to encrypt the data being sent over the network by using a certificate? I can find lots of info, but no starting point or clear cut instructions. Could someone please assist?

TIA, cfr

View Replies !   View Related
Decrypt Sproc Returning NULL To Non DBO.
I'm still having issues with this despite my attempts to resolve. I even
have "with exec as dbo" in my sproc, and and "exec as dbo" in my execution,
but still the encrypted data returns nulls when I exec as a user other than
DBO. Below is precisely what I have done. All ideas are welcomed.

TIA, ChrisR


--If there is no master key, create one now

IF NOT EXISTS
(SELECT * FROM sys.symmetric_keys WHERE symmetric_key_id = 101)
CREATE MASTER KEY ENCRYPTION BY
PASSWORD =
'23987hxJKL95QYV4369#ghf0%94467GRdkjuw54ie5y01478d Dkjdahflkujaslekjg5k3fd117
r$$#1946kcj$n44ncjhdlj'
GO

CREATE CERTIFICATE HumanResources037
WITH SUBJECT = 'Employee Social Security Numbers';
GO

CREATE SYMMETRIC KEY SSN_Key_01
WITH ALGORITHM = DES
ENCRYPTION BY CERTIFICATE HumanResources037;
GO

USE [AdventureWorks];
GO

-- Create a column in which to store the encrypted data
ALTER TABLE HumanResources.Employee
ADD EncryptedNationalIDNumber varbinary(128);
GO

-- Open the symmetric key with which to encrypt the data
OPEN SYMMETRIC KEY SSN_Key_01
DECRYPTION BY CERTIFICATE HumanResources037;

-- Encrypt the value in column NationalIDNumber with symmetric
-- key SSN_Key_01. Save the result in column EncryptedNationalIDNumber.
UPDATE HumanResources.Employee
SET EncryptedNationalIDNumber = EncryptByKey(Key_GUID('SSN_Key_01'),
NationalIDNumber);
GO

-- Verify the encryption.
-- First, open the symmetric key with which to decrypt the data
OPEN SYMMETRIC KEY SSN_Key_01
DECRYPTION BY CERTIFICATE HumanResources037;
GO

-- Now list the original ID, the encrypted ID, and the
-- decrypted ciphertext. If the decryption worked, the original
-- and the decrypted ID will match.

alter procedure getDecryptedIDNumber
with exec as owner
as
SELECT NationalIDNumber, EncryptedNationalIDNumber
AS "Encrypted ID Number",
CONVERT(nvarchar, DecryptByKey(EncryptedNationalIDNumber))
AS "Decrypted ID Number"
FROM HumanResources.Employee;
GO

/*works for me, shows the decrypted data*/

exec getDecryptedIDNumber

USE [master]
GO

CREATE LOGIN [test] WITH PASSWORD=N'test',
DEFAULT_DATABASE=[AdventureWorks], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

USE [AdventureWorks]
GO

CREATE USER [test] FOR LOGIN [test]
GO

use [AdventureWorks]
GO

GRANT EXECUTE ON [dbo].[getDecryptedIDNumber] TO [test]
GO

GRANT IMPERSONATE ON USER:: dbo TO test;
GO

/*Now, open up a "file/new/DB Engine Query" and login with the test login*/
exec as user = 'dbo'
exec getDecryptedIDNumber

/*This returns NULL values where it should show the decrypted data*/

View Replies !   View Related
Decrypt Sproc Returning NULL To Non DBO.
I'm still having issues with this despite my attempts to resolve. I even
have "with exec as dbo" in my sproc, and and "exec as dbo" in my execution,
but still the encrypted data returns nulls when I exec as a user other than
DBO. Below is precisely what I have done. All ideas are welcomed.

TIA, ChrisR


--If there is no master key, create one now
IF NOT EXISTS
(SELECT * FROM sys.symmetric_keys WHERE symmetric_key_id = 101)
CREATE MASTER KEY ENCRYPTION BY
PASSWORD =
'23987hxJKL95QYV4369#ghf0%94467GRdkjuw54ie5y01478d Dkjdahflkujaslekjg5k3fd117
r$$#1946kcj$n44ncjhdlj'
GO

CREATE CERTIFICATE HumanResources037
WITH SUBJECT = 'Employee Social Security Numbers';
GO

CREATE SYMMETRIC KEY SSN_Key_01
WITH ALGORITHM = DES
ENCRYPTION BY CERTIFICATE HumanResources037;
GO

USE [AdventureWorks];
GO

-- Create a column in which to store the encrypted data

ALTER TABLE HumanResources.Employee
ADD EncryptedNationalIDNumber varbinary(128);
GO

-- Open the symmetric key with which to encrypt the data
OPEN SYMMETRIC KEY SSN_Key_01
DECRYPTION BY CERTIFICATE HumanResources037;

-- Encrypt the value in column NationalIDNumber with symmetric
-- key SSN_Key_01. Save the result in column EncryptedNationalIDNumber.

UPDATE HumanResources.Employee
SET EncryptedNationalIDNumber = EncryptByKey(Key_GUID('SSN_Key_01'),
NationalIDNumber);
GO

-- Verify the encryption.
-- First, open the symmetric key with which to decrypt the data

OPEN SYMMETRIC KEY SSN_Key_01
DECRYPTION BY CERTIFICATE HumanResources037;
GO

-- Now list the original ID, the encrypted ID, and the
-- decrypted ciphertext. If the decryption worked, the original
-- and the decrypted ID will match.

alter procedure getDecryptedIDNumber
with exec as owner
as
SELECT NationalIDNumber, EncryptedNationalIDNumber
AS "Encrypted ID Number",
CONVERT(nvarchar, DecryptByKey(EncryptedNationalIDNumber))
AS "Decrypted ID Number"
FROM HumanResources.Employee;
GO

/*works for me, shows the decrypted data*/
exec getDecryptedIDNumber

USE [master]
GO

CREATE LOGIN [test] WITH PASSWORD=N'test',
DEFAULT_DATABASE=[AdventureWorks], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

USE [AdventureWorks]
GO

CREATE USER [test] FOR LOGIN [test]
GO

use [AdventureWorks]
GO

GRANT EXECUTE ON [dbo].[getDecryptedIDNumber] TO [test]
GO

GRANT IMPERSONATE ON USER:: dbo TO test;
GO

/*Now, open up a "file/new/DB Engine Query" and login with the test login*/

exec as user = 'dbo'
exec getDecryptedIDNumber

/*This returns NULL values where it should show the decrypted data*/

View Replies !   View Related
Failed To Decrypt Protected XML Node
Hi

I have a package that runs fine however it keeps giving me this message below. Now from a previous post it mentionsit is to do with the EncriptedSensitiveWithUserKey what would be the suggestion to run it as Don't save sensitive perhaps?




Executed as user: SEA-SRV-00009SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:07:29 PM Error: 2007-12-05 22:07:29.78 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" 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 DTExec: The package execution returned DTSER_SUCCESS (0). Started: 10:07:29 PM Finished: 10:07:33 PM Elapsed: 4.188 seconds. The package executed successfully. The step succeeded.

View Replies !   View Related
Failed To Decrypt Protected XML Node
Hi,

I,ve been searching the forum for answers to this error but with no luck:

Failed to decrypt protected XML node "DTSassword" with error 0x80070002 "The system cannot find the file specified.". 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.


Setup:
I'm running the packages from the SQL Job Agent - the packages are stored in the file system. The agent is using a proxy account to get the right permissions. I know this because the job has run for severel weeks without errors. The package is calling other packages and is using configuration files. It was actually more than on job that failed (with the same error) - but not all the jobs.

Now it is saying that it can not "find the file specified" - what file would that be? - I'm wondering if it is a package file or a configuration file or maybe another file. It dosn't give me any other information to where the problem is.

Any help is appreciated!

Regards
Simon

View Replies !   View Related
Failed To Decrypt Protected XML Node ...


Hi All,

I am trying to run a job and when I run it I get the following error:

Description: Failed to decrypt protected XML node "PackagePassword" 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: 2008-05-06 09:37:58.32 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "SQLPassword" 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.


I'm not sure what it means or why it is happening.

Any help would be appreciated.

Thank you.

View Replies !   View Related
Use SQL2005 To Decrypt EncryptedData XML Created In .Net
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=384472&SiteID=1
I suppose that some of the answer to my question may be found in that topic, but I haven't made much progress.
I have a text field in a SQL 2000 database that contains the text output (EncryptedData) from the EncryptedXML.Encrypt(xmlDoc.DocumentElement,certificate)method in .Net 2.0 (C#). The data looks something like this:

<?xml version="1.0" encoding="utf-8"?>

<EncryptedData Type="http://www.w3.org/2001/04/xmlenc#Element" xmlns="http://www.w3.org/2001/04/xmlenc#">

<EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#aes256-cbc" />

<KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#">

<EncryptedKey xmlns="http://www.w3.org/2001/04/xmlenc#">

<EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#rsa-1_5" />

<KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#">

<X509Data>

<X509Certificate>[A Bunch of jumbled characters]</X509Certificate>

</X509Data>

</KeyInfo>

<CipherData>

<CipherValue>[A Bunch of jumbled characters]</CipherValue>

</CipherData>

</EncryptedKey>

</KeyInfo>

<CipherData>

<CipherValue>[A Bunch of jumbled characters]</CipherValue>

</CipherData>

</EncryptedData>

I have since imported the Public and Private key from the .Net app into SQL Server. I can use the EncryptByCert and DecryptByCert functions to verify that the key pair is compatible. However, I can't figure out how to apply them to the encryptedXML that my friendly .Net developers are dumping in the DB. Whenever I use the DecryptByCert function on any of the "[A Bunch of jumbled characters]" strings I just get NULL.
Does anybody have some insight?



View Replies !   View Related
How To Encrypt And Decrypt Stored Procedures?
I encrypt my procedures using with encryption clause, but I do not how to decrypt again.

Is there a command or utility for encrypt and decrypt in Sql 2000? How about Sql 2005?

Thanks

Haydee

View Replies !   View Related
Users For Encrypt And Decrypt Purposes Only
Hi there,

Using symmetric keys and certificates in SQL2005, can one assign users permission to only decrypt or encrypt data?

Reason would be say data capturer and data reader type roles. I tried to create some with the GRANT CONTROL and GRANT VIEW for certificates and definitions on Symmetric keys, but havent been to successfull.

Would be great if someone here can offer some advise on it, and if it's possible using SQL rights.

thanks

View Replies !   View Related
How To Decrypt The SQL Encrypted Stored Procedure In ASP.NET (i.e.vb Code)
How to Decrypt the SQL Encrypted Stored procedure in ASP.NET (i.e.vb code)Pls let me know ASAP.Thanks.

View Replies !   View Related
Decrypt Sql Server 2005 Stored Procedure
hi,

how can i decrypt a stored procedure in sql server 2005?

i tried to use this article http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngWId=5
but all what it does is to delete the encrypted stored procedure.

THX




View Replies !   View Related
SQL Server Encrypt/Decrypt With Key Management With PCI Compliance
Hi,
We are going to implement our new applications with .net on MS sql and we have to make sure that SQL Server satisfies PCI Compliance,were concerned with the following items from the PCI Standards Guide.
Could you please guide me that SQL Server 2005 satisfy this kind of functionality?
I am new for SQL server 2005 and i would like to make sure before we move into Microsoft platform and as i am heavily oracle guy.


PCI Standards Guide lines

==>3.6.4 Periodic changing of keys

As deemed necessary and recommended by the associated application (for example,

re-keying); preferably automatically

At least annually.

3.6.5 Destruction of old keys

3.6.6 Split knowledge and establishment of dual control of keys (so that it requires two or three

people, each knowing only their part of the key, to reconstruct the whole key)

3.6.7 Prevention of unauthorized substitution of keys


Thanks for your help and guidelines!
Pora

View Replies !   View Related
Is It Wise To Decrypt Stored Procedures In SQL Server?
Hi All,

I'm new to SQL Server 2005 encryption security. I developed a simple login form using .NET 2 framework. I'm encrypting the user's password on the execution of the INSERT statement using SQL Server EncryptByCert(Cert_ID('abc'),'password').

My only concern is that of decrypting the password on the execution of the SELECT dtatement in a stored procedure using the DecryptByCert(Cert_ID('abc'),val,N' certificate password'). Anyone who has rights on executing that particular stored procedure in SQL Server can easily return the user's password.

Can I still use the SQL encryption, whilst the login application handles the decryption (meaning I embed the DecryptByCert in the application ).

If anyone has other ways of implementing this please forward them? (I preferable would like to store all the certificates, private keys, etc on the database side )



Thanks,

Matt

View Replies !   View Related
Encrypt And Decrypt Text Format Data
Hi,

We have migrated a CRM Database from SQLServer 2000 to SQLServer 2005.



Database contains very sensitive data aboutcustomer in text format (Datatype varchar(20))how can i encrypt the same without any change in the table design.



Regards
Sufian




View Replies !   View Related
Error - The Report Server Cannot Decrypt The Symmetric Key?
SSRS had been working fine on my comp till the time i insatlled VS 2005. I have started getting following error since VS2005 install

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

Why does this error croppedand how can i fix it? I am using SQL Server 2000.

Thanks



View Replies !   View Related
Decrypt Credit Card Number For Reporting Services Report
Hi,A co-worker is creating a vb.net web application which uses theCryptKeeper.dll to encrypt credit card numbers into a sql database.It is my job to pull these encrypted numbers and use the decryptmethod of this dll to show the credit card numbers on a ReportingServices report. I'm not even sure where this should be done. In thesql stored procedure or in the report itself? Any help would begreatly appreciated.Thanks in advance,Amy Bolden

View Replies !   View Related
About Dtsrun
when I run the following in sql Analyzer :dtsrun /S"Local" /Ntestemail /UExternalRO /P"changmail"got this error:Server: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near '/'.Is the command right?And how to run this dts package in commandline?Thanks

View Replies !   View Related
Need Dtsrun Help
I am trying to run two dts jobs using a batch file obviously using dtsrun but im having trouble. I've never attempted this before and it looked easy but not as easy as I thought.

I have two dts jobs, call them package1 and package2. I also saved these as .dts files. I made a .bat file and put it in the same location as the .dts files.

My batch file looks like this:


dtsrun /F package1
dtsrun /F package2
pause


This does not work and I get the following:

C:WINDOWS>dtsrun /F package1
DTSRun: Loading...

Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 704

Can anyone help and tell me what I am doing wrong?

Thanks

Neil.

View Replies !   View Related
Dtsrun
Hi,

Question with DTSRUN
1) I have a batch file which runs a DTS package. Problem is after completion of the package the control doesn't return to command prompt. Any idea how to tackle this.

2) Even on the same server /U /P doesn't work. It errs out saying password is incorrect, Although I can connect to ISQL with same credentials.

Need to fix this asap.

Thanks,

View Replies !   View Related
DTSRUN
We need to schedule a dtsrun batch to run on several servers at the same time. Can
someone tell me how to write this in my command prompt so it will run remotely.

We tried to run it locally but it does not work.

Thanks,
Dianne

View Replies !   View Related
DTSRUN......
What is the minimum SQL install required for dtsrun? Can I get away with copying a few files and not installing SQL.

Basically, the central SQL database has a DTS package which I need to enable a number of users to run. What I do not want to do is have to install SQL Server on all the end users computers.

ANy advice would be greatly appreciated.

View Replies !   View Related
DTSRUN
Hello all,
I am trying to run a DTS package from a .DAT file and in my file this is my code:

DTSRun /S ServerName /E /N "Promo Point Adjust - Import promo file"/
But when I run that the data in the table is not being updated. my question is
-how to I step through the to see what the disconnect is?
-Or if there is an error that is happening but being displayied?

Can anyone help me

View Replies !   View Related
DTSRun Utility Won't
I have been successful at setting up three or four DTS packages to runusing the DTSrun command line utility and the Windows scheduler untilnow. The latest package gives me the following error no matter what Itry.Error: -2147217355 (80041035); Provider Error: 0 (0)Error string: General error -2147217355 (80041035).Error source: Microsoft Data Transformation Services (DTS) PackageHelp file: sqldts80.hlpHelp context: 705I googled the error but got only two hits, only one of which actuallydiscussed the error. That one talked about the security and ID contextof the system agent but I can't even run the package from the commandline, never mind using the Windows chron. The DTS command line I'musing looks like this:DTSRun /S MyServerInstance /R DBName /N MyDTSPacakgeName /EVariations included /U MyUserName /P MyPassWord and a couple others.Next step would have been to use /!Y and /!C to create an encoded batchfile to use for the Windows scheduler.Any help would be most appreciated.Randy

View Replies !   View Related
Using OSQL And DTSRUN
I have a question. I am doing some work for someone and I have a batchfile that they can run that will execute an OSQL line and a DTSRUNline. In both lines I run them using the /S /U /P switches and ofcourse the /N or /i switch to tell it what to run. I have also triedreplacing the /U /P switches with the /E switch.My problem is that as long as I specify the users password on the OSQLline (either with /U & /P or with /E & /P) it will run. If I try andjust use the /E it will say password failed for DOMAIN/USER . Ok, Idon't really care I can specify the password and the script will run.However no matter what I do the DTSRUN line will not run, it gives methis same password error.I can run this line just fine on my PC on my network and my domainusing just the /S /E switches.Any ideas as to why it will work for OSQL but not DTSRUN?Thanks in advance.

View Replies !   View Related
DTSRUN Privileges?
I am trying to get a DTS package to be run from the command line withthe dtsrun utility. The DTS package is stored in the database. The userI supply is a user in the database. I get an error stating "SQL Serverdoes not exist or access denied." It looks to me like the SQL Serverinstance does exist because it tries to start the package. I get"DTSRun: Executing". If I put in a server that is non-existent, I do notget that message. I also know that my username and password are correct.Here is output from my attempt to run dtsrun for my DTS pkg (server,user, password change to protect my db security):C:>dtsrun /Sserver_name /Uuser /Ppass /Npkg_nameDTSRun: Loading...DTSRun: Executing...DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005)Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Serverdoes not exist or access denied.Error source: Microsoft OLE DB Provider for SQL ServerHelp file:Help context: 0Error Detail Records:Error: -2147467259 (80004005); Provider Error: 17 (11)Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Serverdoes not exist or access denied.Error source: Microsoft OLE DB Provider for SQL ServerHelp file:Help context: 0DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1DTSRun: Package execution complete.I suspect that my user I am connecting to the database with does nothave privileges to execute the DTS package. I cannot determine, fromBOL, what privs I need to grant to this user to let them execute thispackage. Any ideas?TIA,Brian--================================================== =================Brian PeaslandJoin Bytes!http://www.peasland.netRemove the "nospam." from the email address to email me."I can give it to you cheap, quick, and good.Now pick two out of the three" - Unknown

View Replies !   View Related
DTSRun Encrypted
In a Multi Server Job under SQL Server Agent (MSX), we have a series ofsteps like:DTSRun /~Z0x8E8635E6BBA...The ~Z means it's an encrypted hexidecimal string. The person who createdthis step is no longer accessible, and the string can't be triviallydecrypted, so I don't know what this runs.Someone once mentioned that I could go to Query Analyzer, run it, andwatch the execution plan. However, if I start the job, the executionplan simply walks through the steps required to find the job, and doesn'tgo into the details of the job. I don't know how to run the DTSRuncommand directly within Query Analyzer.Is there a way I can use the execution plan to determine what package thisDTSRun line is executing? Please give me the appropriate command orcommands.-Adam

View Replies !   View Related
DTSRUN /A Issue
Hi,
I have a DTS named "Rahul_Test" where i have a global variale named "Rahul" INteher (1 Byte). N trying to assign this variable from SQL statement. Here is the syntax that I am writing.

exec master..xp_cmdshell 'DTSRUN -E -S142.102.27.222 -Usa -Psa -N"Rahul_Test" -ARahul:8="aaa"'


After executing the syntax I am getting the following message...

DTSRun: Loading...
DTSRun: Executing...
DTSRun: Package execution complete.
NULL



But the global variable "Rahul" doesnot get changed to 225.

Kindly help me out in this regard.

Thanks in advance.

Rahul Jha

View Replies !   View Related
DTSRUN /A Issue
Hi,
I have a DTS named "Rahul_Test" where i have a global variale named "Rahul" INteher (1 Byte). N trying to assign this variable from SQL statement. Here is the syntax that I am writing.

exec master..xp_cmdshell 'DTSRUN -E -S142.102.27.222 -Usa -Psa -N"Rahul_Test" -ARahul:8="aaa"'


After executing the syntax I am getting the following message...

DTSRun: Loading...
DTSRun: Executing...
DTSRun: Package execution complete.
NULL



But the global variable "Rahul" doesnot get changed to 225.

Kindly help me out in this regard.

Thanks in advance.

Rahul Jha

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved