Urgent: File Attributes then import

#1

In SQL 2005, what's the best method to import a file(via an SSIS package or
DTS
that would have a schedule) if that file:
1) Exists
2) Is not empty
3) Is New (and by new that would be newer than 3 days old)

We previously had an activeX script that ran but took advantage of
xp_getfiledetails but that doesn't exist in sql 2005 anymore. Is there an
easy replacement to simply find the attributes of a file in 2005 and then
import based on the date, size, etc?!?

Any help in this would be greatly appreciated.

Thanks,

Jason

#2

FSO would still be a good way to get details about files.

Allan

"Jason @ SCA" <jason.grossman (AT) scf (DOT) sk.ca> wrote

Quote:

In SQL 2005, what's the best method to import a file(via an SSIS package
or DTS
that would have a schedule) if that file:
1) Exists
2) Is not empty
3) Is New (and by new that would be newer than 3 days old)

We previously had an activeX script that ran but took advantage of
xp_getfiledetails but that doesn't exist in sql 2005 anymore. Is there an
easy replacement to simply find the attributes of a file in 2005 and then
import based on the date, size, etc?!?

Any help in this would be greatly appreciated.

Thanks,

Jason

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Urgent: File Attributes then import

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Urgent: File Attributes then import - 07-25-2006 , 10:54 AM

Re: Urgent: File Attributes then import - 07-25-2006 , 01:15 PM