Viewing 15 posts - 316 through 330 (of 1,229 total)
And of course let me not forget... In SSMS you can simply type CTLR+SHIFT+F and that will put the results of the query to a file you define at run...
January 13, 2017 at 1:00 pm
To export a column to a file>
I took this example from
http://mytechmantra.com/LearnSQLServer/How-to-Export-records-from-SQL-Server-to-Text-File-using-BCP/
EXEC xp_cmdshell 'bcp "SELECT Name FROM [AdventureWorks2012].[Person].[CountryRegion]" queryout "C:\Temp\CountryRegion.txt" -T -c -t '
January 13, 2017 at 12:55 pm
The place where I know the dimension key(s) are defined is when creating the dimension through the wizard. I choose 'use an existing table' and select the date dimension from...
January 13, 2017 at 12:22 pm
January 13, 2017 at 11:33 am
Not sure what you mean by "the language of your SQL". You mean if it is ANSI compliant? Is your data source something other than SQL Server?
January 12, 2017 at 7:28 pm
adonetok (1/11/2017)
January 12, 2017 at 4:28 pm
Since you are pulling from a URL, have you tried studying the Web Services task in SSIS 2008? I have not touched it in a while so don't want to...
January 12, 2017 at 4:10 pm
January 12, 2017 at 4:02 pm
It is as far as the end result being deterministic and resulting in NULL. I thought that was the scope here since your/our statement(s) will not even execute in SQL...
January 10, 2017 at 1:18 pm
Hmm, which is why you have to read the context. If people are blindly pulling code they don't understand, then they are the ones choosing to take risk. If they...
January 10, 2017 at 12:42 pm
Brandie Tarvin (1/10/2017)
MMartin1 (1/10/2017)
drew.allen (1/10/2017)
MMartin1 (1/9/2017)
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL...
January 10, 2017 at 12:16 pm
drew.allen (1/10/2017)
MMartin1 (1/9/2017)
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL ELSE NULL END
...
January 10, 2017 at 11:51 am
Is this a dev or prod environment? If dev is it possible others could be publishing then removing the reports as modifications go?
January 9, 2017 at 6:58 pm
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL ELSE NULL END
?
same logical...
January 9, 2017 at 6:46 pm
If you are using a OLE DB destination adapter in the data flow then you can also tinker with the "Rows per patch:" or the "Maximum insert commit size:" options...
January 9, 2017 at 6:07 pm
Viewing 15 posts - 316 through 330 (of 1,229 total)