Viewing 15 posts - 3,361 through 3,375 (of 14,953 total)
forsqlserver (9/13/2011)
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...
September 14, 2011 at 5:18 am
How far have you gotten in SSIS? Connections established and tested? Dataset from the source table created?
September 13, 2011 at 9:31 am
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...
September 13, 2011 at 9:29 am
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...
September 13, 2011 at 9:25 am
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...
September 13, 2011 at 9:09 am
NJ-DBA (9/13/2011)
September 13, 2011 at 9:06 am
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...
September 13, 2011 at 6:59 am
I usually just copy-and-paste into Excel for that kind of thing.
September 13, 2011 at 6:33 am
jagat.patel (9/12/2011)
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...
September 13, 2011 at 6:29 am
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...
September 12, 2011 at 1:31 pm
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.
September 12, 2011 at 11:39 am
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...
September 12, 2011 at 11:37 am
meichner (9/12/2011)
Welsh Corgi (9/12/2011)
@meichner,I meant that you were not going to get shot. :hehe:
I feel for you for you are in a tough situation. Been there done that.
Regards
Can I take...
September 12, 2011 at 11:34 am
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?
September 12, 2011 at 11:27 am
Welsh Corgi (9/12/2011)
Ninja's_RGR'us (9/12/2011)
Welsh Corgi (9/12/2011)
It is so obvious that they are not real world problems. They are...
September 12, 2011 at 8:42 am
Viewing 15 posts - 3,361 through 3,375 (of 14,953 total)