Hi Bob and Wayne

Thanks for the suggestions.I will definitely keep in mind on how to post the questions with proper data and code and will use this approach in future.I...

Thanks Lutz,i apologise i had to do this on sunday.I was so desperate about resolving query i have tried for few days but couldn't combine two queries ,i tried "between"...

Hi Lutz

My sincere thank you for your help.

Thanks

Hi,

Thanks for the reply and i appreciate help on this . Its a hourly base booking.

The following is the data table structure without any index on it

bookingid,username,startdate,enddate

startdate...

Hi,

Sorry missed this

SELECT * FROM Table WHEREStartDate NOT LIKE '[0-3][0-9]/[0-1][0-9]/[0-9][0-9][0-9][0-9]'

The above returned the records

Thanks for the help

Hi,

Thanks for the reply, when i run the below

SELECT * FROM Table WHERE ISDATE(StartDate = 0

i dont get any records returned.So i think table has valid datetime's

and also...

Hi,

Thanks for the reply,every file has different schema, some of them straight way work and some them break

current datatype of columns is set DT_STR with a length of 250

I...

Hi,

Sorry for sequence of ?'s

I can dynamically map the flat file source value to the variable value but i get metadata error when i run it

[Flat File...

Hi there,

I tried derived column and that worked,thanks very much.i would like to set the flatfile source which is to a dynamic file which has a value of foreach iteration...

Hi,

Please disregard above post .Actually this worked for me by setting

delayvalidation=true;

Thanks

Hi All,

I resolved the issue by encrypting the package with the password and by providing the same password to decrypt in sql server at Job step properties-command line level

Thanks...

hi there,

tried it but doesn't work

thanks

Hi,

when i run under msdb,integration services the package works but when i run same thing under sql server it doesnt work any idea

Please suggest me on how

Thanks

Hi,

You gave me hint,and thanks for the reply everything is soughted now

Thanks

Thanks for the reply,

I went and checked manually in destination folder,the file transfer is complete with in 15mins.I comparing sizes i assume that file transfer is complete(but the file size...