Viewing 15 posts - 1,396 through 1,410 (of 3,232 total)
Hi Phil,
Great question. First off, I just wanted to say that there is nothing wrong with the staging table approach. I just wanted to point out that...
June 17, 2009 at 1:44 pm
I have no experience w/ the Checksum Transformation, but you could accomplish the same thing with the SCD transformation or by using lookups. That is assuming that you could...
June 17, 2009 at 12:22 pm
OK, that's what I was hoping! You've got 2 options here and I'll go through them both seperately.
Option #1: SSIS import to staging table w/ SP driven...
June 17, 2009 at 10:37 am
If it is row counts that you are concernted about, you could create an audit/history table of sorts that you can use to insert 1 row for each time your...
June 17, 2009 at 9:32 am
From what I'm hearing, doing all of your validations within the SSIS pipeline is what I would do. I am a bit confused though as to your concept of...
June 16, 2009 at 5:30 pm
I don't have examples of existing documents that I can give you, but documenting a DR setup is not much different than documenting a setup for any other environment. ...
June 16, 2009 at 4:34 pm
I hope that I'm not adding to your confusion, but keep in mind that SSIS is a full fledged ETL tool so you don't really need to load a staging...
June 16, 2009 at 4:27 pm
Any time SSIS throws the Error: "Cannot convert between Unicode and Non-Unicode String data types", it means that the source and target datatype values are not the same. SSIS...
June 16, 2009 at 4:19 pm
I'm having trouble following you as well. You'll need to tell us a bit more about what you are trying to do. How is the data being extracted...
June 16, 2009 at 4:16 pm
Do you have Integration Services installed on the box that you're trying to schedule it on?
June 16, 2009 at 4:10 pm
Can you elaborate on the file type? Is the file fixed length columns, comma delimited, etc?
June 16, 2009 at 3:28 pm
Removing the primary key is definately NOT the answer here. The primary key is there to prevent you from being able to create duplicate rows. Removing it will...
June 16, 2009 at 12:35 am
I'm surprised that no replies have been generated by this yet. I guess, if nothing else, my reply will bump your thread so that it is active again. ...
June 12, 2009 at 3:52 pm
You've got a Primary Key constraint on your table and you are attempting to import a duplicate key. Can you post your table DDL for dbo.ThomsonEDData?
June 12, 2009 at 3:24 pm
You've posted this to a SQL Server 2000 forum so you'll be limited to SCOPE_IDENTITY(). If this were SQL Server 2005 or up, you could (and should due to...
June 10, 2009 at 12:58 pm
Viewing 15 posts - 1,396 through 1,410 (of 3,232 total)