[SQL server 2005]

I am using an SSIS package to import a csv into SQL and wandering how to add a date column that pulls the date from an environment variable that is set in a batch process and can be passed to the ssis package when called in that batch.

[Batch Script]

I have a program that parses a csv into other csv files so that they can be imported into sql. The executable prompts when it is complete to hit any key which actually is the enter key that it really wants. I am trying to get around having to change the source code of the program and recompile because of internal costs of doing so.

[Batch Script]

Neither of those tricks worked. Any other ideas?

[Batch Script]

are you saying put a single enter into the text file? A blank line?

[Batch Script]

I have a batch script that calls a program and runs it. The exe wants the user to hit the enter key before quitting and then letting the batch go on. I do not have a pause in the script it the prompt is hard coded into the program. How do I get the script to enter a literal enter key so that it can complete the program and go on with the script?

[Hi]

Hi My name is Dan!