If the database is small enough, you could script out all of the data -- right click on DB in SSMS and chooses Tasks, Generate Scripts. Then run that...

In MS Excel, do a File, Save As, and choose the CSV (Comma delimited) (*.csv) choice. This will convert the particular sheet from .xls or .xlsx to a .csv...

Is this a one time load? If so, just save this particular sheet as a .csv file and load the flat file into your SQL table using SSIS. ...

Not knowing many specific details, I'd say yes, use SSIS on the server to do the pieces that make sense there.

You can have your .Net application start a SQL Server Agent job that runs the SSIS package(s). Create a SQL Agent service account on the server that has the...

I'm not totally following you, but it sounds like you may be getting transactions and need to apply these changes to your data warehouse. Could you do something like:

1)...

Another incorrect question; point please.

The second insert; inserts one record before the PK violation. The second SELECT returns back one.

So the answer is error, error, 0 & 1.

Rob

What's the business need for knowing that something was inserted and updated on the same day?

(I may be making assumptions,but ) It sounds like you're building/updating your data...

Is this a one time load, or a reoccuring task? Is the date embedded within the first four lines, or are they complete lines. Could you post some...

imani_technology (9/8/2011)

---

I'm trying to deal with 3 different scenarios listed below. I would like to do it using a conditional split (not an SCD). Is it even possible?...

Maxer (9/6/2011)

---

I'm reading Kimball's: The Data Warehouse Toolkit The Complete Guide to Dimensional Modeling (2nd ed).

So I'm only a little ways in and we are talking about dimensions for a...

sunnyepgc (8/31/2011)

---

Hi,I am getting the below error when i schedule to run my ssis package from production.

Error:The underlying connection was closed: An unexpected error occurred on a receive.

I am...

It looks like someone or some other process has the Access db (.mdb) already opened. Is there a .ldb (lock file) in the same directory? If nothing has...

Make sure you are using C# (the code I gave you) as opposed to VB.Net -- this is set in the Tools, Options of VS.

The error is saying it can't...

Just select the variable ( @[User::MaxDate] ) you want to display in the ReadOnly variables -- you're not going to update it, just display it.

Then click on the Edit Script...