Pete T-366679 (10/28/2009)

---

I have a flat file connection manager, set to a test file, and a flat file source that reads this file into a database.

What I want to do...

You can use...

You have to have:

EvalExpression:@Time_key<=143

I don't think the for loop container will execute at all. Otherwise I think the approach you have is correct.

Pete T-366679 (10/22/2009)

---

I am parsing an input flat file, and want to direct it to multiple tables. Each row of the input file could correspond to 1-N rows in...

winston Smith (10/21/2009)

---

I am writing a package that will be writing a file out to a share on the server.

This used to be done with sp_makeWebTask. This made it...

SSIS user (10/19/2009)

---

Hello experts,

I am trying to add rows based on the division number

eg : I have the standard quantity 50

If the inventory number is 120 (which is greater...

r_prasanna82 (10/16/2009)

---

Hi All

Sorry for th elate response. I tried IBM driver but it didnt work. The doubt i have is whether DB2 uses default port and user defined port (i...

You can change the name of the data flow column to be different than the original source column. This will...

If you can use third-party components, I would suggest you check the commercial CozyRoc Data Flow Task Plus. It is enhanced to support dynamic data flows. You can specify a...

dlapitan (10/15/2009)

---

I'm using sp_send_dbmail and would like to email the rowcount against multiple tables. The format I'm looking for is something like this...

A little msg here indicating that the nightly...

SQL Learner-684602 (10/14/2009)

---

Hi all,

I have one question...

I have a huge dimension table (7 million reks) in which i have to do updates if any column changes, I am using lookup...

Have you tried using "IBM OLE DB Provider for DB2" ? Microsoft's driver is quite old and it may not work in all cases.

Bhavesh-1094084 (10/14/2009)

---

I've created an Output metadata in scriptcomponent. One of the column in meta data is numeric with scale and precision values.

Now in the script component when I read data...

vvkp (10/12/2009)

---

Hello,

1. I have lot of different tables data to be extracted to flat files like table1, table2, table3.....tableXXX.

2. I need to run select * from each table and capturing...

You are correct. I just tried the same on my machine and no matter what I enter it succeeds. The problem is the provider. I would suggest you contact MS.