SQL Server Question

[MarillionFan]

I have a VBScript in DTS that checks files and returns me their timestamps. This is so I can make sure I dont process the same file more than once.

How can I return the timestamp and filename into a table I have designed.

I have a Global Variable which the Script sets. Then I have a Exec SQL Statement which uses an insert into. How do I pass the Global Variable to the insert into statement or am I doing this wrong?

Anyone

[To BI or not to BI?]

I have a VBScript in DTS that checks files and returns me their timestamps. This is so I can make sure I dont process the same file more than once.

How can I return the timestamp and filename into a table I have designed.

I have a Global Variable which the Script sets. Then I have a Exec SQL Statement which uses an insert into. How do I pass the Global Variable to the insert into statement or am I doing this wrong?

Anyone

Can you just create the SQL statement inside the ActiveX script? That way you can access the Global Variable

[MarillionFan]

Got it. Had to pass it as a parameter.