Thanks for the kind words:), though I would be much happier if that can be fixed at the base itself.

Yes, you can. Just add the sign "$" after the sheet name in the query, for e.g.

SELECT * FROM [Customer$]

WHERE "Customer" is the name of the sheet...

Or you could do something like....

SELECTi.rows

FROM[linkedserver].[linkeddb].dbo.sysindexes i

INNER JOIN [linkedserver].[linkeddb].dbo.sysobjects o ON i.id = o.id

WHEREo.name = 'HereGoesTheTable'

AND i.indid < 2

Jeff Moden (1/19/2009)

---

Ramesh (1/18/2009)

---

I would like to share my thoughts on the need of such rules.

I have the punch/swipe card data imported from some other system in the following format...

EmployeeNo,...

Assuming that this is your actual table design, there are some major flaws in your table design.

1. It is not in any of the defined normal forms. ...

Actually, I never had to do something like this...., so I won't be able to help you much, but there are some options like...

1. You can cipher the code using...

GilaMonster (1/18/2009)

---

That's actually not that hard, providing it's impossible to have two sequential in's or out's and the first entry is going in.

Pseudocode:

SELECT * FROM

(SELECT *, ROW_NUMBER OVER (PARTITION BY...

I would like to share my thoughts on the need of such rules.

I have the punch/swipe card data imported from some other system in the following format...

EmployeeNo, CardReaderNo, CardReaderType, PunchDateTime

E1,...

I don't think so it holds in all cases, especially when...

Basically, what you need is

1. Two configuration variables for source & archive directory and three internal variables to hold file name, source file path & archive file path.

2. One For...

SQL Server Agent is visible only to users which have the adequate permission, you can check it by login with an account having admin permissions.

See this excerpt from books online...

"Click...

1. Its always better to keep only the dynamic variables in configurations than all of the internal variables.

2. The configured variables are always populated before starting the execution...

1. You need 1 Data Flow Task, containing an EXCEL source Connection and a SQL destination connection

2. Script Task to get list of sheets within the excel file

3. For...

Hey Gail, firstly thank you very much for taking time in explaining me the concept and providing me with a working example.

Secondly, you were right, it does provide the same...

I think the queries 1 & 2 are similar, so I'd bet on both & more on 1..., 3 is out of question here for me.:)