Douglas Laudenschlager - All Comments

re: See all the SSIS new articles, videos, & samples from Microsoft

Rafael Salas — Wed, 19 Nov 2008 07:49:02 GMT

Great deal Doug, I hope you keep this list updated.

re: Your vote on Microsoft Connect influenced SQL Server 2008 Service Pack 1

dougbert — Sun, 16 Nov 2008 21:37:18 GMT

NO NEW FEATURES IN SERVICE PACKS is the current policy of the Microsoft SQL Server product team. That's why the 1st step in looking at Connect bugs for SP1 was to set aside DCRs (Change Requests), and to focus on defects.

Someone with the mindset of a Dilbert reader, however, might assume that wily critters are already looking for ways to climb over, tunnel under, sneak around, or chew a hole through a policy of that nature. "It's not a new feature, it's a bug fix!"

re: Your vote on Microsoft Connect influenced SQL Server 2008 Service Pack 1

Todd McDermid — Sun, 16 Nov 2008 21:24:54 GMT

Can you tell us if there will be any features added to SP1? (And what's a DCR?)

re: DTS support in SQL Server 2008 "Katmai"

dougbert — Fri, 14 Nov 2008 21:15:24 GMT

The DTS Designer was not designed for or tested on Vista and Server 2008, as you might expect. I believe there are some issues on Vista which are probably carried over now to Server 2008. The SSIS product team is investigating.

re: DTS support in SQL Server 2008 "Katmai"

Lon Ramsey — Fri, 14 Nov 2008 14:43:28 GMT

I appreciate the correction to msdn.microsoft.com/.../ms143755.aspx adding the language subdirectory. I was able to get the DTS designer to work on Windows XP but not Server 2008.

re: New 10-minute how-to videos on Integration Services

Newtothis — Thu, 16 Oct 2008 21:05:03 GMT

Thanks these videos were great. PLEASE do more I just bought an SSIS 2008 book and it is ok but being 800+ pages takes time to get through. These videos show how to maneuver BIDS a lot better than a book can. Thanks and please do some with script transformations if possible someday. gracias!

re: Setting an expression dynamically

Jamie Thomson — Sun, 12 Oct 2008 04:22:44 GMT

Doug,

This is a strange one isn't it? As I said about a while back "The result of the expression has to be, in itself, a valid expression" (blogs.conchango.com/.../SSIS_3A00_-Dataflow-expressions.aspx).

Slighty bizarre really!

-Jamie

re: SQL Server 2008 Feature Pack and Integration Services

dougbert — Thu, 21 Aug 2008 20:51:39 GMT

Here's an adjustment to the last bullet point:

The coming SAP BI connectivity components WILL be released on the Feature Pack Web page.

The Oracle and Teradata components will be released for download on a separate Web page, around the same time.

-Doug

re: The mystery of MULTIFILE

dougbert — Fri, 15 Aug 2008 23:58:18 GMT

Bal,

This is not the best venue for technical questions. I suggest that you get to know the Integration Services forum at forums.microsoft.com/.../ShowForum.aspx.

Your solution will require an SSIS expression to concatenate a dynamic filename. One solution is described in this forum thread: forums.microsoft.com/.../ShowPost.aspx.

Best wishes,

-Doug

re: The mystery of MULTIFILE

Bal — Fri, 15 Aug 2008 20:12:05 GMT

Hi:

Having created a SSIS package, the output was in the form of an Excel file, which worked.

The requirement is for output Excel file to be created in the form such as "filename" + Systemdate.xls as that would allow newly generated names. This did not work. How do I generate new Excel file names at runtime.

Thanks

Bal

re: Not for use with the SendMail task!

Phil Brammer — Thu, 07 Aug 2008 15:17:57 GMT

Very cool indeed! I think I can come up with a few packages that convey SSIS quite nicely..... ;)

SSIS and SAP

SSIS Stuff — Mon, 30 Jun 2008 01:40:10 GMT

Douglas already beat me to it , but I figured it was important enough to repeat incase you missed it

re: Excel in Integration Services, Part 2 of 3: Tables and Data Types

dougbert — Fri, 27 Jun 2008 02:53:16 GMT

Priya,

I am not sure what you mean by "appending", if you are starting with an empty workbook and worksheet. However, if you started with a sheet into which the driver once loaded data, then it still considers those rows as "used".

Cell formatting is an issue in the worksheet and not an issue with the driver. There are not "read-only" formats in Excel, although it's possible to "protect" a worksheet to prevent certain types of changes. I'm sure that the driver outputs datetime data in the default format for the locale, unless you have already formatted the column otherwise.

-Doug

re: Excel in Integration Services, Part 2 of 3: Tables and Data Types

acbpriya — Thu, 26 Jun 2008 17:15:08 GMT

dougbert,

I have two issues with Excel and SSIS

Sometime the data is appending on the excel sheet. Do you know how to overcome this. I delete the .xls and create the new.xls from a template each time when the SSIS runs.

Second issue is, one of the dates field , is not changing its datetime format. I can't even edit the format even though I can delete it and change. I want the format mm/dd/yyyy. do you have any idea on these issue?.

thx,

priya

re: Excel in Integration Services, Part 2 of 3: Tables and Data Types

dougbert — Wed, 25 Jun 2008 23:46:31 GMT

On second thought, Issue #3 is probably just Excel being helpful by copying the formatting above to newly-added rows below...just as it does when you're entering data manually.

In Excel 2007, this checkbox is titled, "Extend data range formats and formulas". I don't have Excel 2003 installed to find the equivalent option.

-Doug