SSIS PACKAGES
-
Hi All, Could you please let me know how to set up a CSV file transfet from an FTP site to a Table in a SQL Database table ? Do i have to use Ftp Bulk Insert Task? How do set up? Please advice. Thank you
The short answer to your question is, yes you will need the Ftp task. Use Ftp as your source and then you will need to choose the correct destination task (for example Sql Server destination). Most likely you will probably need to do some sort of data conversion as well. There are transformation tasks for this as well. If you need anything more specific than that you will need to ask a question specific to a problem to are experiencing and describe why it isn't working. I also suggest you get a book, or use Google to look for tutorials and HowTo topics on using SSIS. A forum is not the place for you to have someone do your work for you.
Mark's blog: developMENTALmadness.blogspot.com
-
The short answer to your question is, yes you will need the Ftp task. Use Ftp as your source and then you will need to choose the correct destination task (for example Sql Server destination). Most likely you will probably need to do some sort of data conversion as well. There are transformation tasks for this as well. If you need anything more specific than that you will need to ask a question specific to a problem to are experiencing and describe why it isn't working. I also suggest you get a book, or use Google to look for tutorials and HowTo topics on using SSIS. A forum is not the place for you to have someone do your work for you.
Mark's blog: developMENTALmadness.blogspot.com
Thank you very much for your response.Its much appreciated.To be very specific i have used the Ftp Task to download the file from the FTP server to a local Pc where the Sql Database runs.The next step is to Upload the file on to the Sql table i have used Bulkinsert Task.I have manhed to upload a flat file (*.txt) file.However when i Use a Csv File excatly in the same format to the flat file It doesnot copy the data on to my table. I hope its clear now. Thank you
-
Thank you very much for your response.Its much appreciated.To be very specific i have used the Ftp Task to download the file from the FTP server to a local Pc where the Sql Database runs.The next step is to Upload the file on to the Sql table i have used Bulkinsert Task.I have manhed to upload a flat file (*.txt) file.However when i Use a Csv File excatly in the same format to the flat file It doesnot copy the data on to my table. I hope its clear now. Thank you
Are you getting any error messages? If so what do they say? Simply saying it doesn't work isn't enough information to go on.
Mark's blog: developMENTALmadness.blogspot.com
-
Are you getting any error messages? If so what do they say? Simply saying it doesn't work isn't enough information to go on.
Mark's blog: developMENTALmadness.blogspot.com