December 9, 2007 at 10:17 am
Hi everyone,
I am running Win 2003 Ent. and SQL 2005 Ent. SP2.
I used Management Studio to copy a database from one server to another. It created a DTS package, which I can see when I log in to Integration Services through MS. However, when I right click on the name of the package, I don't see an export option. I am a member of the sysadmin group. Any idea why the option is not there and how to fix it? Thanks in advance for your help.
December 9, 2007 at 11:37 am
Or if there is a way to get the package into the Business Intelligence Development Studio application, please let me know. I'm supposed to finish this project today, and I've been stuck at this step since last night. BOL and google were of no help...I couldn't find another thread about this issue. Thanks again.
December 10, 2007 at 9:23 am
I'm assuming you're referencing a SSIS package (not a DTS package, which is SQL 2000).
Create a new SSIS solution via BIDS.
On the project, Right-Click, Add/Existing Package.
Then you should be able to navigate to your package and bring it in.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply