ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How to give a user the option of importing Excel and a 
delimited text file into a SQL Server Database without 
manually using SQL DTS?

 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?
Answer
# 1
You can use the DTS object model to programmatically create,
modify and run DTS packages. 
You can do this many ways, but essentially this object model
has objects for anything you can do in DTS. 
If you already have the package created and saved as a file,
add a reference to the DTS Library. 
Then you can call it like this: 

    Dim Package As New DTS.Package
    
    Package.LoadFromStorageFile App.Path "\DTSPackage.dts"
    Package.Execute
 
Is This Answer Correct ?    0 Yes 0 No
Guest
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)  1
what is the importence of the trigger in sqlserver2000? ATI1
What are the main control-of-flow T-SQL constructs?  1
How do you troubleshoot SQL Server if its running very slow?  2
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?  1
Can we create clustered index on non primary key column CTS11
SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES Microsoft1
Difference between server.transfer and server.execute method?  1
What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table HP12
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS? GE1
What are the types of backup and tell me the difference between full and differential backup? TCS3
What are the advantages of using sql server over ms access or why should one use sql instead of ms access Impetus1
How to determine the service pack currently installed on SQL Server? HCL2
How do we get month name in SQL Server 2000, Oracle, MS Access?  4
Differnce between sel server 2000 and 2005  3
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server. IBM3
What is the STUFF function and how does it differ from the REPLACE function?  1
syntax for deleting the database in T SQL  3
What are the steps you will take to improve performance of a poor performing query? HCL1
How do we get current date in SQL Server 2000, Oracle, MS Access?  10
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com