Viewing 15 posts - 1,381 through 1,395 (of 3,232 total)
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...
June 19, 2009 at 10:13 am
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...
June 19, 2009 at 10:09 am
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...
June 19, 2009 at 9:58 am
First off, why would you want to store a date as a character column?
June 18, 2009 at 10:28 am
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...
June 18, 2009 at 9:47 am
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. ...
June 18, 2009 at 9:18 am
Phil Parkin (6/17/2009)
June 18, 2009 at 9:11 am
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
June 17, 2009 at 3:58 pm
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...
June 17, 2009 at 3:48 pm
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...
June 17, 2009 at 3:24 pm
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...
June 17, 2009 at 3:14 pm
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...
June 17, 2009 at 2:59 pm
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...
June 17, 2009 at 2:49 pm
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...
June 17, 2009 at 2:46 pm
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...
June 17, 2009 at 2:42 pm
Viewing 15 posts - 1,381 through 1,395 (of 3,232 total)