Koen Verbeeck

Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 11,678 total)

RE: Can SSIS 2012 run against SQL 2014 database?

Grant Fritchey (7/30/2014)
Koen Verbeeck (7/29/2014)
Grant Fritchey (7/29/2014)
As long as we're talking about straight T-SQL commands, you should be fine. If you start trying to access objects directly through SSIS, you...

July 30, 2014 at 5:06 am

#1733516
RE: How to Reduce the Table Size...

Chowdary's (7/30/2014)
Dear Eirikur Eiriksson,
How can i claim my space from that table without doing Compress, Can you pls give me some suggestions..
Regards
Chowdary....
Why is compression not an option? Because of SQL...

July 30, 2014 at 4:59 am

#1733513
RE: DATEADD with aliases?

You can't reference an alias in the same query, except in an ORDER BY clause.
You need to use your select statement inside another one (as an inner query) and reference...

July 30, 2014 at 2:28 am

#1733489
RE: MySQL client ran out of memory issue in ssis package.

asranantha (7/30/2014)
executing package with 32 bit.
Try to get it in 64-bit, if you have a 64-bit ODBC client for MySQL.

July 30, 2014 at 1:09 am

#1733476
RE: MySQL client ran out of memory issue in ssis package.

Are you executing in 32-bit or 64-bit?

July 30, 2014 at 12:50 am

#1733471
RE: SSRS 2012 have Issue with Preview

Why do you run VS with RunAs?

July 30, 2014 at 12:33 am

#1733469
RE: Execute Package Task failing even though dtsx package it calls had a failure that was corrected

Take a look at this blog post: Continue Loop after error - Part II.

July 30, 2014 at 12:32 am

#1733468
RE: How to Reduce the Table Size...

If you have Enterprise edition, you can enable page compression.

July 30, 2014 at 12:29 am

#1733467
RE: table variable declaration inside a loop

Nice question, thanks.

July 30, 2014 at 12:27 am

#1733466
RE: Common encountered errors in SSIS

Velym (7/29/2014)
Thanks for those!
Can someone give me an example scenario with an occurring deadlock? I have not encountered this so far - so I'm not sure on how to tackle...

July 30, 2014 at 12:24 am

#1733465
RE: One a Week

SQLRNNR (7/29/2014)
Koen Verbeeck (7/29/2014)
SQLRNNR (7/29/2014)
Koen Verbeeck (7/29/2014)
GilaMonster (7/29/2014)
Koen Verbeeck (7/29/2014)
From time to time they organize some evening sessions, but lately they seem to have trouble finding speakers.
Are you open to...

July 29, 2014 at 1:22 pm

#1733367
RE: One a Week

SQLRNNR (7/29/2014)
Koen Verbeeck (7/29/2014)
GilaMonster (7/29/2014)
Koen Verbeeck (7/29/2014)
From time to time they organize some evening sessions, but lately they seem to have trouble finding speakers.
Are you open to remote speakers?
I'm not...

July 29, 2014 at 12:05 pm

#1733348
RE: One a Week

GilaMonster (7/29/2014)
Koen Verbeeck (7/29/2014)
From time to time they organize some evening sessions, but lately they seem to have trouble finding speakers.
Are you open to remote speakers?
I'm not a member of...

July 29, 2014 at 11:34 am

#1733336
RE: SSIS on SQL Server 2008R2 "The value is too large to fit in the column data area of the buffer."

gbritton1 (7/29/2014)
Koen Verbeeck (7/29/2014)
Instead of the console line, try a message box perhaps?
Does everything work if you get rid of the script component?
I added calls to MessageBox before each statement...

July 29, 2014 at 11:34 am

#1733335
RE: Can SSIS 2012 run against SQL 2014 database?

Grant Fritchey (7/29/2014)
As long as we're talking about straight T-SQL commands, you should be fine. If you start trying to access objects directly through SSIS, you may hit issues. Forward...

July 29, 2014 at 11:33 am

#1733333

Viewing 15 posts - 2,221 through 2,235 (of 11,678 total)