port 22 is default so its connecting fine and file is partly transferred,

how do i increase processing time in sql server???

Once again i cant use SSIS.

I've decided to go with WINSCP and have the following challenge:

single step job executes:

----------------------------------------------------------

\\app\WinSCP.exe /console /script=\\app\config.ul

----------------------------------------------------------

config.ul is written as:

----------------------------------------------------------

option batch on

option confirm off

open...

putty requires host key verification, is there anything else that i could use?

That could work, however how would i connect to sftp on port 22 ?

I was going with xp_cmdshell since i didnt know any better, now i do :).

Can you collaborate on how to do sftp with CmdExec ?

that didnt work for me,

all is get is :

idouputtmp

1Unknown host xxx.xxx.xxx.xxx:22.

2Invalid command.

3Invalid command.

4Interactive mode Off .

5Not connected.

6Not connected.

7Not connected.

8open xxx.xxx.xxx.xxx:22.

9user

10pass

11prompt ...

I cant use SSIS,

how do i specify port 22 in xp_cmdshell ?

Phil Parkin (1/12/2010)

---

In your example, there is no tab after char1, the 'code', yet the rest of the data has tabs delimiting the fields. So it's really not clear -...

bitbucket-25253 (1/11/2010)

---

I suggest you look at

http://www.sqlservercentral.com/Forums/Topic845680-338-1.aspx

For grins and giggles I modified the input data for the above forum to replace the commas in the string with tabs.

INSERT INTO

Jeff Moden (1/11/2010)

---

rnikandrov (1/8/2010)

---

the goal is to import file so that i can work with it.

here is a sample:

A 919934 [tab] 1 [tab] jason

B 2222 [tab] 999999 [tab] 111111 [tab]...

that was embarrassing, i knew that 🙂

thanks, i was just making things more difficult.

How would i go about reading tab delimited row? (step 2)

Thank you for your suggestion,

the plan is to:

#1 import file into single array

#2 parse the right line into temp table, so that i can work with it

can you give...