I manage to get this done with some help here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110326

To my current code already in place,I have added

'Files are...

I tried the following.I created a Script Task with

2 read variables

FileLocation = "C:\Test\"

FileExtension = "*.zip"

1 write variable

FileExist =False

In Script Task

Imports System

Imports System.Data

Imports System.Math

Imports System.IO

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

...

Im thinking of doing the following,writing a .net code to check for file exist and add it to script component.Upon success execute the rest of the SSIS package.

Do you think...

Hi Paul,

Im interested in the 2nd option,any ideas on how I can get started with this.thanks

All,

Read from below and currently am trying it.

http://blogs.msdn.com/bwelcker/archive/2007/06/19/marquee-moon-field-references-in-page-headers-and-footers.aspx

1) Created a txt box on Report Header.That has a value of

=ReportItems!textbox1.Value [Refers to a textbox1 in Report Body]

2) TextBox1...

Could some one confirm If my steps are correct ?

Inorder for me to have the first 2 rows repeat on each page,Do they need to be part of table header?...

I tried using a TRIM and changed both Text Box Values to Lower Case [LCase] and then compared them using the "LIKE".

It works now 🙂

Thanks Chuck for a breif overview of what would need to be done. Could you give me a step by step list,so I can follow through.

Is there a size limit...

Thank You guys...My doubts are clear now.:)

As I just joined this company as a Jr DBA .Im not very sure on the setup that they have but I would be great if you could give me...

Jack,

It is SQL 2005 and I am using the correct textbox for the expression.I have written a simple VB function that would convert a IS NOTHING value to 0 and...

Jack,

I tried both the IIF's.Here is what I get

[rsFieldReference] The Hidden expression for the textbox ‘textbox42’ refers to the field ‘total’. Report item expressions can only refer to fields...

Jack,

I tried the 2 fIIF you have mentioned above,but it gives me an error of invalid data type returned.Any other suggestions?

Hi Jack,

Thanks for your response.I tried the NoRows on table Property.But what I need is to include a "0" in the total txtbox of the table.Any idea?

I have attached the...