MOVING SSIS PACKAGES FROM ONE PATH TO ANOTHER ONE

hi, does anyone know how can i move a group of ssis packages from the original path into another one in the same server? from ssis services? just like we do it with the windows explorer?

thanks for your help!!!!!!!!!!

May be it’s not the easiest way to do it, but it works for me:

1. Open MS Visual Studio, and create a new Integration Services project if you already don’t have one.

2. In the solution Explorer under SSIS packages - right click on the folder – Add existing packages (add original packages)

3. Right click on the project – Property.Specify the output path for your build.Click on Deployment utility and set “Create DepoloymentUtility” to true.Specify the output Path. Click OK.

4. Right click on the project – Build.The packages with a deployment utility should be under the directory specified in step 3.

5. Copy the entire deployment folder and paste it to the server you want to move the packages to.

6. Log in to the server and navigate to the directory made in step 5.Double click on the xxx.SSISDeploymentManifest file to initiate the deployment wizard.

a. Choose File System Deployment (Next)

b. Choose the new folder where you want your packages to be copied to (Next)

c. Finish the wizard, it should create packages in the new directory

Hope it helps…

|||

thanks it works fine, just for the record, there is another option i've found. using the 'dtutil' tool

there it is an example of it:

dtutil /MOVE SQL;destPackage /SQL srcPackage /SOURCEUSER srcUserName /SOURCEPASSWORD $Hj45jhd@.X /DESTUSER destUserName /DESTPASSWORD !38dsFH@.v||| Looks much cleaner..

moving SQL data and then shrinking file

I have added a new drive to a server and want to move one of the databases to
this drive to alleviate space problems on the original drive. I wanted to do
this with as little downtime to the system as possible and the size of the
original database file is almost 100 GB. I created a second file (NDF) on
the new drive. I think did a shrinkfile to empty the original mdf file. It
appears that most of the data has been moved, but I cannot reduce the size of
the mdf file even though it says it is only using 5 GB of the 100 GB. I
would rather copy a 5 GB file rather than a 100 GB file. Can you reduce the
size of a mdf file?
Thanks.
Danne
> Can you reduce the
> size of a mdf file?
Yes. You might need to do a few SHRINKFILEs, and make sure you don't specify the NOTRUNCATE option.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Danne" <Danne@.discussions.microsoft.com> wrote in message
news:84C00DB8-5491-405C-B9EA-72D2D9521D2B@.microsoft.com...
>I have added a new drive to a server and want to move one of the databases to
> this drive to alleviate space problems on the original drive. I wanted to do
> this with as little downtime to the system as possible and the size of the
> original database file is almost 100 GB. I created a second file (NDF) on
> the new drive. I think did a shrinkfile to empty the original mdf file. It
> appears that most of the data has been moved, but I cannot reduce the size of
> the mdf file even though it says it is only using 5 GB of the 100 GB. I
> would rather copy a 5 GB file rather than a 100 GB file. Can you reduce the
> size of a mdf file?
> Thanks.
> --
> Danne

moving SQL data and then shrinking file

I have added a new drive to a server and want to move one of the databases to
this drive to alleviate space problems on the original drive. I wanted to do
this with as little downtime to the system as possible and the size of the
original database file is almost 100 GB. I created a second file (NDF) on
the new drive. I think did a shrinkfile to empty the original mdf file. It
appears that most of the data has been moved, but I cannot reduce the size of
the mdf file even though it says it is only using 5 GB of the 100 GB. I
would rather copy a 5 GB file rather than a 100 GB file. Can you reduce the
size of a mdf file?
Thanks.
--
Danne> Can you reduce the
> size of a mdf file?
Yes. You might need to do a few SHRINKFILEs, and make sure you don't specify the NOTRUNCATE option.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Danne" <Danne@.discussions.microsoft.com> wrote in message
news:84C00DB8-5491-405C-B9EA-72D2D9521D2B@.microsoft.com...
>I have added a new drive to a server and want to move one of the databases to
> this drive to alleviate space problems on the original drive. I wanted to do
> this with as little downtime to the system as possible and the size of the
> original database file is almost 100 GB. I created a second file (NDF) on
> the new drive. I think did a shrinkfile to empty the original mdf file. It
> appears that most of the data has been moved, but I cannot reduce the size of
> the mdf file even though it says it is only using 5 GB of the 100 GB. I
> would rather copy a 5 GB file rather than a 100 GB file. Can you reduce the
> size of a mdf file?
> Thanks.
> --
> Danne

moving SQL data and then shrinking file

I have added a new drive to a server and want to move one of the databases t
o
this drive to alleviate space problems on the original drive. I wanted to d
o
this with as little downtime to the system as possible and the size of the
original database file is almost 100 GB. I created a second file (NDF) on
the new drive. I think did a shrinkfile to empty the original mdf file. It
appears that most of the data has been moved, but I cannot reduce the size o
f
the mdf file even though it says it is only using 5 GB of the 100 GB. I
would rather copy a 5 GB file rather than a 100 GB file. Can you reduce the
size of a mdf file?
Thanks.
--
Danne> Can you reduce the
> size of a mdf file?
Yes. You might need to do a few SHRINKFILEs, and make sure you don't specify
the NOTRUNCATE option.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Danne" <Danne@.discussions.microsoft.com> wrote in message
news:84C00DB8-5491-405C-B9EA-72D2D9521D2B@.microsoft.com...
>I have added a new drive to a server and want to move one of the databases
to
> this drive to alleviate space problems on the original drive. I wanted to
do
> this with as little downtime to the system as possible and the size of the
> original database file is almost 100 GB. I created a second file (NDF) on
> the new drive. I think did a shrinkfile to empty the original mdf file.
It
> appears that most of the data has been moved, but I cannot reduce the size
of
> the mdf file even though it says it is only using 5 GB of the 100 GB. I
> would rather copy a 5 GB file rather than a 100 GB file. Can you reduce t
he
> size of a mdf file?
> Thanks.
> --
> Danne