I'm not sure what you mean when you say you are trying to log in to SSIS.

Normally, the way I get into SSIS is by opening Visual Studio. That...

I'm a firm believer in making communication as personal as possible.

I'll put requests in writing (that way there's a record), but I prefer face-to-face or voice-to-voice (phone, voice-chat, etc.), over...

samsql, I still need you to clarify what you're asking for when you mention cases.

I found a solution. It's based on the way OLE DB works. Turns out that it scans a few rows of the Excel file, figures out what data...

I recently set something up to import Excel files from a directory, with different names for the files. In order to get it to work, I had to build...

Yeah, an indexed (persisted) view would help with lazy spooling. That makes sense.

You're welcome. Glad I could help.

SQL Server can handle 20- to 100-million rows no problem, so long as they are well-designed.

The problem isn't the number of rows, it's the overhead from processing metadata that way.

If...

The first thing I'd do is look at the execution plan for the query and see what's going on with that. Are there table scans? Index scans? ...

Have you looked at adding XML indexes to the columns?

I've found that parsing out XML is a major performance hog, but with XML indexes it becomes fast and painless.

I'm not sure I follow your question. Are you asking how to select a computed column, or how to create one? You can't use one computed column in...

You can use OpenQuery to pull data from the ADSI. For example (secure data removed):

ALTER VIEW [dbo].[vwActiveDirectory]

AS

SELECT

CAST(objectGUID AS BINARY(16)) AS ActiveDirID,

CAST(SAMAccountName AS VARCHAR(20))...

I have a CLR proc that clears the files out of a directory prior to another proc writing files to that directory. I have a CLR function that calls...

I just tested this:

create table #T (

PT_Window_ID varchar(50),

PT_UD_Key varchar(50),

PT_UD_Number int,

STRGA255 varchar(50))

insert into #T

select 'SOPENTRY','L100011',4,'MANUFACTURER' union all

select 'SOPENTRY','L100011',6,'SHIP' union all

select 'SOPENTRY','L100011',8,'PACK' union all

select 'SOPENTRY','L100011',14,'VESSEL'

SELECT PT_Window_ID, PT_UD_Key, [4], [6], [8], [14]

...

Depending on the edition of SQL Server, of course.