Hi Gary,

I have not done any DTS upgrade but I did find this site pretty useful.

http://wiki.sqlis.com/default.aspx/SQLISWiki/UpgradingDTS.html

Chinna,

The attachment shows that you are looking at the Flat File connection mng.Tim is talking about the Script Component in Data Flow tab.

chinna (4/10/2008)

---

hi lookup but how can i add new column to the script component i just had read variable write varibale and expression but i couldnt find anyhting to...

Hi Chinna,

To add an Output or input Column:

In Script Component[In data flow],go to Inputs and Outputs Tab,

Click on Output0,

Click on Output Column Folder.

Look below, you would be able...

Hi Tim,

I tried the code you have given above.Correct me if Im wrong, all I have to do is to add an output column in the script component, given name...

Got it solved by http://support.microsoft.com/kb/906547 .

Thank You

Here is some additional info:-

This is a huge Data Warehouse and the current size is 2.5TB with an expectation to grow up to 4TB [growing fast]

Everyday there are about 14...

Did you try after replacing the Metadata to sync the columns ?[As in my previous post]

At least if you run it after that, you should not be getting those error...

Warning: 0x800470C8 at Data Flow Task, Flat File Source [1]: The external metadata column collection is out of synchronization with the data source columns. The column "Column 23" needs to...

Double Click on the connection in connection mng and try the following:

Try with "Retain NULL values from the source as NULL in the data flow" in the connection mng.

Also go...

Apologies Folks...manage to get it work ..Needed extra twigging.

After futher checking, I decided to reconfigure the transactional replication of an indexed view from Server A to table on Server B.

Anyone has complete step by step guide for me...

Hi,

I just checked further. This transactional replication is between an indexed view and a table.

This problem started 2 days ago.No error mssg, nothing in log files,

Users are complaining in consistency...

Hi Nigel,

Thanks for your response.Here is what I have done so far.I have 3 tables on the report, therefore ..

1)Do I add the below,to all 3 datasets?

IF @StartDate >= '01...

Hi would you please give me a detailed explanation on the steps to be taken.Where in my query do I add an if statment.My query is used to display customer...