So you have the batch file creating the WinSCP script in a separate file called FTPLog.txt. You then have a line in the batch file to invoke WinSCP and...

Depth

Brandie Tarvin (4/29/2015)

---

You know how when you run a .bat file that uses command line stuff, a prompt opens up and processes the code?

That part is what I'm trying to...

I can't help you at all with the SSIS part, so I'll focus in on the WinSCP part. It's been a while for me, but I'll give it a...

Brandie Tarvin (4/29/2015)

---

ChrisM@Work (4/29/2015)

---

Sean Lange (4/29/2015)

---

andrew gothard (4/29/2015)

---

Sean Lange (4/28/2015)

---

Lynn Pettis (4/28/2015)

---

The OP just PMed me with all the info that had...

The generate scripts in SSMS works fine for me and handles comments properly.

Koen Verbeeck (4/29/2015)

---

Grant Fritchey (4/28/2015)

---

Lynn Pettis (4/28/2015)

---

SQLRNNR (4/28/2015)

---

Lynn Pettis (4/28/2015)

---

The OP just PMed me with all the info that had been posted...

Reflect

Good question to start the day. An exercise in clear thinking is always good for the brain. Thanks.

Tommy

Gary Varga (4/28/2015)

---

I am certain that as an industry that we reduce our productivity over the longer term due to ignoring root cause analysis or, sometimes more frustrating, ignoring the...

When you post your DDL, sample data and expected results, please include the purpose of the Temp column if it's pertinent to the query you need to run. Also,...

mistylove98 (4/28/2015)

---

I tried this lynn to no avail. I dont understand

...

Like Gail pointed out, the error is saying it can't open the explicitly defined database. The connection is made, but look in the connection string for the initial catalog....

So...