When you open a package I Business Intelligence Development Studio, Protection Level is shown in the package properties. That's where you can change it. By default, it's always...

And please, please don't post the same question in multiple forums. It might seem like you'll get more responses, but it just wastes peoples time and spreads replies all...

I've gotten this error when I've saved a package with the Protection Level set to the default EncryptAllWithUserKey, which means only I can execute the package. I changed the...

Please don't double post. See replies in this thread: http://www.sqlservercentral.com/Forums/Topic611126-19-1.aspx#bm611634

You could also script out the jobs in Enterprise Manager and run the script in a SQL 2005 query window.

You can import multiple tables in the Wizard if you choose "Copy data from one or more tables or views" rather than "Write a query to specify the data to...

Next time you use the Wizard, when you get to the screen that has options to "execute immediately" and "save SSIS package", choose to save either in SQL Server or...

Yeah, point in time recovery depends on the database using full or bulk-logged recovery model. So more information is needed from the OP.

Please describe how you migrated the DTS package to SSIS. Did you use the Migration Wizard in SSMS or in BIDS? If you did, you have to choose...

ritesh.saluja (11/26/2008)

---

I can see a role having permission to execute certain stored procedure. The role includes one user.

I cannot see any permission details at table levels like "Select, insert2 permission...

CHECKIDENT works fine, but the OP said he's deleting all rows from the table anyway, so TRUNCATE

TABLE meets both needs.

You should read "Deploying packages [Integration Services]" in BooksOnLine. That will get you started and may answer all your questions. If you have trouble, you can post specific...

Ah, omitting that bit in your original post is what threw me off. BTW, do you...

You can specify the schema when you save the new table by inserting the schema name in front of the table name in the save table dialog box.

Rich,

I don't know how you could have a schedule without a related job. Query dbo.sysjobschedules and dbo.sysjobs in msdb to see if there are is a related job.