Solved

SSIS Packages Execution Errors

Posted on 2006-10-22
6
2,258 Views
Last Modified: 2008-01-09
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
Comment
Question by:k_murli_krishna
  • 3
  • 3
6 Comments
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 150 total points
ID: 17785672
Its much simpler to just restore a SQL2000 backup into a SQL2005 database.
0
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 17798417
Please give what I asked for. Not what is already well known & obvious.
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 17801909
You would be suprised how often posters don't know the obvious. Perhaps you could have worded your reply a little more politely.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 17

Author Comment

by:k_murli_krishna
ID: 17806801
Sorry, I missed the fact that a fact is known only by a select few.
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 17807695
....hitting 'Unsubscribe'

0
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 17874540
Actually I forgot/skipped mentioning that migration is from OLTP to OLAP design & I forgot that I forgot.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now