The issue doesn't appear to be on the excel side but instead in the DB. I think SSIS is making that column Datetime and nulling out the invalid entry. You...

I would get rid of the '----------' lines and then mark the first row as a header when you import it. SSIS should then ignore it and correctly associate that...

Why don't you save the package in the SSIS Package Store and then you dont need to worry about disks?

-Mike

You can also do a page break in your report that will force then next section onto a new sheet in excel. If you are grouping data for example, you...

If you are using Unicode then you can store everything in the 'n' equivalent data-type. For example, if you would normally use varchar(10) then you could use nvarchar(10) same thing...

You can also right click on the table and go to Properties and then Storage and it has a row count there. I think you need be updating the table...

Thanks jazu4ea and Simon_L for the comments! 🙂

I love photography and taking pictures...its a great way to relax and have fun. I guess it is kinda of ironic that my former boss in IT actually got me...

Hey Michelle,

I was just curious if this issue was specific to VS or also apparent in RS/MOSS.

Question: Is the "Multi-value" options checked under properties?

Hey Michelle,

Your "default value" should be identical to your "available values" settings and it should work just fine. Have you tried it in both VS and SSRS?

mtraphagen:

If you want a default select for your parameters then you can set that up in the "Default values" section at the bottom of the "Report parameters" screen. If...

That error message means that the "cursor" is already open but it is trying to be opened again.

I would suggest you try executing you select statement against the DB2 files...

Check out The SQL Performance Dashboards...

http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

He hasn't posted in about 2 years but...

Blog: http://blogs.msdn.com/ChrisHays/[/url]

Post:

-Mike

Hey John,

Are you using a data set to derive your parameters? Can you? It is far more effective to have a table containing your values then hard-code them into your...