Thanks for your reply. I think i have to be more specific about my question? I don't have a problem in migrating databases. I have finished everything and everything is...

FYI it is the same and single sql 2005 environment in which i am trying to open the package.

You know what may be i have got the solution. It's...

Apology for the typing mistake but i am opening the same packet in the same environment which is sql 2005 BIDS. I have corrected my typing by BOLD 2005 latter....

I modifying an existing SSIS package from SQL Server 2005 . I open the SSIS package in BIDS and make some changes (for example, I change the server name in...

This Might help :

Database products on Windows typically offer an OLE DB or ODBC data source provider -- a piece of middleware registered with the system that allows any application...

the database was able to send an email before but now it is not able to send any mail through it. I suspect that sql database was using any MAPI...

I had a look to that link but it didn't clear my problem. My problem is like Migrated from 32 bit to 64 bit and users machine are XP and...

Thanks you very much for your reply and information. Small information can solve many confusions.

One more question regarding to this is how can we identify that we have installed...

Thanks for ur sincere answer.

The question i asked is because MSDB database contains job information and master database contains other information. so if i migrate sql agent jobs and...

Thanks for ur answer.

Hi Jason,

Thanks for you time and replying my question. I know what are the features are not in the sql express. But can you please be more specific on my...

I did specify. But no worries now. I got another script. That worked for me. Here is the Script.

select dp.NAME AS principal_name,

...

Hi,

Thanks for ur reply. But that script didn't work. It just returned the column names with blank output. I have created one user defined role called db_executor and i have...

Hi,

you know what, i am trying to delete entried from other server which is in different domain.

There is already a SSIs package to do this job created with the otherdomain\serviceadmin...

Thanks for ure reply.

How to Turn on the logging mode?? which logging mode? in sql server agent or in business intellegent studio.

One more think is i cehanged the serviceadmin...