Viewing 15 posts - 5,281 through 5,295 (of 8,761 total)
snoqualmiewa (5/16/2015)
No not yet. I have been randomly entering package ID's which didn't work? How do I identify a SSIS Package Id on Sql Server? Thanks
Suggest you start by reading...
May 16, 2015 at 4:06 pm
GilaMonster (5/16/2015)
Eirikur Eiriksson (5/16/2015)
a) SQL Server 2008 is a rather old product, consider SQL Server 2014 or 2016 as that will already give you some advantage.Um....
Point being that if...
May 16, 2015 at 4:02 pm
Quick thought, try import the data rather than opening the file with "file open"
😎
May 16, 2015 at 3:58 pm
GilaMonster (5/16/2015)
Jeff Moden (5/15/2015)
afw (5/15/2015)
Aah, makes sense. But boy was I getting that wrong...Thank you once again 🙂 🙂
My Dad has a saying about such things.
"Half of what is...
May 16, 2015 at 3:52 pm
born2achieve (5/16/2015)
Hi Eirik,This is excellent approach and did clean almost. Thank you very much Gentle Man!!!.
You are most welcome.
😎
May 16, 2015 at 3:14 pm
tshad (5/16/2015)
It didn't seem to in my solution after I added the...
May 16, 2015 at 3:13 pm
dick.vanderweed (5/15/2015)
I am teaching myself MS SQL Server 2008 for work purposes. I have a background in programming but not DB Administration. I am done with youtube tutorials...
May 16, 2015 at 3:08 pm
Jeff Moden (5/15/2015)
afw (5/15/2015)
Aah, makes sense. But boy was I getting that wrong...Thank you once again 🙂 🙂
My Dad has a saying about such things.
"Half of what is written...
May 16, 2015 at 2:50 pm
shivakumar.623 (5/14/2015)
My database was crashed then How to identified in particular server particular database was crashed
Quick question, (and piling on the previous questions) can you tell us what you mean...
May 16, 2015 at 2:47 pm
Further on Gail's answer
😎
DECLARE@SortOrder VARCHAR(100),
@SortDirection VARCHAR(100)
SELECT @SortDirection = 'ASC'
SELECT @SortOrder = 'ExpirationDate' --'DocumentName' --NULL --'DocumentName'
--SELECT @SortOrder = '[Year]'
--SELECT @SortDirection = 'ExpirationDate'
IF OBJECT_ID(N'tempdb..#TEST') IS NOT NULL DROP TABLE #TEST;
CREATE TABLE #TEST
(
DocumentName...
May 16, 2015 at 2:19 pm
Still waiting for an answer to the question Why?
😎
May 16, 2015 at 2:05 pm
Another approach, not perfect but not bad either;-) Additional metrics can be used to enhance the logic.
😎
USE tempdb;
GO
SET NOCOUNT ON;
;WITH BASE_DATA AS
(
SELECT
...
May 16, 2015 at 2:01 pm
Jeff Moden (5/14/2015)
Candidate: I don't. It's just that everyone else sucks so bad that I end up...
May 16, 2015 at 1:40 pm
Grant Fritchey (5/15/2015)
May 16, 2015 at 1:37 pm
snoqualmiewa (5/16/2015)
The insert statement in page 294 fails (SQL Server 2014 Integration Services text by Brian Knight). Any Ideas what data should be entered for the PACKAGE ID? Thanks
INSERT INTO...
May 16, 2015 at 1:32 pm
Viewing 15 posts - 5,281 through 5,295 (of 8,761 total)