MisLead (5/23/2012)

---

I have an execute task that truncates the table when the package runs. Downstream I have dataflow tasks that fetches fresh data and populates that data using stored procs....

Can you please post the query that "creates a table of tables that meet certain requirements" ?

You can access Oracle using an Execute SQL Task and you can access a web service using a Web Service Task. What is your definition of "Dataservice"?

I am not sure if such a thing exists where all data access and rendering occurs in Word. The closest thing I could come up with that may be workable...

sqlbee19 (5/22/2012)

---

I just want to eliminate SQL account. Here in my case I cannot create DSN using integrated windows credentials as I have to give access to all users of...

You'll need to poll for the data but I would opt to do that work within the same package execution and not allow the package to exit. If the source...

Rebuilding indexes updates the statistics that pertain to those indexes. If you have any manually created statistics, or 'auto create stats' is enabled (default) in your database then you may...

Jayanth_Kurup (5/22/2012)

---

as long as u follow the principle of least privileges using a sql login shouldnt be too much of a problem.

ideally u want :-

domain account > login> db user>...

Possibly, a good recommendation depends on a lot of info we do not have. does the app need cross-database access? does the app need access to server-level metadata? are the...

sqlbee19 (5/22/2012)

---

Yeah I agree.

The solution I am looking is for Application level access.

For example :

We have appliction X and we have 1000 end users to that application. When ever users...

Anything you can do in .NET you can do in PoSH. Lookup Table-valued Parameters, and how to use them to insert sets of data using one in a Stored Procedure....

Microsoft recommends all clients connect to SQL Server using Kerberos authentication where possible.

weberharter (5/22/2012)

---

scripting objects or table contents can all be done using Microsoft management studio. right click the database and choose "tasks, generate scripts". select the objects you want to script....

A solution using PrimaryFilePath will only account for the location of the primary data file for the database specified. If that database has multiple data files and one of those...

I am sure you will find all the information you need at the link I provided 😉