SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Cloning Packages
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jbates99
Constraint Violating Yak Guru

370 Posts

Posted - 02/08/2013 :  15:59:14  Show Profile  Reply with Quote
Hi all. This is SSIS 2008

I 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

India
52309 Posts

Posted - 02/08/2013 :  23:00:11  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

jbates99
Constraint Violating Yak Guru

370 Posts

Posted - 02/09/2013 :  16:35:43  Show Profile  Reply with Quote
Thanks very much. This will save me much time!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 02/11/2013 :  00:24:30  Show Profile  Reply with Quote
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jbates99
Constraint Violating Yak Guru

370 Posts

Posted - 02/12/2013 :  16:53:02  Show Profile  Reply with Quote
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' disabled

Can you think of any ideas please?
Thanks, Jack
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 02/13/2013 :  04:46:37  Show Profile  Reply with Quote
whats the protection level used by the package?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jbates99
Constraint Violating Yak Guru

370 Posts

Posted - 02/14/2013 :  12:25:15  Show Profile  Reply with Quote
visak,

The package properties show that the Protection Level is

Encrypt Sensitive With User Key
It has an FTP task which requires a password.
Thanks, Jack
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 02/14/2013 :  23:30:23  Show Profile  Reply with Quote
quote:
Originally posted by jbates99

visak,

The package properties show that the Protection Level is

Encrypt 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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000