Re: Migrating DTS to Integration Services
- From: "Joe" <taposh.dr@xxxxxxxxx>
- Date: 9 Nov 2006 15:53:38 -0800
Hi Charles:
I am trying to create a SSIS package to transfer MSDB and Master from
my production to my backup. However Master goes fine. MSDB I am having
errors with certain Stored Procs.
On google search I found one place where a person said that SSIS has
issues with Stored Procs using variables in subqueries. I see that I
have some stored procs with that same thing i.e variables in subqueries
and they get transferred. Also, the work around of using
a SSIS variable is not easy as when I am transfering 2 dbs.
Any help will be appreciated.
T
Charles Wang[MSFT] wrote:
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.
======================================================
.
- Prev by Date: Re: Unable to open Step output file. The step failed.
- Next by Date: RE: The task ... cannot run on this edition of integration services. It requires a higher level edition.
- Previous by thread: Re: Unable to open Step output file. The step failed.
- Next by thread: saving to sql server failed no description found
- Index(es):
Relevant Pages
|
