Is it possible to come at this problem from another angle? Just have a blank version of the spreadsheet living somewhere accessible, then do a delete (of old spreadsheet) and...

Have you created the package variables you need? They need to be created/declared before they can be used.

Right-click the control flow and select Variables and follow it through from there....

... and I thought I had tested that! Well, it was early in the morning :doze:

Nice approach Ramesh - great use of logic.

Phil

Haha - I know what you mean. I wasn't sure until I tried it either 🙂

declare @a varchar(50), @b-2 varchar(50)

Set @a = '01008,03072,0045,R,,,,,,,,,-17'

Set @b-2 = replace(@a, ',,', '')

select @a, @b-2

Great, thanks for the feedback & agree with your comments - you learn more by trying, even if it doesn't work out ... 🙂

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...

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 ...

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...

What do you mean by "identification string"?

Are you modifying only data, or are you adding, renaming or deleting columns in Excel?

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...

Feeling bitter after two days of pain? 🙂 We've all been there and sympathise, I'm sure ...

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...

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...

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...