Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2008-05-28 : 00:42:01
|
| Hi pals,We have developed few SSIS Packages at client environment using BIDS tool.We normally connect to the client environment using a VPN.To replicate the work at our local end, we copied the XML Config files and SSIS packages to our local end. At local end , we changed the connection manager information in xml files and tried to open the package in the BIDS. While opening we are encountering the below error msg."There were errors while the package was being loaded The package might be corrupted. See the Error List for details "What could be the reason for this?If i want to replicate the same work at different environments what need to be done.Any suggestions would be greatly appreciated.Thanks in advance. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-05-28 : 09:12:44
|
| Try to generate new ID and see if it makes a difference.Package (Control Flow right-click) > Properties > ID > Generate New ID |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2008-05-29 : 00:02:12
|
| Hi Bina, I am new to this SSIS environment. I have question here. How could the generation of new ID help me out? What is this ID all about?Thanks & Regards,franky |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-05-29 : 07:48:03
|
| Let's back up and double-check you config file (xml). This error could be from db connections, file locations, etc but just check. Also, if the package is not too complex maybe it's worth starting from scratch just to see if there's no issue running from local machine. |
|
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2008-05-30 : 05:19:32
|
| Hi Bina,I changed the database connection info and other stuff in my XML config file. But still the same problem persists. It is throwing me the same Package may be corrupted Error.Any suggestions?Thanks and Regards. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-05-30 : 10:11:40
|
| Creating a new package, can you execute it with SQL Task successfully on local machine? If that's successful then add in package configuration. |
|
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2008-06-02 : 07:41:56
|
| I will try this out.Thanks! |
|
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2008-06-04 : 05:49:28
|
| Hi, I changed the Package property with name "ProtectionLevel" to "DontSaveSensitive". Now all packages are working fine.Thanks so much for the help. |
|
|
|
|
|
|
Package Correuption Error!!1