Koen Verbeeck

Forum Replies Created

Viewing 15 posts - 8,776 through 8,790 (of 11,678 total)

RE: How to execute the through SQL Server job?

The second error says it cannot find the Excel file.
* does the Excel file exist?
* if it does, is it locked by some process or user?
* does the SQL Agent...

November 16, 2011 at 3:27 am

#1408331
RE: how to load distinct rows

priya.pk20 (11/15/2011)
HI, i have 7000 rows in my excel file and some of them are repeated rows. i want to transform the data from excel source to oledb destination. to...

November 16, 2011 at 3:23 am

#1408328
RE: Unable to load the Vertipaq Engine

The PowerPivot that comes off the SQL Server installation media is intended for integration with SharePoint. For Excel itself (locally on your desktop), you need to download a plug-in from...

November 16, 2011 at 3:00 am

#1408315
RE: Table variable - 2

Nice question, thanks!

November 16, 2011 at 2:21 am

#1408299
RE: Are the posted questions getting worse?

Got back from a 2-day event from our local PASS chapter (SQLUG.be).
My session on SSIS in SQL Server 2012 went amazingly well (the demo gods were apparently very pleased) and...

November 16, 2011 at 12:18 am

#1408271
RE: SSIS Flat File Import .. If 0.00.. then apply condition

amitabhbose2 (11/15/2011)
Hi Koen,
Many thanks I will give that a go. Would thae expression capture all "0.0" or "0.00*" amounts?
Appreciate your help on this.
No problem, glad to help.
It will...

November 16, 2011 at 12:13 am

#1408269
RE: Is there a degree in Data Warehousing/Business Intelligence?

chris duffield (11/15/2011)
There is a MSc from Dundee University which can be taken part-time (mostly remotely).
http://www.dundee.ac.uk/postgraduate/courses/business_intelligence_msc.htm
Tony Rogerson (http://www.sql-server.co.uk/) is currently finishing his dissertation.
Oink. £14000 if you're from abroad.
No thanks...

November 16, 2011 at 12:09 am

#1408266
RE: Dynamically creating Excel files in SSIS does not create the right datatype

The data inside the dataflow, does it have a date datatype?

November 16, 2011 at 12:01 am

#1408263
RE: Excel Export Columns with Numbers have Green triangle in the upper-left corner of a cell

Welsh Corgi (11/14/2011)
I should have been more clear and not assumed that everyone was familiar with the US Postal Service (USPS) Zip Code convention.
The USPS has 5 Digit Zip Codes...

November 15, 2011 at 11:58 pm

#1408260
RE: Are the posted questions getting worse?

Ninja's_RGR'us (11/15/2011)
jcrawf02 (11/15/2011)
Hey, I like the condensed version of The Thread...
Same here.
No offense if I forgot anything else. I didn't reread the whole 2 weeks either :hehe:.
Hmmm, if I...

November 15, 2011 at 11:49 pm

#1408259
RE: how to append a dynamic filename to exported file in SSIS?

jhowe3 (11/14/2011)
what i've ended up doing is storing the information that i need and then using a sql statement to concatenate the columns to create a filename, how can I...

November 15, 2011 at 11:28 pm

#1408256
RE: SSIS execution error

If you change the protection level to DontSaveSensitive and keep the configuration file (which has the sensitive info), does it work?

November 15, 2011 at 11:24 pm

#1408255
RE: Excel Export Columns with Numbers have Green triangle in the upper-left corner of a cell

Welsh Corgi (11/14/2011)
Koen Verbeeck (11/14/2011)
What datatype has the numeric column in the SSIS dataflow?
Converting to a Unicode String [DT_WTSR] in a Data Conversion Task.
Since I posted this believe that it...

November 14, 2011 at 12:59 pm

#1407495
RE: SSIS SCENARIO

What have you configured as the row delimiter in the flat file connection manager?

November 14, 2011 at 3:10 am

#1407015
RE: Stairway to MDX - STEP 4: The Order() Function: Beyond Cube Hierarchies

Great article, thanks!

November 14, 2011 at 2:40 am

#1407002

Viewing 15 posts - 8,776 through 8,790 (of 11,678 total)