Please provide some sample data, showing what your source looks like and what you would like to see in your destination. Your explanation is confusing.

As long as the server running your packages has SSIS installed, you can get data from wherever you want.

rocky_498 (10/15/2010)

---

Thanks for your reply. My target table has field called "P_id" and its "Primary key" and requirement is 'P_id" always auto generate i.e "cba-000001", "cba-000002".

* In target table...

I presume you want help identifying why this error is occurring and are not just telling everyone your plight for information purposes.

Are you doing any string manipulation (using functions such...

10,000, I think you'll find sir 🙂

rocky_498 (10/14/2010)

---

Hi,

Can anyone help me? I have created a table and with a primary key called "ID".

However, I want the "ID" be auto increment as well.

Here is...

Afternoon here and I'm fully caffeine'd-up 🙂

Use something like Process Explorer to see what process is locking the file.

Edit the CSV file using Notepad. The zero will be there.

If you use Excel, it helpfully (:w00t:) guesses datatypes for you - numeric in this case, and therefore with no...

You need to learn how to...

mcaster (10/13/2010)

---

Being a reasonably new 'accidental' DBA, I'm open for all the good advice I can get. My Documents seems to be where SSIS wanted to put stuff, so...

Can you go into a bit more detail about what you mean by 'different'? Not that I'm expecting to be able to help - sounds most unusual.

Ninja's_RGR'us (10/12/2010)

---

Quicksort on a single column shouldn't...

I'd like to nominate this comment for UNDERSTATEMENT OF THE DAY 😀

Great!