The Slowly Changing Dimension data flow transformation is a wizard that walks you through defining your SCD. In it, you tell it what your business key is and what...

In your first explanation, you referenced moving data from an Oracle source to a SQL Server destination. Now you are talking about flat files? I'm not sure I...

I would question their use even when implemented correctly. IDENTITY is the way to go in SQL Server when for surrogate key creation. Can someone give me a...

First off, why would you want to store a date as a character column?

Ah, the Sequence Table. If not implemented correctly, you're going to be chasing deadlock problems until you're blue in the face. I can't say it any better than...

Coffee....mmmm.

I hate to recommend web resources other than SSC because it is by far the best, but since Jamie Thomson requents SSC as well, I'll give him due credit. ...

Phil Parkin (6/17/2009)

---

You have mentioned "Script Task" and "Script Component" as if they are the interchangeable - they are not. Just for clarification, I'm assuming that you mean Script Task...

DECLARE @Table TABLE (RowValue varchar(15))

INSERT INTO @Table

SELECT 'ABC_error' UNION ALL

SELECT 'CDB' UNION ALL

SELECT 'XYZ' UNION ALL

SELECT 'YUY' UNION ALL

SELECT 'ROP_error'

SELECT REPLACE(RowValue,'_error','')

FROM @Table

Some of that may depend on what is in the NOT EXISTS() clause. In this example, the SELECT statement in the NOT EXISTS is referencing a table outside the...

I would favor the original query over the NOT EXISTS query. Your execution plan my look the same on this small example, but you'll see different results when you...

You could create one file destination and use the expression builder to create the file names so your process is dynamic enough to create as many (or few) files as...

Bob,

Your example does not work. Your INSERT INTO....VALUES construct is not correct. Also, I have a feeling your SELECT code in your example is not producing the...

Do you know the location of the file or do you want to attempt to pull it from the sharepoint api? If you can get the physical location of...

Just curious, why are you using a script task for this? I aggree that you should attempt to run a test where you write the files locally and then...

SQL Server only has the abillty to create SQL Server database backups. What you need is a file system backup. I would recommend working with your network or...