Before making blanket statements like this, I find that it is always...

Nice trick.

To replace leading zeros but not others? Please demonstrate how.

Mordred (5/21/2013)

---

Where do I set the default connection? I'm going...

Use Package Configurations.

waralees (5/21/2013)

---

Thanks Phil Parkin, You answer my question. i want to use only one data flow task to copy data from various datasource table to various destination table also by...

waralees (5/21/2013)

---

Dear All,

i have task to copy all data from source table to destination table (30 table), so i keep source table name and destination table name...

I think you might be overdoing the looping.

If your source folder structure looks something like this:

root

root\AA

root\BB

root\CC

etc

then you can configure your FEL to point at folder <root> and check the 'Traverse...

I apologise for the jargon. FEL is just an abbreviation for 'Foreach Loop Container' - it is used quite often here.

The example you mentioned looks like a good place to...

I'd...

Of course - almost everything is possible in SSIS, given enough development effort 🙂

How's your C#? I'd use a Script Task for this.

Which part don't you understand?

I don't think that there is a two-minute way of doing...

greeshatu (5/20/2013)

---

Select and Update are running paralelly .. this is because I have used Balance data distributor to run the tasks parallely .Which asyncronous transformations is helpful in this case.kindly...

Your data comes in from Excel as Unicode.

If you are mapping it straight to varchar() columns, you will get an error.

Add a data conversion component to convert your columns from...

I couldn't find a way of doing this in an iTVF.

If you execute the following:

sp_executesql N'select * from products where name like @ProdName'

,N'@ProdName varchar(30)'

,@ProdName = 'Samsung%'

You'll get the idea of...