if it is plain text, i'd just use bulk insert instead of building an SSIS package;

for me, that would be faster than anything else.

both ways are available via the extended proc xp_logininfo , but the limitation is the group/user has to be added to SQL first before you can enumerate them.

if you...

from a real command window, bcp has access to all shares that the caller(you) have access to;'

but if you call bcp from xp_cmdshell, it is almost certainly using a different...

it depends on the shape of the data you want to report;

Can All 50 queries results be placed in a temp table, or do you need each resultset? just...

you'll wnat to set your session variable for dateformat to handle this for you:

SET DATEFORMAT DMY

select

cast ('14/02/2014' as date)

i think you just need to switch to a binary collation, otherwise accented letters like àâáãäå are all the same as 'a', right?

Select * From [Table] Where [Column] Like '%[^0-9a-zA-Z...

if SSMS scripting option below is selected, then dynamic SQL is generated to handle the if not exists, and that is what you are seeing.

you pasted just a piece of...

well, it's not going to be easy, but this will get you started;

because you are not using the right data types (a string containing '9:00 - 9:30a' instead of two...

to grant a user the ability to see the metadata stuff for any object in a database, without granting access to the data within those objects, you can grant VIEW...

SQL server is probably not the target platform you want to use for this; is this supposed to send / retrieve information from the web service and return it to...

on the same server, i believe it's no problem; every query eventually gets resolved to all objects to thee part naming conventions...database.schema.object;

I have a system I babysit that we recently...

please edit your post and remove that varbinary string. it does not help, and just muchs up teh post to make it...

there is a YEAR function that returns an integer, that can do what you are asking:

there is also a DATEPART function that can do the same, but you can pull...

gajayku (7/2/2014)

Thanks for quick response. Let assume that I have schema of both source and destination in the following formats.

In excel File, I have columns (Id, Name, Salary) and...

where is the comparison going to occur? in a script task , likecomparing rows in a datatable DataTable to DataTable, for example?

on the SQL server so you can use...