Hi

I'm setting up a dts job that will import the data from a heterogenous table to a the same table in SQL
I want to know if it makes a difference if I use the sa account to setup the connection on the SQL end or should I setup another SQL account with minimal priviledges to make the connection? Does it matter

Also, the destination SQL table has a clustered index. Do I need to run a DBCC REINDEX against the table after the import

Thanks
Penny

1. What if the sa password changes ? You will need to redo the connections
2. sa is ALWAYS too much
3. After large loads update your stats. Maybe if the table is large run
INDEXDEFRAG()



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Penny" <anonymous (AT) discussions (DOT) microsoft.com> wrote

minimal priviledges to make the connection? Does it matter?

What permissions does the account need to have. Is read/write permissions on the destination table sufficient
Stupid question I'm sure, but how how many records would be considered a large upload, and how do I update the stats

How can I include the INDEXDEFRAG as part of the dts job

Thanks
Penny

Read write is enough to be able to READ from the Source and READ/WRITE to
the destination.
A large upload is relative. Some people loads millions and some load maybe
20. Look at it as a % of the rows already in the table i.e. If your table
has 20,000,000 rows and you add 20 then that is really not going to make a
whole raft of difference.

Use the ExecuteSQL task to run INDEXDEFRAG
OR
Schedule it as a job for after your batch loads finish.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Penny" <anonymous (AT) discussions (DOT) microsoft.com> wrote