Viewing 15 posts - 7,786 through 7,800 (of 13,882 total)
Have you also considered using a script task? It might be the most elegant solution in this case.
December 28, 2015 at 7:56 am
Ok thanks. Have you considered creating an appropriately indexed 'working' table to hold the results?
I'd suggest including a date created column.
Then your package logic becomes
1. Should I recreate results? (Based...
December 28, 2015 at 7:52 am
ram1447 (12/28/2015)
hi all,Is the memory used by SSIS independent of SQL server Engine?
Yes, as far as I know. SSIS packages are executed by dtexec.exe, which is separate from the other...
December 28, 2015 at 7:43 am
Solomon Rutzky (12/26/2015)
Eric M Russell (12/23/2015)
The only practical use for CLR in a data warehouse that comes to mind is perhaps a custom aggregate function.
Just out of curiosity, what exactly...
December 26, 2015 at 3:33 am
Welsh Corgi (12/24/2015)
SELECT *
FROM PrismDataArchive.dbo.tblcallArchive AS arc
LEFT JOIN PrismData.dbo.tblcall AS Pri ON arc.Call.ID = Pri.Call_ID
WHERE PrismData.dbo.tblcall Pri.Call_ID IS NULL
Msg 4145, Level 15, State 1, Line 13
An expression...
December 24, 2015 at 8:57 am
Looks like you fixed the typo.
But telling us that you "can't get it to work" is inviting caustic responses. What is the error you are getting now?
December 24, 2015 at 8:20 am
brad.mccollum (12/23/2015)
December 23, 2015 at 11:39 am
Re1 (12/23/2015)
I am doing one POC. I am trying to generate and execute a dynamic sql. In that dynamic sql i have to many replace functions.At the time of...
December 23, 2015 at 11:35 am
lmarkum (12/22/2015)
December 22, 2015 at 12:20 pm
Sean Lange (12/22/2015)
Lynn Pettis (12/22/2015)
I really hope there is someone else...
December 22, 2015 at 9:58 am
Alvin Ramard (12/22/2015)
Phil Parkin (12/22/2015)
Sean Lange (12/22/2015)
Phil Parkin (12/22/2015)
It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-DI prefer making sawdust as my form of therapy.
Plugging...
December 22, 2015 at 7:54 am
Are you suggesting i use the DAC to get into the sql intance to identify whats killing it while it's happening?
Just an idea which may help your troubleshooting, yes.
December 22, 2015 at 7:51 am
Sean Lange (12/22/2015)
Phil Parkin (12/22/2015)
It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-DI prefer making sawdust as my form of therapy.
Plugging in my guitar and...
December 22, 2015 at 7:28 am
Snargables (12/22/2015)
December 22, 2015 at 7:26 am
Viewing 15 posts - 7,786 through 7,800 (of 13,882 total)