Posted answer in other thread

http://www.sqlservercentral.com/forum/post.asp?method=Reply&TOPIC_ID=18337&FORUM_ID=19&CAT_ID=3&Forum_Title=Data+Transformation+Services+%28DTS%29&Topic_Title=How+to+import+a+%2Esql+file+with+DTS

isql /S servername /U username /P password -d databasename -b /m-1 /i filename 

if ERRORLEVEL 1 pause

 

I use this in .bat files to process my...

Duplicate post.

Edited by - davidburrows on 11/19/2003 07:07:07 AM

How about

cast(year(GETDATE()) as varchar) + 

REPLACE(STR(DATEDIFF(d,cast(year(GETDATE()) as varchar)

 + '-01-01',GETDATE())+1,3),' ','0')

 

Check the contents of the input file for the record in question (use a hex editor) and check that the row has the correct number of columns and is terminated...

Not a good solution but if the process time is small you could change the proc to have additional parameters, one to return the number of years and another to...

Simple example

UPDATE b 

SET b.col = a.col 

FROM tableb b 

INNER JOIN tablea a 

ON a.rowid = b.rowid 

 

Valid date conversions depend on many factors including the language setting of the connecting user. The error will occur is you try to convert dmy date when sql expects mdy....

Nah!

Wet Me Pants

Sorry Frank, couldn't resist

FOTFL & WMP

Keith,

quote:

---

My questions are easy

---

Easy for you to say...

Agree...

quote:

---

Can you help me understanding this?

---

Och No!

many a mickel makes a muckel

Edited by -...

Jim,

Define the input text file as delimited using a character that is not in the input. This will give you each line as a single column.

Create an ActiveX transformation from...

The table you are trying to update has a trigger called 'Movement' that uses RAISERROR to generate an ad-hoc error mesage if update attempted.

Depends on the input format. I prefer to convert input to dates first and then compare. You will have to convert anyway.

set @from = year1...