You are right.

We rarely select all 50 states in practice. However, we might have customers only in 7 states or we might sale the product...

Hello,

Drag a textbox on the header and use an expression like below.

=" Sales Report generated for: " & JOIN( Parameters!STATE.Value, ", ")

This is what I used in my report....

Check the following links, if it is helpful.

http://technet.microsoft.com/en-us/library/ms365330.aspx

http://technet.microsoft.com/en-us/library/ms169917.aspx

http://www.sqlis.com

also,

search ssis related video in SqlShare.com

Thanks

I would suggest you to search entry level or enternship type job, if you can. Second option is to search community service/volunteer job in database field.

It would help you...

It is not easy to send you the whole package. I will try in my next postings.

However, lat me explain you again in simple case.

SSIS PackageA has 3 tasks:

FTP...

The another way to solve this type of challange is to use data conversion task between source file and destination table.

Use data type Numeric(7,2) or

or

you can use CAST function.

For example,

select CAST(24.4567 AS DECIMAL(4,2)) AS Price

First

Download SQL Server 2005 or SQL server 2008 express edition

and attach Adventureworks database from codeplex.com.

There are many tutorials and white paper related to Sql server/ssis

in Microsoft web site.

Do...

I had also similar requirement last week and I did it

Do the following:

Drag data flow task in control flow and click it

drag oledb source and write the query

like

select acct_no, acct_name,...

My suggestion:

Download SQL Sercver and SSIS from Microsoft website.

learn the concept of each control flow tasks and data flow task in BIDS integration service project(when and how to use...

Try this:

SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS MyDate

I hope it will be helpful for you.

Please elaborate your idea. I need to set up it for next week.

Thanks

I had also similar problem before. the problem was that the form was expanding beyond the lay out of the report.

Go to project -> Report -> layout.

Make sure the form...

yes, please.

could you give me the link for that please.