Jeff Moden (8/27/2013)

---

Glad some things never change.

I edited my post without realizing that you had responded. Isn't there some "For Each" loop that can get and loop through files...

DTEXEC /f "c:\myPackage.dtsx"

What is the error that you get?

Too easy question, but nice discussion. 🙂

Jeff Moden (8/27/2013)

---

Koen Verbeeck (8/26/2013)

---

rocky_498 (8/26/2013)

---

Thanks, that was I was thinking....

I am thinking how about If I get Recent file name from folder?

Is anyone can please guide me how i...

You need to configure that in the package itself, not in the command prompt.

The package will automaticallly retrieve the value from the environment variable and search for the corresponding XML...

To change the 8 rows lookup, you need to modify the registry key TypeGuessRows of the ACE OLE DB provider.

(there's a link in my signature with more info, but unfortunately...

Did you try running in 32-bit?

Seems fine to me. All nice set-based operations 🙂

rocky_498 (8/26/2013)

---

Thanks, that was I was thinking....

I am thinking how about If I get Recent file name from folder?

Is anyone can please guide me how i can recent file name...

Claudio Pinto (8/26/2013)

---

Thank you SSChampion, how can i adjust your advise in the following sentence where i only can get the MIN one, not really what i am looking for...

I'd try something like this:

WITH CTE_PhoneStartsWith6 AS

(

SELECT site, Name, cs_seqno, phone

WHERE phone LIKE '6%'

)

SELECT site, Name, cs_seqno, phone FROM

(

SELECT site, Name, cs_seqno, phone, RID = ROW_NUMBER() OVER (PARTITION BY site...

You are trying to insert duplicates.

Check the source data and your code to make sure you are not duplicating rows somewhere.

Regarding the script you posted (while I was typing my previous reply), you don't use the INSERTED or DELETED system tables. Those might come in handy.

Seems like an AFTER trigger to me.

Also seems table B is just a copy of table A 🙂

Are you sure you want to use a linked server? Because a .csv file is, you know, a file. Not a server.

Maybe you want OPENROWSET?