Did you open the transformation object and update the mappings?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Are there any special mappings in those packages in question or does it do it in all cases? If all then just to be sure create a simple package that...

Yes, sounds right.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Does after this error a blank DTS package come up. Usually you get this kind of error if the DTS package contains links/references to drives and such not the same...

No they can map but you still have to grant access via an NT authenication login account on the other SQL server. Once they have been granted access should work...

Something like this shoulw work

DIM dFillStr, xLoop

FOR xLoop = 1 to 850

dFillStr= dFillStr & " "

NEXT

Once done you will have a variable with 850 whitespaces that you can just plug...

Glad to hear. I should have known this when I first saw as I have this same problem with Novell servers that I have done that way for over 2...

First both the servers have to be on the same domain (unless I missed something) as when the login occurrs it is passed as (AUTHENTICATOR\LOGINNAME) what you want is DOMAINNAME\LOGINNAME...

I'll try to find it but I believe the DTS components for SQL DTS packages are lincensed only with the install of the appropriate SQL version check out http://www.microsoft.com/sql as...

I believe that is because it is trying to find the SQLSERVERAGENT service running. I cannot find any other reasons, I suggest try a reinstall (but I know this is...

Ok I tested until I was blue in the face but here is what you need to do and why.

create function dbo.checkemailunq(

@email varchar(50))

RETURNS bit

AS

BEGIN

declare @unique bit

if (select COUNT(rid) from dbuser...

Try this in QA,

SELECT [Name] FROM msdb..RTblNamedObj WHERE [Name] = 'YourPackageName'

If not found then it did not save properly and I believe you will just have to recreate. Otherwise...

At this point not 100% sure, first is Domain\tankho1 you said it is an Adminstrator, is a member of Domain Admins or just a local adminstrator? If local make a...

That is a very good point to add Robert, I have myself made that mistake many times.

"Don't roll your eyes at me. I will tape them in place." (Teacher on...

I am going to double check tomorrow and in Books On Line there was a statement they couldn't and a statement on how to use them (which keymoo's looks right)...