Viewing 15 posts - 12,916 through 12,930 (of 13,841 total)
Great, thanks for the feedback & agree with your comments - you learn more by trying, even if it doesn't work out ... 🙂
March 31, 2009 at 10:58 pm
I'm afraid I still do not understand the requirement. Can you post sample data showing
a) the current data, and
b) how you would like the data to look after running the...
March 31, 2009 at 8:07 pm
You just need all occurrences of the field to be 1? Can't believe it's that simple, but here goes:
update security_instrument_financing_statement_activity_reporting
set sequence_number = 1
If I've misunderstood something, please clarify ...
March 31, 2009 at 7:27 pm
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
Viewing 15 posts - 12,916 through 12,930 (of 13,841 total)