not sure if we can alias a database, but with the method explained earlier in this post as they are just two tables you can alias those two tables and...

you found the issue, try to shutwon antivirus and then check the send mail task.

and for logging, you can ssis menu -- ssis logging -- enable it to your desired...

you can create normal ssis package logs, rit?

btw, did you check the port no.s, firewall and antivirus?

Hi,

have you tried with basic settings in the send mail task.... without adding any files and all...

check if there are any firewalls/ anti virus products

check the port no.s

Sriram

Hi,

can you pls post the error that you are getting when you perform the task using SSIS.

Sriram

hmm... should not take muc time. In Query analyser you can generate both Inser and Select scripts, just change the order for the two columns that you need. max 10-20...

Hi Latha,

Not sure on why you want to do it, as the need may have some other better solution.

Anyways, as the number of recors are very less you can create...

Hi,

you can use databsae synonyms for this.

check the below example.

The following T-SQL creates the synonym:

CREATE SYNONYM [dbo].[DimProduct]

FOR

[AdventureWorksDW].[dbo].[DimProduct]

If you now execute "SELECT * FROM DimProduct" in the AdventureWorks database, SQL...

have join between sys.schemas and sys.objects

Hi, you can also accomplish your task by detaching the db(sp_detach_db) and copying only the mdf file and going for a sp_attach_single_file_db.

Hi,

Faced an Issue of this kind, bit everything was reverse.

wrote a macro to pull data from sql to excel. the format was the same as you have explained over here,...

Hi,

You have used two many "GO"

In sql server, when you key in a code for sproc and put "go" at some place, it would feel as if the sproc has...

The best thing that you can do is to run profiler at the back end for these kind of requirements while you check that report. This can tell you from...

yes you are rit, but we can use it in some cases where we have columns like last inserted or last updated....

How are you trying to add the data into the table. can you pls give some more data abt the issue that you are facing.

You can setup a linked...