Koen Verbeeck

Forum Replies Created

Viewing 15 posts - 10,321 through 10,335 (of 11,676 total)

RE: Exporting all SQL tables to txt file

espanolanthony (1/27/2011)
I have a SQL 2005 database. I have almost 100 tables in that database. Now I would like to Make a csvor txt file for each table. How do...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 27, 2011 at 1:36 pm

#1279357
RE: Get Most Recent One Table; JOIN and WHERE On Other Table

Allright, I took a try at your problem.
I haven't tested it yet, but when you post the DDL statements and the INSERTS statements for sample data, the statement will be...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 27, 2011 at 1:28 pm

#1279353
RE: Get Most Recent One Table; JOIN and WHERE On Other Table

daniel.potter (1/27/2011)
I apologize for the formatting, I've looked on the site to try to figure out how to post a table on the forums properly (If someone could give me...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 27, 2011 at 1:18 pm

#1279349
RE: using conditional split how to load from source to destination table where the condition is null or blank to a particular column

jyothi_siri2000 (1/27/2011)
using conditional split how to load from source to destination table where the condition is null or blank to a particular column
Use 2 conditions:
one that checks if the column...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 27, 2011 at 1:08 pm

#1279338
RE: How to call the Deployed packages(MSDB) using DTEXEC in SQL Agent jobs

You'll have to use the dtexec utility in the exec cmd step.
Since you are uploading an Excel file, the package should probably run in 32-bit mode, so make sure you...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 27, 2011 at 1:06 pm

#1279336
RE: Data Driven Subscription

Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 27, 2011 at 3:04 am

#1278968
RE: Display More Than 8000 Characters (SQL Spackle)

Thanks, great article Jeff.
You find uses for the Tally table everywhere, don't you 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 27, 2011 at 3:02 am

#1278967
RE: Are the posted questions getting worse?

Trey Staker (1/26/2011)
I guess I'll appologize for being too sensitive. Again, Scientology isn't my religion but I do belong to a religion that does get bashed a lot. ...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 26, 2011 at 11:48 am

#1278688
RE: Are the posted questions getting worse?

Elliott Whitlow (1/26/2011)
Sometimes I just have to ask.. Really?
http://www.sqlservercentral.com/Forums/Topic1053904-338-1.aspx
But... already 2 pages for a seemingly easy question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 26, 2011 at 11:44 am

#1278686
RE: Are the posted questions getting worse?

Trey Staker (1/26/2011)
Stefan Krzywicki (1/26/2011)
Elliott Whitlow (1/26/2011)
Gianluca Sartori (1/26/2011)
Funny. I always thought that Hubbard had written Scientology related books. Looks like this one is focused on other topics.
I read that...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 26, 2011 at 11:43 am

#1278685
RE: Are the posted questions getting worse?

CirquedeSQLeil (1/26/2011)
Getting caught up
I was already wondering why my mail inbox was suddenly spammed with "the thread notifications". 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 26, 2011 at 11:42 am

#1278683
RE: DATALENGTH

PSB (1/25/2011)
I have a staging table with different number of records each time loaded. But the datalength of the single colom is always same e.g 100.
I need to check...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 26, 2011 at 5:12 am

#1278409
RE: CSV import fail when set as sql job

Dan-Ketil Jakobsen (1/26/2011)
Hi Steve
Yes the user for sql agent is the same as my login user to both the sql server and the file server.
Dan
Did you use a proxy account?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 26, 2011 at 5:10 am

#1278408
RE: Error in query in SSIS

pwalter83 (1/26/2011)
I am working on SSIS and this question is related to that only.
It is not because you are working with SSIS that you only have SSIS question. SSIS is...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 26, 2011 at 5:08 am

#1278407
RE: Auto growth

bhargavgampala (1/26/2011)
Thank you so much .Your support is appreciated.
After checking disk usage report, we think that growing respectively 200 Mb for DATA file and 60 MB for LOG .
so...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 26, 2011 at 3:56 am

#1278385

Viewing 15 posts - 10,321 through 10,335 (of 11,676 total)