tmcdermid (11/18/2010)

---

Here's how I'd design it:

1. Create a simple "control" table in SQL.

....

The above will allow you to keep each package very simple - each package only processes one...

sqlrunner (11/18/2010)

---

Rob,

I have a question. How many different transformations do you have? That is to say, of the '100' different incoming files, how many SSIS packages...

Here's the scenario I'd like to be able to create with SSIS -- similar to what I know I can do in a C# app:

1) I'd begin monitoring a folder,...

Looks to me like it ought to work.

Any possibility you're using a case-sensitive collation on the database (or that column) that would cause 'gbp' and 'GBP' to not match?

I think we need a little more information:

-- what are column names?

-- is there some sort of ID column?

-- what data type is the field that can...

Lynn,

That's brilliant. And just what I needed.

Thanks!

This is a common way...

Wow -- Lowell beat me to the response. At least we came up with the same answer!

Joe,

I see two issues here.

First, you can't use an expression for a column alias. The query compiler will not evaluate your expression prior to its trying to execute the statement....

You can't do what you want to do on just a "plain" query stored in a file or keyed in, but...

You can (and should) create a stored procedure to contain...

Does that network location actually exist? (i.e., are the folders already present?) Can it be reached successfully from the machine on which SQL is running? Does the account you and/or...

You can do this with the ReportViewer control that ships with .NET/VS. Create your .aspx page, drop a ReportViewer control on it (lives under the Data tab in the Toolbox...

Great question.

WayneS (10/16/2010)

---

I just read through this thread, and what I found interesting was what was missing (or, I just failed to see it...)

The keys in a clustered index are used...

The GUIDs are generated by client side apps (.NET/C#) in an application that has been running smoothly for a couple of years now -- I don't think the developers would...