Chinna

it is present in a server location. if it is in Database i can do it easily

Before FTP this file i got to change the date which is present in...

i know the starting position of each column.

no delimiter for the text file.

Thanks Jay

Entire Process should work like this.

1. Need to create a txt file with certain login information from the database and FTP to this txt file to FTP server...

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...

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...

Thanks for the reply. Since this is the first SSIS i am doing, could you please little more or give me some link which has some examples.

for all reports it works. not for the report where matrix is used. i get the below error.

Data Regions within table/matrix cells are ignored.

Thank you. it worked.

is there anyway i can directly use the dataset field value to page footer.

You can add using image control from the toolbox

i am creating a new report.

That Worked. Thanks.

select convert(varchar(20), cast(datefield as datetime), 101)from dbo.table where datefield is not null

i replaced datefield to my column name which is of nvarchar(50) containing dates and the table name.

but i get...

thanks for the information.

can you please tell me how to do update process?

Check and see whether SQL integration service is running by going to SQL Server Configuration Manager.

thanks for the information. I have BIDS and the package runs in BIDS. But when i call from VB or VBA data transformation (flat file to table) that step is...