when you defined connection, test connection was succeded with sa account on both servers?

-V

Please verify, In constraint editor, Constraint options, Evaluation operation point to "constraint" and you have selected value as completion. That's all I can think of unless you have more...

If you are not using SP, then just simplu use simple t-sql stetemnts inside execute sql task..

update table1

set col1 = 'data'

Is that what you are trying to do ? If...

Hi,

It may be the options you have selected..try using drop objects first, it should avoid key violation.

What objects you want to move/transfer? There could be issues here from sql...

You have to connect to Integration services. In management studio, connect to server type, Integration services, instead of data base engine this time. Aafter that you can see, running packages...

Hi,

You need to use Data Conversion task in between to convert unicode to non-unicode. Read about data types in SSIS and then use this this task in between to convert...

Hi,

There could be problem with the mapping between sorce to destination, or if source primary key column is an identity column then, you need to select identity insert on in...

Obviously on import export wizard we don't have much control. There are good deployment methods to deploy packages to servers. To answer your question,Since some packages worked for you by...

Then definately as it says it can not find the destination table. Just make sure you are not dropping the table anywhere else. You can also use a data viewer...

Hi,

How did u move the pakage from development to production ? Did u deploy them to production properly ?

-V

Hi,

Thanks for your responses.

I do have sp2 on sql server 2005. But in sql server 2005, it has tables, views with .sql extension. Also, on my machine I unchecked,...

Hi,

I ahd a same problem too..We had a IP switch over and I could not edit them either. So, I created new plans and tried delete old ones, we had...

Thanks for your answer again...I think adding a inline function inside a view sounds great!!!

Thanks again!!

Veena

Actually, I want to create a view first and then I use a stored procedure to update Cleaned_Issuername, by calling a function, which does the clenup for each...

Hi Matt,

Did u try using transfer database objects task in SSIS ???

-V