You're kidding, right?

Sentence 1 from the link:

How were you going to run the package...

Have a look at the on-line help here.

And presumably an integer (given that you are performing maths on it)?

In which case, why not something like:

...

ABCD_Call_ID...

By the way, that query syntax is a little unusual. What does @[User::_FileID] contain?

Create an ExecuteSQL task and use an Expression to define the SQL to be executed - you'll be able to build the expression to include your variables as required.

Create an integer package variable (scoped...

What provider did you choose and what error message did you get? Please copy/paste the exact text.

Four hours, that's harsh. Post back if you have any questions about coding in the script component. As an Informix guy, this is a bit of a change for you,...

bhavika.chauhan (4/15/2011)

---

I have to import data from Excel to Database .

In between that i need to check several validations such as duplicates, Distinct rows , quantity cannot be negative etc...

Oh yeah! My weekend started early when I couldn't get to work today (not my fault) 🙂 Haven't quite made it to the pub yet, but the beer is getting...

That's also the only idea I had for this one.

I have just spent some time looking at this and seems that one of the simplest solutions is to change the column delimiter to something else - I used |...

quillis131 (4/14/2011)

---

I know looping through files is easy in SSIS. But struck up, need a idea to functiona package.

My package should load Data in files to the Table. ...

Have you tried connecting to the 2000 instance from within 2005 Management Studio? Once that's in place (use a linked server), you can just use standard queries to move data...

So far, you haven't mentioned anything that can't be done in a stored proc ...