Derrick Smith (1/25/2011)

---

I always try to keep my queries as SPs on the database itself, and then reference the SP from the package. Makes maintenance/troubleshooting much easier.

That would also fix...

I'm guessing that there can be a lot of files in this share that you do not wish to process?

An alternative solution may be to nominate a folder on the...

It's an ungainly expression, but as you've nearly got it completed, I guess there's no good reason to try something else.

Have you tried using

DATEPART("hh",GETDATE())

?

What are you trying to do?

What happens once you've verified that the file exists (or not)?

I think the first sentence of the original post

points to your alternative as being the way...

Do the text files all have the same structure (column names, column types and number of columns)?

Have a look here.

A pleasure to help.

No matter what happens to a variable while the package runs, when you look at the variable values in the variables pane, you will always see its initial setting, which...

The ID autogenerates - you should just be able to leave it blank and map to the other two columns, in the knowledge that it will look after itself. Why...

After your data source in the data flow, insert a Derived Column transformation.

Create a new Derived Column and assign your date variable to it.

You will now be able to create...

If you are talking purely about performance, there are many possible factors.

If you...

Why not try both and see for yourself?

I would, however, expect parallel to win...

Have a look here.

Use an expression to set the SQL string which will be executed by the task.

The expression can contain a combination of literal text and variables (system and...