K,

Thanks for help. Was trying to avoid duplicate work but not sure it's possible. Don't really see the logic of pushing the data from an ERP into a DW and...

Thanks Ken. Unfortunately, I don't know of a way to connect directly to Teradata from SQL Server 2005 to write code. I think it works in SQL Server 2008 but...

I am just trying to connect to Teradabata from SSMS - actually transfer some data from Tera tables into SQL tables - and get this error message.

===================================

===================================

Invalid connection string. (Teradata.Client.Provider)

------------------------------

Program...

Great. Will let you know how it works out. Thanks!

Will that create all the tables from one database to another? I need to do a bunch of test scripts and bring in the new data using new packages that...

OK Great! I did it and will turn off autogrowth on the full drive/filegroup to see if anything crashes. I didn't want to do it before I added the new...

hmmm I actually like the idea of turning off autogrowth and forcing the new data to the new filegroup. I think I will do that. It doesn't solve the issue...

Wow! Your solution sounds scary somehow. I guess I will have to give it a shot and see how it goes. I think there are fewer repercussions to consider by...

The problem is resolved. None of the obvious issues were present which is why I posed the question to this group. What resolved it was remoting in to the server...

WITH basedata AS

(

SELECT DISTINCT

Account

, sum(amount) over (partition by account) Total

FROM Resolved

WHERE documentnumber LIKE '79%'

AND LoadID = dbo.dbFunc_Determine_CurRptMth_LoadID()

GROUP BY Account

, Amount

)

SELECT DISTINCT

basedata.Account

, basedata.Total

, b.Name1 as Customer

,...

Hi Everyone,

Thanks for your suggestions - none of which actually solved the problem. However, they caused me to think in a different direction and I was able to get the...

Oddly enough that resulted in just the original 25 records. There are 380 records so Top 25 should of course be 25 and the Balance should be 355 records. I...

Here is the complete error message.

Error Messages:

--------------------------------------------------

No match for regular expression; component fails.

--------------------------------------------------

SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Regex" (49) failed with error code 0xC0209029. The...

Yeah!!!! It took a little trying and retrying to get rid of the validation errors but now it is working like a charm. In fact, I think I will change...

ROAR!!! TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at VTTK to Staging [DTS.Pipeline]: input column "TKNUM" (25410) has lineage ID 24473 that was not previously used in the Data Flow...