erm..

Solved my issue too but i would like to understand why?

My query also worked direct on management studio but not through SSIS with OLEDB source \ destination

CODE:

--variables to...

SQLAssAS (3/19/2015)

---

ZZartin (3/13/2015)

---

If you're actually expecting data with " in it can you change the file format from say comma delimited with " qualifiers to something else like just |...

If...

thanks for the advise of putting multiple statements, i ended up with 8!!

I am going to open a seperate thread for this issue

any help here?

unfortunately not! thanks though

you mention windows update - has SQL been restarted as a result of updates, and a new port has been picked up?

Check the port number and add it to your...

thats the best thing you could have said "what second dataset"

I was using 2 datasets, one for the main data set which had all of the information in the table,...

Hi David, thanks for your reply

the same error still happens im afraid!

I put this filter on the main data set, then tried the second data set but the error happened...

I am now getting the error

Incorrect syntax near 'nvarchar' - i have extended the variable to 100 to see if it was too short and it still does not...

Thanks for your help so far

So i created a procedure:

alter procedure sp_SSRSFindDatabase @DatabaseName varchar(30)

as

select RTRIM(@Databasename) --+ '%'

select [ServerInstance], [Database Name],[Owner], [Recovery Model] , [Compatibility Level], [State]

from [dbo].[tbl_Databases]

where [Database Name] like...

I know how to do a drop down, but want to know how to do a wildcard search too 😉

Hi..

I have 5 columns in my report:

ServerInstance, Database Name, Recovery Model,

Compatibility, State

This has all the databases across our SQL estate in it.

Its main function is to enable me and other...

perfect - cheers