That doesn't work because the header row has 5 columns and the select statement has 15 columns. They both have to have 15 in order to work with a union. I'm...

In case you were wondering how, I figured it out... 😀

CASE WHEN PATINDEX('%[^0-9]%', [ts].[DESCRIPTION]) > 0

...

B-E-A-utiful. Thank you very much!

I did this 50 flippin times yesterday and it didnt work. Today, worked like a charm. I guess SSIS likes Thursday's better than Wednesday's.... :sick:

Thank you everyone!

Thank you for the advise. I made some other discoveries in the database that also point to performance problems (FK and CONSTRAINT's not trusted, etc.).

I have some work to...

Excellent. Thank you for the post.

Here's what I did.

I created two variables: MonthEndDatabase and MonthEndDate as both STRINGS at the PACKAGE LEVEL. I set MonthEndDatabase = DB_MonthEnd_ and...

This is exactly what I was looking for. Thank you

Thank you Gail.

I realized that the data was working fine before a specific date. After that date, the report loading started to fail. I sent the ticket back to...

Okay, since you just burst my bubble, let me ask you a question. The SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED is being used on reports only and those reports are...

Never mind, that was a stupid question. It cannot be placed after the CTE... Sorry for the brain fart!

Normally SSIS flat file source inside a data flow task that uses a variable to look for anything in a directory that ends with *.csv or *.txt.

I figured it out...

Public Class ScriptMain

Public Sub Main()

For Each file...

Perfect Suggestion. It worked like a charm. I dropped RIGHT('00000' + CAST(CAST(INCOMING_VALUE AS INT) AS VARCHAR(5)) ,CASE WHEN CAST(INCOMING_Value AS INT) > 9999 THEN 5 ELSE 4 END) in...

Sorry Lynn

My COMMENT table (original table in DB) and TEMP_COMMENT are indentical in fields and data types. COMMENT has the FK on it while TEMP_COMMENT has no FK's or PK...

AND maybe it would help if I gave you a table to insert into...???

CREATE TABLE [dbo].[TEMP_COMMENT]

(

[GUID] [varchar](32) NULL

, [TYPE_CODE]...