I cheked the collation and it is the same..I am going to reload the data and test this..

Thanks for the response..

-VG

Yes, I agree with you in handling the expressons in file system task in such a pain. Thanks for the script and I used script task and midified the way...

Sorry, I would have explained little more about my situation.

I want to read the column value along with some other select statements.

select column1, column2,

case column3

when countrycode = 'US' then...

Got it working....Adding the variables to exepression for arguments of execute process task worked.

I added like this- @[User::ZipDirectory] + " "+ @[User::newestFile]

-VG

It is Package level variable....

I have this in script task: and mesagebox gives me the varaible value, but this is not passed to execute process task.

Imports System

Imports System.Data

Imports System.Math

Imports...

SSIS package "Package.dtsx" starting.

Error: 0xC0014054 at Execute Process Task: Failed to lock variable "D:\SSIS\SQLBackups\G_backup_201003250030.bak" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt...

Looks like, the file gets archived or moved from there...Try setting delay validation = true...This may help...

VG

How you are calling the SSIS package from the job, I mean through dtexec? There are issues with support to 32 bot and 64 bit excel... Please read more on...

Wow, just perfect for me...just added more where condition to this...

SELECT j.name,

js.step_id,

js.step_name,

...

Why do you want to use SSIS for this? A simple insert into, select will do right?

If you have to in SSIS, then have dataflow task with oledb source ...

I don't see the profile name used here ...

EXEC sp_send_dbmail @profile_name='DBA',

@recipients='x@hello.com',

@subject='Hello',

@body='This is an automated message.'

-VG

First try to empty the file and then remove it..If it can not be emptied, then can not be removed....

USE [database]

GO

DBCC SHRINKFILE (file2_log' , EMPTYFILE)

GO

USE [database]

GO

ALTER DATABASE [GLP] REMOVE...

Is it possible to use OPENROWSET to call an exe on the other server?

-VG

I am suggested to use Remote Procedure Call for this...Not sure how?

I know, this is possible by Linked server, which is my last option...

-VG

For the steps to run on the other server - can not be handled by SSIS, since it a executable and it should run on the other server, after this...