SSIS SFTP using WinSCP

Question

SSIS SFTP using WinSCP

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

homebrew01 SSC Guru Points: 55548 More actions · Answer 1

water490 wrote:

One more question ...
From a design perspective... is it better to have one script do it all or should there be different SSIS tasks for each?

My personal preference is to favor readability and maintainability. That often means doing things in smaller chunks possibly at the expense of efficiency. Think about 1 year from now and needing to make changes. What design will be good for that ? We work with small data sets so absolute efficiency is less critical than it may be for others.

Add notes as needed to help you later.

water490 SSC Eights! Points: 959 More actions · Answer 2

i figured out the issue. ignore post.

This reply was modified 2 years, 9 months ago by water490.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

water490 wrote:

i figured out the issue. ignore post.

Two way street here... Can you tell us, please?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

water490 SSC Eights! Points: 959 More actions · Answer 4

No problem

The script looks for a particular text within the SFTP files. I made a typo so that is why it would not find the files I was testing. I fixed the typo and now its working as planned.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 5

Ah, got it. Thank you. Heh.... yep. Been there and done that myself.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)