SSIS and text file in sql table

Question

Post reply

SSIS and text file in sql table

keywestfl9

SSCertifiable

Points: 5215
More actions
August 23, 2008 at 3:20 pm

#130785

i have a huge text file in a ftp location. i need to dump the text file in to sql table.
then look for certain contents in that table and generate a txt file with those contents and email it to certain email id's
how do i do it in ssis?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Paul_J Hall of Fame Points: 3698 More actions · Answer 1

Bulk insert task to load the file into the table, then a script task to examine the table and take actions?

Or if you don't need ssis at all, then BCP to load the data and a job to examine the table and take actions?

Need more info about your requirements and limitations.

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 2

Thanks for the response.

1. i have a huge text file present in mainframe fTP server

2. i have get certain information from the text file and send email to corresponding people on daily basis.

How do i do it?

Paul_J Hall of Fame Points: 3698 More actions · Answer 3

You don't need ssis for this at all. One option is to create a scheduled task in Windows to do what you want. Another option is to create a job in sql server.

Manie Verster SSCertifiable Points: 7152 More actions · Answer 4

How good are you with Visual Basic for Applications? I have code that reads through a text file and from there you can insert it into a database table and work with your data from there. Why you want to load it into a database I don't know but suppose you have your reasons. The e-mailing part is not so simple depending on what you know. Here you have two options. First one is also a VBA program for which I have the code or Database Mail but you will have t research that a bit since I have not yet done that part but you can, with both options, send mass e-mails to as many emails as you want. I have used the first option with +- 25000 e-mails with attachments and html body. Let me know what you want to do.

:-PManie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 5

Thanks Manie Verster

i have to extract few things from the text file present in the FTP location and make it as a new text file and email it to few people.

Since the text file is huge and it contains details of many application of my company, i just want to extract my application detail and put it in new text file and email it.

This should be automated process at a particular time.