You must create a scheduled job that logs into the FTP site and checks to see if the file exists usining FTP directory commands.

You cannot output columns that are not in the GROUP BY unless they are in an aggregate function... read Books Online for the proper use of GROUP BY.

I strongly suspect that the only mod that has been done is the number of rows have increased. 2.5 million rows is right at the threshold of the "tipping...

No... they are not necessary. When the format of the file changes, then you know there is a change. Headers are not necessary in fixed format.

Before you do anything, you must determine exactly what changed... and, trust me, something changed. Things...

icata (1/11/2008)

---

Thanks, I am working to implement a software package that creates a database per client, with a target of more then 1500 clients.

From what I found so far...

Heh... everyone forgets a couple of the most important tools you could ever have in you DBA toolbelt...

A full up copy of MS Office Pro so that you can test...

The user that the SQL Service logs in as, must have permission to "see" the share.

I think the big problem here is that, like the old "GWBasic" and "BasicA", VBS is "interpretive" rather than compiled code... makes it pretty slow and that's another reason why...

And, this is a forum... not online help... don't be so rudely impatient, please.

Ghanta Bro (3/28/2006)

---

I guess the best way is creating a template, formatting the column with leading zeros as text and then using the template. But then I have to do...

Thanks for the feedback on what you did.

Heh... I sometimes forget just how lucky I am... we "clone" the database everynight at midnight to a "do what you want, users"...

Now, that's a pretty good idea. Thanks, Steve.

I agree that they shouldn't be abuse or cursed at... heh... just quietly fired 😀

Karthik,

You, of all people, should know better... get onto the Microsoft web site and look for "What's new in" each of the different versions. Do some of your own...