SSIS Packages Execution Errors

k_murli_krishna
k_murli_krishna used Ask the Experts™
on
1) I am trying to migrate data from SQL Server 2000 DB to SQL Server 2005 DB in different windows 2000 server systems using SSIS packages.

2) I followed executing from SSIS method from below link:
http://www.simple-talk.com/sql/sql-server-2005/executing-ssis-packages-/

3) I got the following execution errors. Please try & help me overcome them.
TITLE: Microsoft Visual Studio
------------------------------
Nonfatal errors occurred while saving the package:
Error at Package1: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.

Error at Package1: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.

Error at Execute Package Task: The result of the expression "@[User::PackageToRun]" on property "Connection" cannot be written to the property. The expression was evaluated, but cannot be set on the property.

Error at Execute Package Task: The result of the expression "@[User::PackageToRun]" on property "Connection" cannot be written to the property. The expression was evaluated, but cannot be set on the property.
------------------------------
BUTTONS:
OK
------------------------------

TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:

Error at Package1: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.

Error at Package1: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.

Error at Execute Package Task: The result of the expression "@[User::PackageToRun]" on property "Connection" cannot be written to the property. The expression was evaluated, but cannot be set on the property.

Error at Execute Package Task: The result of the expression "@[User::PackageToRun]" on property "Connection" cannot be written to the property. The expression was evaluated, but cannot be set on the property.

Error at Execute Package Task: The connection is not specified.

Error at Execute Package Task: There were errors during task validation.

 (Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Its much simpler to just restore a SQL2000 backup into a SQL2005 database.

Author

Commented:
Please give what I asked for. Not what is already well known & obvious.
You would be suprised how often posters don't know the obvious. Perhaps you could have worded your reply a little more politely.

Author

Commented:
Sorry, I missed the fact that a fact is known only by a select few.
....hitting 'Unsubscribe'

Author

Commented:
Actually I forgot/skipped mentioning that migration is from OLTP to OLAP design & I forgot that I forgot.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial