Do you get any kind of message when you try to execute the package on the server using the Execute Package utility?

I don't know the answer to your first problem. Regarding the Execute Package Utility, can you specify what you expect to see but don't? Is it that you...

I would create another, identical table with the new identity increment value, insert into it from the original table, drop the original table and rename the new one.

You can uninstall a single instance. Go to Control Panel, select Add or Remove Programs, select Microsoft SQL Server and click the "Remove" button. You'll be asked to...

John Bates (2/2/2009)

---

hi,

If you are a SQL Server DBA, what do you allow you programmers/developers to do on a.) the test server versus b.) the production database server?

- create job?

-...

I also recommend reading "Deploying Integration Services Packages" in BOL. These articles helped me when I was setting up my first package deployment:

http://www.sqlis.com/post/Easy-Package-Configuration.aspx

http://technet.microsoft.com/en-us/library/bb945074.aspx

Got it. Then my recommendation would be to have a domain login created that doesn't have the password change requirement and use it in the credential.

Lowell (1/29/2009)

---

a DTS package doesn't write to a table by default, it only writes to a txt file in the Windows operating system. For This reason, other people asked to...

Is your SQL Agent run under a local account? Is that why you don't just grant it permission to access the remote file?

I'm pretty sure you can't replicate from a passive node because it's not accessible until a failover makes it active.

Steve Jones - Editor (1/30/2009)

---

Gran Torino is on my list, but I'm not sure I'll see that before it gets out of theaters.

I did see Dark Knight, good in spots,...

I am Legend

IronMan

Wall-E

Pineapple Express

Hancock

Quantum of Solace

7 Pounds

Gran Torino

Slumdog Millionaire

Appaloosa

The Import/Export Wizard is available in Management Studio by right-clicking on the database name, selecting Tasks, then selecting Import Data or Export Data.

Right. You'd do what you were trying if you were developing an Analysis Services project, not an Integration Services project.

I don't know why, but I also had the same problem. I ended up exporting all the DTS pacakges to .dts files and then importing them into SQL...