Viewing 15 posts - 12,736 through 12,750 (of 13,876 total)
Extracted to what? A CSV file?
Do you mean some sort of verification process? What is your concern - is it that records get missed, or data somehow gets corrupted?
June 16, 2009 at 1:09 am
Not really, because you do not have all the foreign key information that you require at that point.
Also, is there ever a need to update existing rows in the database,...
June 15, 2009 at 10:54 pm
OK, sorry if I was not clear.
Once your data is in a staging table, there will be a series of SQL statements which need to be executed to INSERT or...
June 15, 2009 at 10:18 pm
Aha, OK, now I understand.
You need to load your master data first (ie the stuff on the 'one' side of one-to-many relationships) - Site then Student then Exam, by the...
June 15, 2009 at 9:54 pm
Your question is a bit too broad. It sounds like you have decided on a process for your SSIS package, ie, something like:
1) Truncate staging table
2) Load from CSV into...
June 15, 2009 at 8:49 pm
So if you set the text qualifier to None, does the problem go away?
June 9, 2009 at 7:59 pm
If you check the properties for your destination flat file connection, has Text Qualifier been set to {none} - but in angled brackets (they won't render here)?
You could also set...
June 9, 2009 at 6:18 pm
I'm afraid that your logic is not quite sound 🙂
You are setting Bin1, Bin2, ..., Bin9 to the same value for each letter in the binary string - so they...
June 9, 2009 at 6:09 pm
Wow, that's what I call dedication - get that man a beer!
June 9, 2009 at 8:19 am
tobe_ha (6/9/2009)
I tried to understand the structure of the xml in the package. When I format the xml, afterwards the package cannot be loaded. "Error loading ..."
How can that be?...
June 9, 2009 at 8:00 am
You have multiple sources and 1 destination - so surely it is your source data which should be dynamic and the destination which should be fixed?
Why not use a SQL...
June 9, 2009 at 5:34 am
This thread might be of interest:
http://www.sqlservercentral.com/Forums/Topic463182-148-1.aspx
June 8, 2009 at 7:16 pm
Nice solution. What happens if the expression evaluates to FALSE? I'm assuming that control flow doesn't just stop because there is no onward path?
Yeah, I know I should know the...
June 8, 2009 at 7:11 pm
Well done for persisting with this one.
In case you're still interested, here's a function I sometimes use for reading variables:
Private Function GetVariable(ByVal varName As String) As String
...
June 4, 2009 at 5:34 pm
Viewing 15 posts - 12,736 through 12,750 (of 13,876 total)