While I question the whole methodology I would probably do this as a data-flow task.

The source would read the table and format the data for the ending result.

The destination would...

Abs-225476 (3/21/2012)

---

Hi, thanks for your reply.

I want to be able to schedule this ssis package to run everyday.

The sql script will look at new records created in a...

Been there as well, had a case where it was apparent within 2-3 minutes of...

They are not part of RAM but they require a certain amount of RAM to function properly, or so I am told.

CEWII

sam.dahl (3/20/2012)

---

You can of course just do your work in notepad and save it as per any file.

SSMS shouldn't be any different.

P.S. In my experience, whilst template packages work well...

I would likely do such a thing from a script task..

However, I have a wider question, what is it that you want to accomplish in the end?

Why do...

GSquared (3/20/2012)

---

Many job-seekers mirror this by expecting that "I know how to spell SQL, .NET, and I really, really need this job" will land a job. I've seen falsified...

RAISERROR ......

Ah, a little SQL humor..

CEWII

Because it is not you writing the file it is SQL. There are several instances of this such as backups. The backup itself is generated by the SQL...

You can only have one named instance per virtual name. As of SQL 2008R2 you couldn't add a second instance to an existing virtual name.

Keep in mind the various...

Using WMI oyu can check this. When I do this manually I like to use an app called WMI Explorer.

If you look at the class Win32_Processor it will list...

I've said this in other posts but I will re-iterate it here.

Participating in online forums is a great way to show over time your demeanor, your process, your skills, and...

I'm gonna ask a dumb question, and I'm sorry ahead of time..

Have you done a restart of your machine?

Sometimes it helps..

CEWII

The only obvious answer is that there was a bunch of data deleted.

Since this is SQL 2005 I don't think backup compression is available in any version.

CEWII

You could probably edit the XML directly but don't do a replace all, I'd do a replace and look at each one just to be sure but it would still...