Forum Replies Created

Viewing 15 posts - 16 through 30 (of 84 total)

  • RE: how to covert this dts package to ssis package

    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

  • RE: Get Created Date from a File

    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.

  • RE: Get Created Date from a File

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

  • RE: Get Created Date from a File

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

  • RE: Get Created Date from a File

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

  • RE: Validate Parameter value in expression

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

    Thank You

  • RE: My assignment VLDB desing spec

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

  • RE: plz its urgentttttt help me out

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

  • RE: plz its urgentttttt help me out

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

  • RE: plz its urgentttttt help me out

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

  • RE: SQL Task to pass results to parameter

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

  • RE: Data Validation-Transactional Replication

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

  • RE: Data Validation-Transactional Replication

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

  • RE: Date Validation for Date Parameter

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

  • RE: Date Validation for Date Parameter

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

Viewing 15 posts - 16 through 30 (of 84 total)