I'm developing a data migration betwwen two sql servers.
Due to transform data i'm developing SSIS DTSX to do that.
We're using sql server 2008 R2 in both source and destination data.
To develop we're using BIDS 2008
we're running XP SP3 machines
The fact is that we began to develop in BIDS 2005.
We transalate the packages to BIDS 2008. Everytihing is perfect.
Sundely, when we add more tasks to the packages, the problems began.
* After saving the packages when close the project and reopen the projects what we've done disappeared.
Yes, the task was empty.
* Recreate the task and run but we have the problem of SSIS.Pipeline.
* Lost the login password of sqlconnection datasources.
We've read the post about permissions.
We're administrators of our machines.
The connection to the database is under "sa" user, so more permissions... impossible.
We execute BIDS as Adminstrator but nothing change.
Any help is appreciated. What can I do?
View Complete Post