InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 13:23:57 GMT20http://www.sqlservercentral.com/Forums/Topic1419213-1292-1.aspxYou're welcome. Thanks for the feedback.Wed, 13 Feb 2013 12:21:52 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419213-1292-1.aspxThank you, that worked well for me.Wed, 13 Feb 2013 12:19:48 GMTrightontargethttp://www.sqlservercentral.com/Forums/Topic1419213-1292-1.aspxSSIS would be my choice for this. A Derived Column Transform after reading the file could append your additional columns before loading the row into a table.If you want to stay in T-SQL then you can use OPENROWSET and read the entire file as a SINGLE_CLOB and append the columns you want to the resultset:[code="sql"]SELECT BulkColumn AS LineFromFile, 'something' AS Col1, 'something else' AS Col2FROM OPENROWSET(BULK N'P:\@\1.txt', SINGLE_CLOB) AS Document;[/code][size="1"]edit: spelling[/size]Tue, 12 Feb 2013 17:46:21 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419213-1292-1.aspxHi all,I have a text file that has one number in it. I need to load that number into the table, but I need to add 2 more fields to it (hard-code value and the current date).For instance: my file has 12345 in it. I need to do the following:insert into tableAvalues ('A',12345,getdate());Is it possible to do in one shot in:BULK INSERT tableA FROM 'c:\temp\file.txt' WITH ( ROWTERMINATOR ='' )Thanks,Tue, 12 Feb 2013 15:11:36 GMTrightontarget