Viewing 15 posts - 1,441 through 1,455 (of 2,636 total)
In most cases, if the database server is accessible from the web, you'll need processor licenses.
MS has lots of advice for licensing:
http://www.microsoft.com/sql/howtobuy/default.mspx#EXE
http://www.microsoft.com/licensing/mpla/default.aspx
Greg
July 23, 2007 at 5:20 pm
I think what CJR is referring to is the pop-up list of packages you see when you're creating an Execute Package task in DTS Designer. The packages are ordered by...
July 23, 2007 at 5:00 pm
I think Securityadmin would allow them to do most of the tasks you listed except add members to roles. I'll bet adding members to fixed server roles isn't a big...
July 20, 2007 at 8:46 am
Ali,
Simply go to the Data Transformation Services (DTS) forum (you can click on the link at the top of this page) and click the "New Thread" button at the top-left...
July 18, 2007 at 2:42 pm
Sorry SQL ORACLE, I completely misunderstood your question! Luckily, Noel knows what your trying to do.
Greg
July 18, 2007 at 2:36 pm
Sorry, it can't be done. Oracle dmp files can only be read by the Oracle import utility. You'll have to import the contents of the file into an Oracle database then...
July 18, 2007 at 2:22 pm
I second the call for sample data and expected output. Generally, if you can select the data with a query, you can export it with SSIS.
Greg
July 18, 2007 at 2:19 pm
You can only execute a package in a job. Use DTSRun in a job step making sure you include the 'F' argument to specify the file path.
Ex: dtsrun /Ffilename...
July 17, 2007 at 2:13 pm
Assuming I have a table named userobj that contains object IDs and a user ID:
create table userobj
(userid int,
objid int
)
select
userid, object_name
July 12, 2007 at 10:57 am
I've found that the Public role in msdb has the needed permissions by default, but if someone has changed that in your instance, you can grant EXECUTE to the following...
July 12, 2007 at 10:35 am
If you click on the "Lifecycle Support Policy FAQ" link on that page, you'll find an explanation of the differences between mainstream support and extended support.
Greg
July 12, 2007 at 10:13 am
I always use QA rather than EM to run queries. There's way more flexibility in QA.
Greg
July 12, 2007 at 10:09 am
Reem,
The advice and examples that have been posted are what you need. I'll try to explain how I think you should use them.
The next time you need to make changes...
July 11, 2007 at 3:46 pm
You can use an ActiveX Script task to display an input msgbox and pass the input data to a global variable.
Here's an example:
http://www.sqldts.com/214.aspx
Greg
July 11, 2007 at 9:55 am
You'll find this information in msdb.dbo.sysjobhistory.
Greg
July 11, 2007 at 9:15 am
Viewing 15 posts - 1,441 through 1,455 (of 2,636 total)