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

x
?
Solved

errors during package opening in BIDS

Posted on 2011-03-15
1
Medium Priority
?
220 Views
Last Modified: 2012-06-27
Hi experts, I have a bunch of errors when trying to open an already existing package. I need to make some modifications on existing package created by someone else, please find attached the errors, please let me know how I can solve them.
ssis-errors.txt
0
Comment
Question by:sqlcurious
1 Comment
 
LVL 15

Accepted Solution

by:
colly92002 earned 2000 total points
ID: 35142968
It looks like there is a password stored in the DataSource of the package (probably a SQL Server login), and that package was probably saved by a user other than yourself.  BIDS doesn't like this and throws errors such as the one you have reported.  This is normal behaviour.

Simply ignore the errors, open the datasource, and see how the connection to the database is configured.  If it is a SQL login, re-enter the password and save the package, and it should be OK.
0

Featured Post

Independent Software Vendors: 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!

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

571 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