Yeah, i knew signed/unsigned integer differences. What i wanted was the exact datatype match between ssis and sql table, which i got from the link you have given. Thanks.

That means sql cant be used to secure the data and i have to use .NET or any other programs to get what i need.

Thanks for the reply.

I have few columns like SSN, Creditcard details in the table which i dont want every one who has access to the table to see. Even if they see the...

The query given is useful to me in a different way. But its not what i desired. What i need is whether a job is scheduled to run on Sunday,monday,tuesday...Saturday...

Gail,

Both the db's are exact copy of each other and return same amount of records.

In the server where its working i see parallel query threads. But in issue server, only...

Gail, what else can be done to improve query running time. Since query runs in <1min in another dev server but runs for 2hrs in production machine

Yes, starting from 1 to 230 is the page count for such NC which has more % frag

1. The other 3 Depth rows (other than 1) has more frag >70. Rebuild reduced frag for depth id 1 row

2. NC - I ran both rebuild and reorganize for...

I ran indexphysical stats dmv and found 4 rows for 1 clustered index with depth 4 row having 80% fragmentation. Even after runnning, ALTER INDEX [INDEX] ON [dbo].

REBUILD WITH...

I have read that and I understand that its not necessary to have multiple tempdb files. But my question was, how do i come to that conclusion whether mutltiple files...

Job move is already over. Cant go back and recreate them now. Thts the reason got stuck in this.

scripting out individual jobs is cumbersome when we have 1000+ jobs. We copied the sysjobs (not all jobs, 850+ only) to target server and now we have to move the...

To given an example, I need 2 csv files on running an select query from 2 tables. I know how to use BCP to export to csv. I now need...

Without using .cmd or .bat files, which has clear passwords, i can give it in a job. Then how to use BCP to export more than a file.

Thank You Ness. Finally someone replied. am reading the post.

Another Q. Can a package be set with more than one config settings, so at 2 different schedules, 2 different...