forsqlserver (9/13/2011)

---

Dear All, Thanks

As you know on servers excel doesn't exist.I have tried it option (Save to file) and saved in .rpt,.csv,.xls,.txt still finally it was opening on my system...

How far have you gotten in SSIS? Connections established and tested? Dataset from the source table created?

Is it possible the stored procedure has multiple result sets, or that the remote server has MARS enabled? (Multiple Active Result Sets = MARS)

In either case, it will work...

This is an SQL Server site, so I'm not sure advice about DB2 will be fully accurate.

Are you using SSIS to do the update? (Asking because that's the specific...

Row_Number() is the most likely solution, as already mentioned.

However, it won't be deterministic if you don't have something in the table that it can Order By. You might get...

NJ-DBA (9/13/2011)

---

No, not your database- the work... when all your jobs succeeded last night, no users are complaining, you've reviewed all your logs, the sqlservercentral forums dont have any interesting...

With that Charindex call in the Where clause, it's always going to be a scan, not a seek. If you have any significant number of rows, it's going to...

I usually just copy-and-paste into Excel for that kind of thing.

jagat.patel (9/12/2011)

---

Thanks for your Help

This is not Homwork.

I I have similar Business rqeuirement . and to get answer from foram readers I just simplify my xml.

My original XML is really...

You've got a bit of a problem in that Node2 should either have a direct value or sub-values, but it can be compensated for with an IsNull/Coalesce function call.

The query...

In the data flow, between the source and the destination, you can put a Derived Columns object, and you can map variable values into columns in that.

SELECT *

FROM OPENROWSET(BULK 'MyFilePathAndName', FORMATFILE='MyFormatFile', LASTROW=4) AS MyFileImport ;

That's a sample. You'll need an actual file and an actual format file. There are samples of format files that...

meichner (9/12/2011)

---

Can I take...

The OpenRowset function (details here: http://msdn.microsoft.com/en-us/library/ms190312.aspx) allows you to assign first and last rows for imports using it.

Will it always be four dates in every file, or does it vary?

Welsh Corgi (9/12/2011)

---

Ninja's_RGR'us (9/12/2011)

---

Welsh Corgi (9/12/2011)

---

My observation is that there are lot of people posting their Homework Assignments.

It is so obvious that they are not real world problems. They are...