Interested to Buy Any Domain ? << Click Here >> for more details...
How to work on DTS?what is the main requirement?
- 1 Answers
- 5843 Views
- Getit, ivan, I also Faced
- E-Mail Answers
Answer Posted / naresh
DTS (Data Transformation Services) allows you to get stuff
in and out of SQL Server and between any ODBC and OLE DB
data source. That includes DB2, Access, Excel and Text, as
well as Oracle, MySQL, PostgresSQL and even SQLLite. -in
fact, anything with an ODBC driver. Not only does it do the
transfer but it allows you to fill in missing data, do
column mappings and so on. In other words, you can fiddle
with the data as it passes through.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what do you understand by change data capture?
What is not null constraint?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What are audit control procedures?
Explain the benefits of user-defined functions?
What do you understand by the data quality services in sql server?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Do you know what guidelines should be followed to help minimize deadlocks?
How will you decide the active and passive nodes?
Can group functions be used in the order by clause in ms sql server?
What is sql server locking?
What happens if null values are involved in comparison operations?
What are triggers? How do you invoke a trigger on demand?
How and why use sql server?
How to loop through result set objects using mssql_fetch_array()?
