Thanks GSquared and ALZDBA. That was a perfect solution.

I found a way to do in VB.NET also 🙂

CStr(FieldName.TrimStart(CChar("0"))).PadRight(15)

Try this:

Imports System

Imports System.IO

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

Public Sub Main()

'

...

Use Row Sampling task in data flow transformation and specify number of records you wanted.

Thanks Jim. Thats what I thought.

Did you copy the excel file you created to remote server?

what is the error message you got?

I'm trying to delete few records in excel file using execute SQL task with excel as connection manager. I'm able to update excel file but not delete records.

I think you want to capture number of days between 1900/01/01 and another date which is in your table. you can use datediff function.

datediff(dd,startdate,enddate)

for example -

select datediff(dd,'1900/01/01','2008/03/05') gives you...

I tried to delete records in excel using execute sql task and I recieved following error -

[Execute SQL Task] Error: Executing the query " delete from products where ...

I had same issue before. Looks like getting error column is not at all easy. Read this for more:

http://www.sqlservercentral.com/Forums/Topic456102-148-1.aspx#bm457730

you can use execute sql task in the control flow to determine count of records of your query, and store this value in a variable (countofRecords).

In the precedence constraints that...

I can't find any option to make sql dynamic in data reader. The option I can think of is to use OLE DB Source pass sql command from variable.

We deployed SSIS packages on a 32-bit. Our initial plan was to deploy on 64-bit from which we backed out because all the developers were developing and compiling code on...

Make sure you compile all SSIS packages converted from DTS packages on a 64-bit machine. Do you have Oracle sources?.

Master pasackage is another SSIS package with "execute package tasks". Each execute package tasks refers to a SSIS package.

So in master package, you can create precedence constraints to execute one...

Create a Master SSIS package. you can use exectue package tasks in the control flow to execute in the order required.Call the Master SSIS package using dtexec command.