My Table Keeps growing. I add new data all the time to it. So if I use IDENTITY(1,1), then eveytime I update my data, I have to first DROP the...

Thank you very much.

So there isn't any way to import say multiple tab or comma delimited text files (A.txt,B.txt,C.txt) using T-SQL query at one time? I'm not worrying about manipulation yet, just importing.

I dont want specific rows and columns in my tables. It is better if I dont import them in the first place. But I guess I will just delete them...

If I use BULK INSERT as such, then it only imports one file into the table. I want that I should just drop in the text files(having random names or...

I will just write a query to delete the specific rows and columns.

Thanks.

Hi,

I can Arhive the files in a datewise format. But Can you explain this a little more how to use this with BULK INSERT.

I also found a solution by using...

Yes I can do that, but I was thinking not to import in the first place. I guess I will Drop them after importing.

Thanks Guys.

Hi

I do not want to use SSIS yet. I'm only working with SQL queries. Say I have a table with fixed no. of columns. I want to schedule a job...

Hi,

Since the file name and the columns changes everytime, So it will only run for one time. So how do I load multiple files each into...

Hi

Here is what I want. I have attached two excel files(Test.xls and Test2.xls) with this.

Test.xls is the file that I want to import and Test2.xls is how I want...

Thank you very much.

Thank you very much guys. I'll try doing it by this method.

I have one more question. As I told you that I'm going to use this data for Reporting purpose....

Since I don't have much knowledge of .NET so can you provide me with the code so that I can modify it according to my needs.

Thanks

Yes, thats what I'm trying to do. I want to create a SSIS package for this. And yes, the file name will change daily. We use to cut, copy, paste...