Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2364
  • Last Modified:

SSIS Packages Execution Errors

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
------------------------------

0
k_murli_krishna
Asked:
k_murli_krishna
  • 3
  • 3
1 Solution
 
nmcdermaidCommented:
Its much simpler to just restore a SQL2000 backup into a SQL2005 database.
0
 
k_murli_krishnaAuthor Commented:
Please give what I asked for. Not what is already well known & obvious.
0
 
nmcdermaidCommented:
You would be suprised how often posters don't know the obvious. Perhaps you could have worded your reply a little more politely.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now