SQL Server Question

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
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!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

MarillionFan replied

21 December 2006, 19:38
Got it. Had to pass it as a parameter.
Leave a comment:
To BI or not to BI? replied

21 December 2006, 17:52
Originally posted by 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

Can you just create the SQL statement inside the ActiveX script? That way you can access the Global Variable
Leave a comment:
MarillionFan started a topic SQL Server Question

21 December 2006, 17:41
SQL Server Question

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
Tags: None