Thanks Koen for quick info. Let us try to upgrade SSIS and check.

Hi Koen,

Thanks for your reply. Currently, i am using 2005 Version. But it seems the link is for 2012 i guess.

Can you suggest any option available on SSIS 2005.

---

One more way!

1. Get Today date from Script Task and store it in an variable.

Now.AddDays(0).Date.ToString("MM/dd/yyyy")

2. Pass that variable in your DB Source along with your condition.

SELECT <Column Name>

FROM TableName

WHERE...

Sorry for the delay response. 🙂

Yes, we have indexes and using standard edition. Seems different DB will not work out since permission issue.

Will try to automate as per the suggestions.

Thanks!

Step 1: You can read the excel file based on below connection string in your Script Task.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source='"& <Your Source Path> &"';Extended Properties='Excel 12.0;HDR=" & <FirstRowIsHeader = YES> & ";IMEX=1

Step...

Option - 1: You can make use of LookUp and Condition Split Transformation to achive this.

Option - 2: You can do this by Creating a Procedure.

A. Load all the...

1. You can make use of String Funtions in Derived Transformation to make change as NULL.

2. Then use Row Count Transformation to get the count of empty or null.

3. If...

You could see Gen_DATE has the import date. Please let me know if any.

Thanks.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblGen](

[PROCESS_ID] [bigint] NOT NULL,

[Gen_FLAG] [bit] NOT NULL CONSTRAINT [DF_FLAG] DEFAULT ((0)),

[Gen_DATE] [datetime] NOT NULL CONSTRAINT [DF_DATE] DEFAULT (getdate())

) ON [PRIMARY]

In your case, use deptno.In Condition tab, you can define deptno = 101 as one case and deptno = 110 as another case.

Thanks Man. Thanks for your reply. I got it now....

1. Create code like below in Script Task: v_FileName is your source file.[C:\<Your File Name>.csv]

Dim vFileName, vDate, vFilePath As String

...

Thanks Guys,

I have done it by using two different Data Flow Task calling two different procedures with one flat file connection with unchecking the Overwrite data in file from Flat...

Thanks Phil!

I can modify the procedure...

yes, i can able to modify my procedure.