Viewing 15 posts - 12,916 through 12,930 (of 13,838 total)
After getting the record counts, set the value of a Package Level variable in a script task, eg, in pseudo code:
User::ProcessImport = "False"
If (condition) then User::ProcessImport = "True"
In your control...
March 31, 2009 at 7:18 pm
What do you mean by "identification string"?
Are you modifying only data, or are you adding, renaming or deleting columns in Excel?
March 30, 2009 at 8:08 am
Not sure about the details of your problem, but if this is just a file containing a single row and no data, it is essentially static. Therefore, why not create...
March 30, 2009 at 6:25 am
Feeling bitter after two days of pain? 🙂 We've all been there and sympathise, I'm sure ...
March 26, 2009 at 7:23 pm
Once you have the data imported to your staging area in SQL Server, going down the sp route is the way I would go - for performance reasons.
SSIS is great...
March 20, 2009 at 6:37 pm
Excellent. There are several ways - but the one I would choose is as follows:
1) It should go without saying, but use a copy of your prod database ...
2) Create...
March 19, 2009 at 10:07 pm
Do you have the descriptions already completed in soft format? A CSV file containing CourseID, Description would be an ideal starting point ...
If not, are you just looking for a...
March 19, 2009 at 5:55 pm
Now that you have used the wizard to create the basic package, you are in a position to edit and refine it ... You can definitely make it do exactly...
March 17, 2009 at 8:32 am
Hmmm, you really need an example for this?
Something along the following lines (untested & I'm getting tired):
INSERT INTO DestTable(Field1, Fieldn, SeqNo)
SELECT S.Field1, S.Fieldn, 1
FROM SourceTable S
WHERE [Source record not in...
March 17, 2009 at 7:29 am
You could have a package variable - ProcName, for example - which is set as a parameter by the stored proc as part of an Execute SQL task. Or you...
March 17, 2009 at 7:14 am
What's the error message?
March 17, 2009 at 6:55 am
SK (3/16/2009)
---filename_20090316_1015PM.csv might help out in the long run in knowing when the file ran (instead of looking at the modified date and properties of the file).
If I ever...
March 16, 2009 at 9:45 pm
So a sequence number of 8 means the record was INSERTED once and updated seven times (1 + 7 = 8)?
March 16, 2009 at 9:40 pm
Is the sequence number arbitrary? If so, why not make it an IDENTITY(1,1) field in the destination table and then SQL Server will take care of the numbering for you.
March 16, 2009 at 7:32 pm
pleasehelpme (3/16/2009)
Technology:... Any better plan?
Backup/Restore? What exactly do you mean by "full load"?
March 16, 2009 at 7:18 pm
Viewing 15 posts - 12,916 through 12,930 (of 13,838 total)