Here is my code, that I added to use variable....

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports Microsoft.Office.Interop.Excel

Imports System.IO

Imports System.Text

<System.AddIn.AddIn("ScriptMain", Version:="1.0", Publisher:="", Description:="")> _

<System.CLSCompliantAttribute(False)> _

Partial Public Class ScriptMain

Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase

Enum ScriptResults

Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success

Failure =...

Thanks for your email. I GOOGLE it before I submit my question, I couldn't figure it out thats why I asked.

Below is VB 2008/Script Task Editor Code, that I used for rename the sheet name/tab name in my excel sheet. Let me give you background what I am doing, I...

Sheet name is not same every day we receive the file. File Name = Filename_MMDDYYYY and Tab Name = FileName_MMDDYYYY

I am using SQL Table to get the file name. First step Insert all FolderPath+FileName to SQL Table and then using the file name Variable in Foreach Loop Container as...

Tab is not same every day we receive the file and File Name = Filename_MMDDYYYY and Tab Name = FileName_MMDDYYYY

Thank you all again,

I get that far, the problem I am getting in Script Task I can easy add My Total count variable value and its working fine. I...

Thank You all for reply.

I am sorry, I think it was my mistake didn't explain you what I need.

I know how to create Flat file Plus

I know how...

qq it should be +3 not -3, am i right?

declare @d datetime = '2/1/2014 05:28:13 AM'

select dateadd(HOUR,+3,@d)

The time I am receiving is PST and want to convert in EST. am...

Thank You, So Much!

Awesome, it works fine...

Thank You.

I am sorry, I am lost, would you mind if you help me with expression?

Thank guys for reply.

Koen, I am using 2008 R2 VS, I am not seeing LEFT STRING FUNCTION in derived column. Please advise.

Eirikur, This file, i am not inserting in sql...

MM,

You are right, I am not good in .Net or c#, Here is the code that I am using. If you could help me, That would be big help...

Thank You All for your reply. I think My question is not clear or I couldn't explain very well.

My original question was In My store procedure I am inserting...