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

"Didactic" - as in instructive? Do you mean that those people using between should receive instruction before doing so? 🙂

BETWEEN works fine as long as you know what you're doing...

SSIS can move data around as much as you want, but if you are new to the product you are going to have to spend some time getting up to...

sri.gads (4/14/2011)

---

Yeah, but this do not contain any work around sample. I would like to have work around or do a small sample for practice. i.e to update a sharepoint...