Thanks for the reply! Yes, I did install font on the server and rebooted the server. That resolved the issue!!

Do you have any suggestions for table that doesn't exist in trigger? how to find them?

I ran EXEC sys.sp_refreshsqlmodule @name = 'trg_Audit_Del' but it did not give me any error even though that trigger is using a table that doesn't exist in the database. Any...

Thanks so much! It worked after changing the datatype to NVARCHAR.

Below is the XML string that i'm trying to send....I'm getting error because we have special character ã in <NewValue>ãpple</NewValue> tag. If I replace that with apple, it is working....

I'm not using just ã. I want to be able to use all special characters like these...When i run a query like CAST('ãpple' AS XML) works but why is Service...

yes, i've already configured distributed ad hoc queries. Like I said before it is working when I run the query on the SQL server through remote desktop connection of the...

Thanks for your reply. I tried but lo luck. Any other suggestions!

Thanks in advance!

Hi All,

This is working for me when I run the query in the remote desktop connection of that server but it is not working when I run it on my...

Hi All,

Here is what i've done to overcome this issue

I took EXECUTE SQL TASK instead of Data Flow task in ForEachLoop Container and used dynamic SQL query that will generate...

Thanks for you reply. I'm working with Excel file not flat file. How can make that change for excel file?

Thanks for your reply!

Where can I increase the length of the columns in SSIS?

After getting sysadmin rights on the server i'm getting the below error:

Msg 7399, Level 16, State 1, Line 2

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error....

Sean,

Thanks much! That worked.

Koen,

That worked. Thanks for you help! Like you said I used =iif(CountRows() = 0, False, True) expression for Hidden Property.