RE: Migrating DTS to Integration Services



Hi Jerry,
My understanding of your issue is that:
You wanted find some how-to articles on DTS upgrading to SSIS.
Also, you encoutered the error:
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
when you tried to expand the MSDB folder in Stored Packages.
If I have misunderstood, please let me know.

For your first question, I recommend that you refer to this article for
best practice:
SQL Server 2005 Integration Services, Part 1: Lessons from Project REAL
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm
l/SQL05InSrREAL.asp

For your second question, to be honest, I couldn't understand clearly.
Could you please describe your operation more detailed and mail me
(changliw@xxxxxxxxxxxxx) a screenshot for further research?

If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.

Sincerely,
Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================



.



Relevant Pages

  • Re: Protecting database structure
    ... can use the new encryption support that comes out of the box in SQL server ... SQL server will only see encrypted data. ... you could do what SAP and other ERP vendors do: obfuscate the schema ... Microsoft Online Partner Support ...
    (microsoft.public.sqlserver.security)
  • Re: SQL server cannot validate certificate
    ... we have gone through all related articles in KB. ... Has anyone managed to run SQL Server 2000 on Win NT 4.0 ... with the "Force Protocol Encryption" option set? ... How SQL Server Uses a Certificate When the Force ...
    (microsoft.public.sqlserver.security)
  • Re: SQL server cannot validate certificate
    ... we have gone through all related articles in KB. ... Has anyone managed to run SQL Server 2000 on Win NT 4.0 ... with the "Force Protocol Encryption" option set? ... How SQL Server Uses a Certificate When the Force ...
    (microsoft.public.sqlserver.security)
  • Re: Encrypt connection channel
    ... Jasper Smith (SQL Server MVP) ... Encrypt the connection string that is used to make a connection, ... Does ADO.Net and SQL Server support this feature? ... Encryption of sensitive sensitive query data that is exchanged between ...
    (microsoft.public.sqlserver.security)
  • RE: Configuration parameter in SQL database
    ... Welcome to Microsoft Newsgroup Support Service! ... how to store&return the configuration ... SQL Server + SQL Dependency Cache ...
    (microsoft.public.dotnet.general)