Hello friends, 1. I have lot of different tables data to be extracted to flat files like table1, table2, table3.....tableXXX. 2. I need to run...
Hi friends, We have some web application like online recuruiting running on one machine. SQL Server 2005 EE with sp2 running on another machine on...
this is the remaining code to both....... Advance thanks, vvkp ********************************************************************* SELECT...
Nope. The second stored procedure never completing. ~VVKP
Hi Friends, I have two stored procedures with same code. Only the declaring values ..... so the first one was executed without any problem in...
Hi frineds, We are using multiple databases (SQL Server) in our application (J2EE) . Our connection is always to the main DB & Our client wants us to...
Is there any way to run batch file thru T-SQL ....like we did thru the DTS package with Execute Process task thanks in advance.
Hi friends, I got a strange problem with the DTS package.. We have a dts package inserting rows into tables and then a batch file will be executed to...
Hi friends, Is there any difference between these two TSQL codes. Because the first one is inserting correct rows where as the second one insert nil...
Oops...no body is there to help me regarding the file format?[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
I appreciate your help...I am asking help to do that only (copying data from flat file to temp table).But till now no luck my friend.
By using the command... bcp "Northwind.[dbo].[Sales]" out "sales.txt" I am exporting data to the sales.txt file and when I try to import data from...
Thanks for your help.Here is the format file I am using 8.0 34 1 SQLINT 0 4 " " 1 Time_DimID...
if I am doing like that I am getting the following error The statement has been terminated. OLEDB provider 'STREAM' reported an error. The prodvider...
[?][?][?]
Can anybody help in writing a stored procedure which does the bulkinsert to temp table from a text file with delimited, ANSI filetype, ROW delimiter...
No way we can change the process...its a file built by an app...we can not apply the logic at file built stage.
can you eloborate a little bit more "...use DTS to insert only those rows with the query to the table from this temp table and truncate after the...
I agree, but bulk Insert task does more quickly than data copy in DTS. Almost half of the time. So if I have any way to delete the rows in a better...
Hi friends, I have one table with 34 columns. We are importing data from a flat file thru Bulkinsert. After that we need to delete some rows which...
Separate names with a comma.
