Koen Verbeeck

Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 11,678 total)

RE: Create Stored proc in SSIS package

Andre 425568 (6/5/2014)
Koen
How exactly would you do that?
You can store the statement in a .sql file and create a file connection to it in SSIS.
In the Execute SQL Task, you...

June 6, 2014 at 12:10 am

#1719535
RE: Just curious, what are your SQL pet peeves ?

Luis Cazares (6/5/2014)
As most things, it depends.
According to my education, America is a single continent divided in four regions: North, Central, South and Caribbean. According to the US education, North...

June 6, 2014 at 12:10 am

#1719534
RE: Just curious, what are your SQL pet peeves ?

below86 (6/5/2014)
How about doing data transformations in the ETL process. I know that's what the 'T' stands for. I can see changing date formats to work in SQL....

June 6, 2014 at 12:06 am

#1719532
RE: Just curious, what are your SQL pet peeves ?

Luis Cazares (6/5/2014)
Koen Verbeeck (6/5/2014)
SQL is delicious (6/5/2014)
...also labors under the delusion that the American education system is worthless and that our master's level work is the equivalent of junior...

June 6, 2014 at 12:03 am

#1719530
RE: Parameter bar does not change when returning to main report from subreport

Raul Undreiner (6/5/2014)
Navigates to the subreport using a link from one of the textboxes in the table. We are using SharePoint 2003 so it might be a version problem but...

June 6, 2014 at 12:01 am

#1719529
RE: Need help to build a query.

manju00005 (6/5/2014)
select name,dept, punchdate ,status from Table_name
where name='robin'
select name,dept, punchdate ,status from Table_name
where name='Alex'
The original question was about formatting, not about how to select the data.

June 5, 2014 at 11:59 pm

#1719527
RE: Just curious, what are your SQL pet peeves ?

SQL is delicious (6/5/2014)
...also labors under the delusion that the American education system is worthless and that our master's level work is the equivalent of junior high/early high school material...

June 5, 2014 at 1:23 pm

#1719431
RE: DTUTIL to deploy a package

Kwisatz78 (6/5/2014)
OK your article says:
In SSIS 2012, the unit of deployment is a project. This lets you deploy everything at once: all the packages, parameters and connection managers. This...

June 5, 2014 at 1:16 pm

#1719429
RE: passing variables in a Foreach loop container

Maybe post some screenshots Tuesday, so I can see what is going on.

June 5, 2014 at 11:06 am

#1719352
RE: create proc problem

Sean Lange (6/5/2014)
I ran this through a code formatter...
Are you sure? 😀

June 5, 2014 at 11:05 am

#1719351
RE: DTUTIL to deploy a package

Kwisatz78 (6/5/2014)
Oh, so whats the best way to deploy a package to an existing project in SSISDB?
There are a few options:
SSIS Deployments with SQL Server 2012[/url]

June 5, 2014 at 11:03 am

#1719350
RE: Just curious, what are your SQL pet peeves ?

SQL is delicious (6/5/2014)
On the subject of WITH (NOLOCK) in code being a pet peeve....
I was going over an SSIS template with a consultant the other day, and there was...

June 5, 2014 at 7:49 am

#1719231
RE: How can I cut certain values in a strig to separate columns

Do you have a fixed amount of languages?

June 5, 2014 at 7:46 am

#1719229
RE: Create Stored proc in SSIS package

Is it an option to store the statement in a file and use that in an Execute SQL Task.
(not sure it beats the limit though)

June 5, 2014 at 7:44 am

#1719225
RE: Just curious, what are your SQL pet peeves ?

SQLRNNR (6/5/2014)
GilaMonster (6/5/2014)
Koen Verbeeck (6/5/2014)
GilaMonster (6/5/2014)
thomashohner (6/5/2014)
What is the preference on column aliases ?
AS. Equals sign is for comparing values or assigning values. 😀
Yes, you assign the result of the...

June 5, 2014 at 7:42 am

#1719224

Viewing 15 posts - 2,791 through 2,805 (of 11,678 total)