• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

SQL Server Question

MarillionFan

My post count is Majestic
Joined
Jul 6, 2005
Messages
36,255
Likes received
2,931
Thanks received
767
Location
.
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
 
MarillionFan said:
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
 

Advertisers

Back
Top