February 3, 2005 at 5:34 am
Hi,
I don't know the name of Text file as well as Desination Table Name. Actually The text file contain information about Table name. I have to pick 1st column as Table name, validate the data and then upload. Can i do it. If yes. Pls. help me out in solving the problem.
Thanks
Raju
February 3, 2005 at 6:29 am
Again I need an example of the file layout detail. But as for selecting a destination you could use Active Scripting with FileSystemObjects to find all the files in a specific directory. Are they all in the same directory or in subdirectories of a common directory?
February 3, 2005 at 7:05 am
In addition to Antares, when you found the text file name, import the data into a fixed table name, validate the data and if OK use sp_rename the rename the table based on the value in the first column. If the data is not valid then drop the table.
You will need appropriate permissions to use sp_rename.
Far away is close at hand in the images of elsewhere.
Anon.
February 3, 2005 at 8:55 pm
Hi
Pls. find the file layout. Where A222, a223, A940,.... is the name of the File followed by field name....
A222|ZS08 |0005 |H350 |GENERAL_REPAIR |A |28.02.2004|01.02.2004|0000352836 |000
A223|ZS16 |0005 |02 |03 |03 |20W50FOL080KLG |31.12.2001|01.01.2001|0000044759
A222|ZS01 |0002 |02 |VG602-11311 |31.12.9999|01.01.2002|0000054528 |
A940|ZS01 |0002 |03 |01783-03760 |31.12.9999|20.09.2001|0000029494 |
A940|ZS01 |0002 |03 |04111-06012 |31.12.9999|20.09.2001|0000029495 |
A940|ZS01 |0002 |03 |04111-16124 |31.12.9999|20.09.2001|0000029496 |
I could not go uor point. Pls. elaborate
Regards
February 4, 2005 at 2:23 am
Please refer to other post
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=159272
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply