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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2013-02-08 : 15:59:14
|
| Hi all. This is SSIS 2008I have built a Solution and package.Now I want to clone it to make 5 other packages, similar but will be slightly different.If I simply copy the dtsx file to another folder and open it in Vis Studio, everything appears in the Design window - but I don't have the Debug option.Is there a way to copy a solution into a new path, rename it and modify?Thanks, Jack |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-08 : 23:00:11
|
| you wont get debug option unless you associate dtsx package to a project.So what you need to do is open BIDS, start an integration services project. then click on project and choose add existing item and browse to your packages. Save and packages will be part of new project created and then you'll have debugging option available.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-02-09 : 16:35:43
|
| Thanks very much. This will save me much time! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-11 : 00:24:30
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-02-12 : 16:53:02
|
| visakh16: I tried your suggestion and this is what happened.Now I have the taksks and connections visible.But there are 2 problems:1. Error loading FTPFinancialsGL.dtsx: Failed to decrypt protected XML node "DTS:Property" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. C:\SSIS Packages\FTPFinancialsGL\FTPFinancialsGL\FTPFinancialsGL.dtsx AND 2. Debug tab still has 'Start Debugging' disabledCan you think of any ideas please?Thanks, Jack |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-13 : 04:46:37
|
| whats the protection level used by the package?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-02-14 : 12:25:15
|
| visak,The package properties show that the Protection Level isEncrypt Sensitive With User Key It has an FTP task which requires a password.Thanks, Jack |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-14 : 23:30:23
|
quote:
Originally posted by jbates99
visak,The package properties show that the Protection Level isEncrypt Sensitive With User Key It has an FTP task which requires a password.Thanks, Jack
Is the package created by you? Encrypt Sensitive With User Key setting will allow only person who created the package to have access to sensitive properties which includes FTP password------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Cloning Packages