Are you able to log into the destination server (2008), using Remote Desktop, and run SSMS?

Then you can set security on the linked server to: 'Be made using the login's...

What you have is a Named, default instance, and only one instance on the server.

During installation it is possible to give the default instance a name.

In SSMS both names (ServerA...

Jon,

try a file system task to copy the files to a "local" location for processing.

get the UNC path to the file(s) from your IT dept.

ArkWare

I am using expressions to set the 'ServerName' property of my connection manager from the sServerName variable. This works beautifully at design time and the value is reflected in connection...

I'm using SSMS 2008, connecting to named default instance SQL 2008 cluster. Original registration was just the 'DNSname'. This connection worked except no green arrow.

Created an alias, Name: 'DNSname\instancename' Server:...

Seth,

very nice. good explaination.

I have one question...

in the following code, isn't it returning the first of the week +/- 2 days?

SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 2)

--: 2010-03-01 00:00:00.000 Start of the...

mbarkell (4/7/2010)

---

On my system using the query for the first day of the week gives Monday instead of Sunday which is, of course, incorrect. Is this based on the...

This should do it...

DECLARE @date as datetime

set @date = '01/01/2010'

SELECT CONVERT(varchar(11), @date, 101) as Today

, CAST(DATEPART(month,d.firstday) as varchar(2)) + '\' + CAST(DATEPART(day,d.firstday) as VARCHAR(2)) +

' - ' + CAST(DATEPART(month,d.lastday) as...

So many ways to calculate dates.... 🙂

within the context of the SP, how about only one select statement to give you both first and last?

need to change @FL to 0...

I'm wondering why the use of Distinct at all...

BOL: By default, the UNION operator removes duplicate rows from the result set. If you use ALL, all rows are included in...

VERY COOL David!

another suggestion may be to use SSIS Expressions to rename the file.

See attached for an example of adding the date to a filename.

ArkWare

I have a package in which I am using a ForEach container. The Enuminator is set at Foreach File Enuminator. I have a variable in which the path...

No Problem, Dude

Expressions are your friend.. 😎

ArkWare

Hey Danny,

one way to get the file name only would be to create another variable. set it's property, EvaluateAsExpression to True. Then enter the following expression:

REVERSE(SUBSTRING( REVERSE(@[User::filename]),1, FINDSTRING( REVERSE(@[User::filename]) ,...