Hello,

Has this Linked Server ever worked?

Can you post a screen-shot of the Linked Server General Properties page? Failing a screen-shot please detail each property-value pair.

Regards,

John Marsh

Hello,

Did you check the data in the File to make sure that all the values in the source for Column 20 can be converted to an integer? (-2,147,483,648 to 2,147,483,647)

Regards,

John...

Hello Ian,

That’s the kind of thing that I was thinking about.

Personally, rather than a Trigger, I would use a separate step in an SSIS package to move the records...

Hello again,

Sorry, I can’t help you with your XML questions.

I was just wondering why not to use normal set based SQL methods, or may be I am missing something? If...

Hello,

Assuming that you have other DTS Packages that work Okay on the SQL Server and the fact that you mentioned the Package works fine when run from Visual Studio, then...

Hello,

It sounds like a Data Warehouse application that you are working on? If so, then wouldn’t standard ETL methods work e.g. load the Transaction File in first in to a...

Hi Onvia,

Shame you don’t have the permissions as that would have been the easiest solution.

You could use RedGate’s SQL Compare to compare the DB to an empty DB, and then...

Hello,

Was it the code from this article?

http://www.mssqltips.com/tip.asp?tip=1349

Regards,

John Marsh

Hello,

If you are deleting all the user tables and therefore the data in the DB, then is there anything that stops you from simply deleting and re-creating the (empty) DB?...

Hello,

If you just want to get a code listing then you can execute the system SP sp_helptext from within the relevant DB

e.g. sp_helptext ‘mySPname’

Regards,

John Marsh

Hello Again,

Are you using a Shared Data Source? What Security Context are you using to connect to the Data Source e.g. Windows Integrated? If so, are you using the same...

Hello,

Have you tried executing the report from a browser on the actual Report Server? You should receive a more detailed error.

Regards,

John Marsh

Hello again,

The best is to create a Windows Account specifically for the SQL Agent Service to run under. That way you can assign exactly the rights required. The MSDN article...

Hello,

You may be stuck with this one as according to BOL 2005: “Although any user with access to a database can create a diagram once it has been created, the...

Hello,

The first record will be for the report folder named “Employee Info Report” (where your report is deployed), and the second record is for the actual report.

“Type” is a useful...