How modify package 2008 R2

Hi

I am in the process of migrating from MS SQL 2000 to MS SQL 2008 R2 at DASP.

How can I Modify/Change/Fix a package I created, on my local computer, with the Import data wizard ? I can not find a place to load and modify a existing package. The package I created has a problem that I would like to fix rather than go through the Import data wizard again.

Thanks in advance
albanello

 

dmitri

Sorry

I don't work with this all the time, my only experiance is school/this web Site/ and what I read on the web.

I don't know what else to call it. In SQL 2008 R2. The Import/Export Wizard, on its opening screen, talks about creating a simple "Package". In SQL 2000 I believe they are called "Data Transfomation Services".

I am tring to update my local server with tables that are on my server at DASP. I use to do this with DTS when I was using SQL 2000. As I understand it SQL 2008 R2 does not support DTS. With SQL 2008 R2 I have to create new "packages" using the "Import/Export wizard"

Hope this clarifies what I am doing

Thanks
albanello

 

What package you are referring to?

 

Wendell2012

I'm sorry, I don't understand your question. My previous post to "dmitri" explains what I am calling a "Package", as best I can. Go into MS SQL 2008 R2's Import/Export Wizard and the opening screen talks about the wizard creating a simple "Package" to Import and Export data.

Sorry
Thanks for your responce
albanello

 

Hope this helps somebody

I answered my own question and this is for someone else who may have the same problem.

Import package created with Import/Export Wizard so package can be changed/fixed/modified.

1) Start->Microsoft SQL Server 2008 R2->SQL Server Business Intelligence Developer Studio
2) Open [Your BI Project]
3) Go to->Project->Add Existing Package
4) Package location: SSIS Package Store
5) Server: [Your Server]
6) Package path: Browse to->SSIS Packages->MSDB-> [Select the package you want to change/fix/modify]
7) Go to->Solution Explorer->[Double Click the package you want to change/fix/modify]
8) After changed/fixed/modified debug. Log into [Your] Server "Integration Services"
9) Go to->Object Explorer->Stored Packages->Right Click->MSDB->Import Package
10) Package Location: File System
11) Package Path: Browse to->Visual Studio 2008->Projects->[Your VS 2008 Project]->Select Package You want to import

This worked for me. You may have different paths but the idea is still, Import existing Package to BI, change/fix/modify debug
then Import the package back to [Your Server]

Hope it works for you
albanello