Viewing 15 posts - 1,036 through 1,050 (of 3,232 total)
SSIS is very metadata dependant. Each source, destination, and the transformations that you put in between them rely heavily on the metadata that SSIS gets from the source and...
August 31, 2009 at 10:30 am
Some of that depends on how you will be using your backend database. Is the application using it, is it kept around for compliance, is it used for reporting,...
August 31, 2009 at 10:23 am
The Conditional Split transformation is what you'll need to pull off a CASE statement. It will let you bucket, using expressions, your data in your pipleline and route each...
August 31, 2009 at 10:16 am
What does the query plan look like? Do you have an index on the account type or class code columns?
August 31, 2009 at 10:01 am
How about providing us with your table structure, sample data (in a readily consumable format) and an example of the output your would want to see based off of your...
August 31, 2009 at 9:57 am
Checkai gave you exactly what you asked for. If it does not work, how about showing us an example of some data that you want filtered out that this...
August 31, 2009 at 9:46 am
Yes, you definately want to use year/week and not have weeks from different years in a partition. Here's a great article on table partitioning that uses a sliding window...
August 31, 2009 at 8:48 am
I see from your link that :
The XML source does not validate the data in the XML file against the XSD.
It must just do a basic structural validation. You'll...
August 27, 2009 at 3:55 pm
I did not say to not use a CTE. Its just an alternative way of coding the same solution. As far as ease-of-reading goes, they're almost identical w/...
August 27, 2009 at 3:51 pm
You'll notice if you look at the metadata for each of the outputs from the XML source, that the parent node ID is included as metadata for the dependant nodes....
August 27, 2009 at 3:45 pm
Just an after-thought Greg, but I wanted to point out that you can still do schema validations with the incomming xml using schema collections. I'm not sure if that...
August 27, 2009 at 3:05 pm
Thanks for the update Greg. You should get a pretty good pat on the back for that improvement....from 100 to 40,000! That's impressive!
August 27, 2009 at 2:58 pm
There are 2 ways we learn, mentors and mistakes. A mentor can be a person, but it can also be a support group like SSC or your local user...
August 27, 2009 at 2:53 pm
Can you provide sample data to show the problem you just described?
August 27, 2009 at 2:49 pm
And w/o the CTE:
DECLARE @Table1 TABLE (col1 char(2), col2 int)
INSERT INTO @Table1
SELECT 'aa', 12 UNION ALL
SELECT 'bb', 22 UNION ALL
SELECT 'cc', 33
DECLARE @Table2 TABLE (col1 char(2), col2 int)
INSERT INTO @Table2
SELECT...
August 27, 2009 at 2:36 pm
Viewing 15 posts - 1,036 through 1,050 (of 3,232 total)