dennis.hafstrom (3/13/2012)

---

Unless I am mistaken he had year and month separated so it wouldn't work checking for it until they are...

Euh...

keep the...

Krtyknm (3/13/2012)

---

Here MonthName is a parameter where i can select the month. For example if you get the details of sales for the month of Feb, then you can select...

A simple SELECT that should work on every SQL Server database:

SELECT TOP 12

MonNum= ROW_NUMBER() OVER (ORDER BY sc1.NAME desc)

,MonthName= DATENAME(MONTH,DATEADD(MONTH,ROW_NUMBER() OVER (ORDER BY sc1.NAME desc),0)- 1)

FROM Master.dbo.SysColumns sc1

Although I'm...

This is a good blog post to start with:

SSIS: Custom Logging Using Event Handlers

Why are you using SSIS for this? This is the wrong tool for the job, SSIS is used to transfer and manipulate data, not fiddle around with macro's.

Can you be a bit more specific here?

It's like going to the garage with your car and say to the mechanic:

"Car doesn't...

bitbucket-25253 (3/12/2012)

---

What I thought was a nice straigt forward simple question, the results are discouraging in the number of...

There's a...

You could use the Lookup component to determine of a row is an insert or an update.

Also check if the account has permission on the folder that contains the SQLAgent.out log file.

If it can't write to that log file, the service won't start.

I can't see the images here at work, so it's a bit hard to understand the configuration.

Is it really important that an order is preserved?

In short, the point of full text indexing is to create a catalog and a full-text index on your tables.

Using this full-text index, you can use the TSQL function CONTAINS...

Full-Text Search (SQL Server)

Look into the LIKE clause or into Full-Text indexing.

p.s. your caps lock is broken