as I mentioned above

"The values that show in the properties are normally the values that exist based on the debugging environment and can differ based on how you're actually calling...

are you using SQL Server 2005?

Yes, on both the local and the linked

What do you have listed in your security tab? Did you set anything up?

*I have a SQL Authentication...

Google is good for this kind of things.

"tsql interview questions" should do it.

I'm not sure why you would want to do this.

I'm assuming SA is activated on both servers? Are you mapping sa (local) to sa (linked) or impersonating?

SQL might have...

As I mentioned earlier.

I have tried to create a linked server which uses Windows Authentication to Authenticate a linked server. I originally wanted to see if this could be...

I've created a DOMAIN\USERNAME login for the db instance, and a user for the two databases i'm trying to link.

Now when I try to test the connection, i...

I've created a DOMAIN\USERNAME login for the db instance, and a user for the two databases i'm trying to link.

Now when I try to test the connection, i...

Aside from being bad practice is there any other reason that I shouldn't use the BUILTIN\Administrator Account? I really want to use windows Authentication, and since i don't need...

The values that show in the properties are normally the values that exist based on the debugging environment and can differ based on how you're actually calling the package. ...

Rich, Sorry for the delay. Here's the meat and potatoes.

Create a Script Task. The script task either needs to have the path passed in or needs to...

When I log into the production box i use my domain log in through remote desktop.

I then can navigate to the .dtsx file. and execute it successfully.

for the sake of...

Anyone have any thoughts on this? Even confirmation of my assumptions would help.

Thanks.

Script task all the way!

Assuming you can check the location for the possibly updated file. You could easily get this info.

For instnace.

Dim t As DateTime = File.GetCreationTime(_filepath)

If t.[Date] = DateTime.Today.[Date]...

You can also use a script task to get your *.txt functionality

This will require writing a function opens an ftp connection.

This is ideal if you can't actually predict the filename...

Sorry not to specify this further, here are some more details...

Excell is not installed on the server, that is why I am using the oledb drivers.

Development is my machine, 32...