Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Posts
    12

    Unanswered: ssis validation task

    Hi everyone,

    we are using validation using with .net program, uploading the excel sheet , when validating the data if any error data stored in the excel sheet if validation success data sored in the main table in sql database, so i want to know how to use this with ssis packages ,pls i need the ssis task and how to design. the code is given below.

    /****** Script for SelectTopNRows command from SSMS ******/
    SELECT TOP 1000 [ApplicationSrNo]
    ,[IssueNo]
    ,[IssueSubType]
    ,[ApplicationNo]
    ,[BranchNo]
    ,[BnkSrNo]
    ,[EntryModeDU]
    ,[ApplicantName]
    ,[BrokerNo]
    ,[BrokerName]
    ,[SubBroker]
    ,[InsTypeNo]
    ,[InsType]
    ,[IndusindAccountNo]
    ,[InstrumentNo]
    ,[InstrumentDate]
    ,[DraweeBankName]
    ,[DrawnOnLocation]
    ,[DateOfReceiptFormDeposit]
    ,[PANNo]
    ,[CategoryNo]
    ,[Category]
    ,[Status]
    ,[Folio_DPId_ClientId]
    ,[DPType]
    ,[PaymentMode]
    ,[Amount]
    ,[BondSeries1]
    ,[BondSeries2]
    ,[BondSeries3]
    ,[BondSeries4]
    ,[BondSeries5]
    ,[BondSeries6]
    ,[RightsAcceptedShares]
    ,[RightsAdditionalShares]
    ,[IPOSharesApplied]
    ,[IssueTotalUnits]
    ,[AppStatusNo]
    ,[Remark]
    ,[AddFiled1]
    ,[AddFiled2]
    ,[AddFiled3]
    ,[AddFiled4]
    ,[AddFiled5]
    ,[AddFiled6]
    ,[InvalidFlag]
    ,[Error_Desc]
    ,[New_FileName]
    ,[CreatedBy]
    FROM Citi.[dbo].[tbl_ApplicationsUpload_Error]

    i need help pls.

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The SELECT statement that you posted can be included in a SQL Task within a SSIS package "as is", you don't need to change it at all.

    I'm not sure that I understood your question. Please feel free to explain your problem further if this answer doesn't help you.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •