Any suggestions please??

Thanks for your valuable suggestions...I didn't create a covered index as the number of columns in include statement are more( & table has around 40 million records), didn't want...

Phil, thanks for your reply....all i wanted to do i dynamically extract Access schema and create views to insert data into database....In other words all i wanted to do is...

Yes it's asking for the passwords when i open package

One more basic question....How to change the execution method of the sql job to use xp_cmdshell??(I never did it before 🙁 )

what's the advantage of using xp_cmdshell (not sure how it works, never used it before)...I always create it as a SSIS package....

Yes, i don't have "/DECRYPT [INSERT PASSWORD HERE]" in...

Thanks Ramaswamy

Just Figured out that the last row doesn't have a character return, so it didn't pick up....How do i validate to check whether there is a character return at the...

I have a dataflow which extracts data from the flat file and loads it into Sql Server, b ut for some reason the last row is not added to...

Thanks for your input

So it means the package should be running 24/7 ....Does it impact the performance of the server?? 🙂

Yeah exactly,have to deal with it.....Anyways thanks for u'r help

Yes, i have values in Puma which are not integers(that's why i am casting my ID in Masada table to varchar)....

but there are ways around it

How do i work around...

Here is the query

select c.ID

from

Masada c with (nolock),

Puma r with (nolock)

where right('000000' + cast(c.ID as varchar(7)),7) =r.ID

Masada table has around 2 million records

Any other suggestions?? Padding took lot of resources(It took almost 2 sec to execute the query)