Hi All,

I opened the new project in sql 2008 and take ssis project and try to add the existing package .dtsx which is developed in sql data tools but it...

I found the options

1) Rebuild the project in the correct version of BIDS that matches the server agent

used to run the job.

2) One other option is to set...

Hi,

I am getting the same problem here. Job is failing with the error msg package migration from version 6 to version 3 failed with error code 0*C001700A. The version no...

Hi,

After so many trials with some one help, I got the result. It will help to some one else. So I am posting that here

DECLARE @Update VARCHAR(10)

SET @Update =...

Hi,

Thanks for the replies.

They changed the log files route but it is enabled and default trace switch is set to 3.

But when I see the log file, I found...

Yes,

I am converting from varchar to datetime

It gave 2005. Sorry wrong place. I will post in the right place

It is giving that the path doesn't exist msg.

Thank you.

I am able to run the profiler from the tools under ssms and saving the ssrs trace in D-Drive. When I scriptout the trace template to run like server...

Little confuse about the profiler timings.

Correct me if I am wrong

When we selecting trace from Tools the time filter is in milliseconds but when we are monitoring from the trace...

If we have same trace in different files like Perftrace1, Perftrace2, Perftrace3.

How can I roll over all those in to single sql table?

It is showing try_parse is not a recognized built-in function

I have a table which has manufacturing date column but they use the varchar instead of datetime datatype.

Also that has the null values.

I need to get the id values...

Thank you

Not clear about the /CHECKPOINTING OFF /REPORTING E',

What is this?