Making changes to SSIS packages

Hello,

I created a SSIS project with some SSIS packages within my local machine. Once all development and testing stuff was finished I imported the same to SSIS package store within Integration services. Then I created another test folder within my local machine and copied all the packages along with the project .sln file to that test folder.

Now the problem, If I make any changes to the package within test folder it automatically saves the changes to my other folder. Does anybody have a reason why it is doing so.

Thank You

Jatin

I'm guessing its because the solution still contains a reference to the original .dtsx file.

-Jamie

|||

Jamie,

Thank you, I got the problem.

|||

Yes that would be my thought too.

While in the new/copied solution, click on each package name in the solution explorer and view the 'Full Path' property and verify they are what you think. Another place I have burned myself is copying a solution with parent packages calling children packages....and forgetting to update the connection manager used by the ExecutePackage task to point to the new child rather than the old child...mmm sounds a bit like a soap opera.

hope that helps.

making a local copy

hi I have a SQL DB hosted in a hosting company, I want to create a local copy
in my pc, what is the best way to do it.
I tried to make a backup but it seem that the backup can be done only in the
Hosting machine so I could not do it.
thks
Ken
Your best bet is to have them send you a copy of the latest full backup.
Maybe they have an FTP site where you can access it.
Andrew J. Kelly SQL MVP
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:87AEBE9D-C237-4679-8734-405905D7C3A9@.microsoft.com...
> hi I have a SQL DB hosted in a hosting company, I want to create a local
> copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in
> the
> Hosting machine so I could not do it.
> thks
>
> --
> Ken
|||I use DTS to copy the db from a web host to a local SQL Server. You're
right, backup requires the server to have access to the drive where you
store the backup file, and it can't get to your computer.
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:87AEBE9D-C237-4679-8734-405905D7C3A9@.microsoft.com...
> hi I have a SQL DB hosted in a hosting company, I want to create a local
> copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in
> the
> Hosting machine so I could not do it.
|||Hi
You may want to talk to the hosting company to make the backup downloadable
or have it ftp'd (with the appropriate security in place).
John
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:87AEBE9D-C237-4679-8734-405905D7C3A9@.microsoft.com...
> hi I have a SQL DB hosted in a hosting company, I want to create a local
> copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in
> the
> Hosting machine so I could not do it.
> thks
>
> --
> Ken
|||Thks all of you!!!
"Kenny M." wrote:

> hi I have a SQL DB hosted in a hosting company, I want to create a local copy
> in my pc, what is the best way to do it.
> I tried to make a backup but it seem that the backup can be done only in the
> Hosting machine so I could not do it.
> thks
>
> --
> Ken

Make duplicate db?

I am wanting to be able to take my work home with me, problem is I can access the server from there.

Is it possible to work with a local instance on my laptop, then when completed transfer it to another instance on a different pc?

Meaning, talbes,queries,etc.

Thanks

Davids Learning

You can create a backup of the database and restore it to another machine.|||

does that work with the express version?

or would I be better of using Access?

Davids Learning

|||That works very fine with SQL Express.|||

I need help with this.

How do you backup or restore to a different instance on a different machine?

I am new to SQL Server.

I can from my laptop see the server and access the files and do a backup(I believe the backup ran on the server and not on mine), but how do you get the db to my instance on my laptop?

Thanks

DavidsLearning

|||

Look in Books Online for the usage of RESTORE, and especially the WITH MOVE option.

If you don't have Books Online, download a copy here:

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx

|||

I quess this is a Monday.

Is there a book for dummies?

Tried to apply what I read, and I still dont get how to assign a different instance.

Is there a way to make it simplier?

DavidsLearning

|||

You execute the RESTORE operation from the INSTANCE (after connection to that instance) where you want to install the database. (You don't 'assign an a different instance'.)

Some weeks , everyday seems like Monday...