I have to say that that solution *might* work, but it scares me a LOT. Copy and pasting from one to the other and fixing the connection managers is...

You are welcome.

You had me a little confused, it sounded like you were saying that because the packages are in the file system that there was some reason that you...

Why is calling a package from a file system a disqualifier to use SQL Agent?

You are calling this console app on the machine that has SSIS installed or from another...

I have copied and pasted from package to package before. da-zero was correct about ids under the hood. That is why when you change a connection name that...

You are very welcome.

CEWII

1. Yes. And I would probably say yes on too long. The question is, what kind of validation?

2. In many (most?) POS setups with multiple stores, you have...

I would re-write the process using SSIS, looping through a list of servers is easy. You could even likely re-use most of the queries..

CEWII

Well obviously you'll be archiving those 5 tables, but what about tables they depend on? How will the archive be used? What process will be put into place...

If it is already used, then chose a different name.

CEWII

I would look at the query plans and see what it is doing. I don't think we have enough information to make a particularly well informed decision.

I have used...

I reviewed that KB and have an idea of what you are doing. When you are using that other user (the one you are impersonating) does it have access...

A quick Google search reveals this:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/18ed000a-6e60-4687-a923-3db630b04226

Does that fit?

CEWII

dumin.net (4/8/2010)

---

Thanks Elliot for yor reply. it's clear to me. for the next times only the new and updated records will be upload to remote server.The issue is with the...

Quick question.. Are you trying to run an SSIS package or a DTS pacakge. Because DTSEXEC is for DTS and DTEXEC is for SSIS. Please elaborate.

CEWII

It needs a value at design time. So copy a valid value out of the current connection string and paste it into the variable.

CEWII