![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions Assume that I have created a employees table which has 10 records. How to create a stored procedure to export all the records into the log file. Read Answers (3) | Asked by : vani I have three task in my SSIS package,1. Script Task2. Execute Process Task3. FTP Task I want to enable disable Execute Process Task and FTP Task on runtime using script task, How to do that?Do we have any property of dts using which we can access property of other task iin script task like Dts.Connection("Connectionname") for Connection Controls? How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain. Latest Answer : Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give through web config , this will be a common file and will ... How to transfer data from a text file to SQL table, Which is the best method to do that? Latest Answer : By using OPENROWSET commandExample: INSERT INTO dbo.ImportTestSELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:ImportData.xls', ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||