Can anyone give me some direction on how to create a SSIS Package that opens up SFTP/SSH (Ftp) and downloads files to SQL Server/HardDrive.
Now a regular FTP Task will now work if I am correct?
View Complete Post
I want to know whether SSIS can do SFTP. If yes, how does it work?
Using BIDS that came with SQL Server 2008 R2, I created a text file import package. I used files generated from my local machine for local testing. However, I find that these files get their format changed after being SFTP'd to the data warehouse.
Not being able to visually see a problem with the text file to be imported, I copied it down to my local machine and compared to one generated at my machine. Not until I chose "Show All Characters" in Notepad++ did I see the difference: my local file ends its
lines with a carriage return-linefeed character, whereas the file that went through SFTP ends its lines with a linefeed character only.
I suspect there's something very basic going on here that I don't know. I won't ask anybody to explain it, but I'm wondering if there's some way I can import both file formats. The column numbers and lengths are identical, it's the just line
ending character that's different and causing zero rows to get imported. The only other thing I know to do is recreate my flat file connection, and I haven't even tried that yet.
Hello, just wanted to ask a question about SSIS and SharePoint, any input will be greatly appreciated.... did search the forum but could not find anything....
So basically we have a SQL Server DB with the metadata ONLY, WITHOUT the related files(doc/ppt/pdf..etc) which should've been in the DB and they are on a separate web server inside folders. Each row in the DB has a key (column) which matches the related
folder's name, so for row with ID #112, there's a folder named ID112 on the web server with the relevant files inside. There could be more than 8+ files for one folder.
Now, I think it is possible but just wanted to double check, would it be possible to use SSIS and some kind of a script to get the metadata inside the SQL DB AND the related files inside those folders, combine & relate them and
upload them into SharePoint as a custom list with file attachments? would they display the attachment normally (like the paperclip icon in a sharepoint list...etc) I wonder if anyone has tried this...
Any guidance, thoughts, suggestions for other solutions, inputs will be great!!! Thank you!!
I want to develop a service (may be Web / WCF / Windows) to monitor a SFTP location for excel files. As soon as any excel file arrives, service should be able to move it to some location and initiate another process.
My queries are:
1. Can we monitor SFTP using services? If not, what are the other ways to monitor.
2. Which service (Web / WCF / Windows) should I use? What could be the challenges?
Any help is highly appreciated. Thanks