In a Data Flow Task use a Flat File Source to read the file and use a Conditional Split Transformation to create an output stream for HR (e.g. RULE_NO ==...

You can set the name of a source file in a Flat File Connection Manager and the table name in an OLE DB Destination dynamically using variables and Expressions. As...

Sounds like a solid plan. Is it true that claim to claim_summary will be a 1 to 1, i.e. you're just offloading some columns from claim into this new table...

sqlfriends (1/31/2013)

---

Is there a simpler way to get what exactly SQL server usage of memory on the server except using perfmon?

I mean the memroy SQL server uses not the other...

Thanks. Not sure if you are aware but you'll want to watch out for entitization when using the XML method.

Search for 'entitized' on this page for some details and tested...

If you're talking about installing a SQL 2008 instance on the machine where your SQL 2005 instance resides then you will need to give the SQL 2008 instance a different...

Thanks.

Here is the link in a more usable form:

http://www.sqlazure.co.il/2013/01/monitoring-aws-rds-for-sql-server-vs.html

And here is an article on how to watch a directory for incoming files using a Script Task.

Using the Script Task in SSIS to Process Data Files When They Arrive[/url]

The...

Also know that the min server memory option does not force SQL Server to instantly allocate the amount of memory specified by the setting. After it has allocated that amount...

What do you mean by filtered? SQL Browser listens on UDP 1434 if the service is enabled. Is the service enabled and set to auto-start when the machine starts?

You must have something else going on in the code on your side that you were not showing in your example. Here is your example with the SET statement commented...

@Jared, where did you land on the code review? Are you sending the code back for refactoring using officially supported techniques?

It was my pleasure. I am in Denver, CO and do not expect to be out that way in the near future but that's a heck of a nice offer,...

Thanks for posting back! This thread bugged me because the symptoms simply did not compute based on the information on hand. Nice detective work. It's nice to know there were...

This one was actually directed to you Richard, just wondering if you were on the latest build. Jonathan seemed to imply there might...