SSIS just changes the way you could use accounts. You still need to get an account that works. Something doesn't seem right here. Are you executing this in SSMS and...

It's not that you document and slog through everything. But you don't often know or realize what's important when it happens. How often have you had something occur and wished...

You get one chance to make a first impression, but you can fix...

Good editorial. I certainly like my comfort zone and don't like moving out of it. I tried last year, with the idea that I'd speak more, do more community stuff....

Here are a couple SSIS links:

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

http://www.simple-talk.com/community/forums/thread/5173.aspx

http://www.sqlis.com/post/File-Watcher-Task.aspx

http://stackoverflow.com/questions/541693/how-can-i-specify-a-variable-file-name-using-ssis

Does the file name change according to a pattern (date, etc)? Can you calculate it? If so you can use scripts to calculate the name...

moved

It was 60F before the snow hit, a couple days in fact. Last Jan I think we averaged about 50F for the month, which is fairly warm out here. Without...

The local administrator typically doesn't have rights on another machine. The path you show is a remote machine, and that's why it is suggested that it is suggested that...

Jack Corbett (12/10/2009)

---

I should mention that it is going to be cold tomorrow. High's will only be in th mid 60's. I may break out a long-sleeved shirt...

You can change the batch size in the DTS package to a smaller number. I've done this in groups of 1000 to narrow things down, then you can change it...

Enjoy that Jack, it's a nice, balmy 1.5F here.

A few hints. The general work for a self join is

select a.x, b.y

from mytable a

inner join mytable b

on a.pk =...

I would not use T-SQL to do this. User VBScript or the Powershell scripting languages to do this. They are better suited to work with files.

The FileSystemObject can help you...

Well we're wrong. It appears that as long as you don't have XP home you can install standard edition. This from BOL (http://msdn.microsoft.com/en-us/library/ms143506%28SQL.90%29.aspx)

I would assume that would apply to Win...

Actually I'm not sure it's wrong. When you insert/update data you can cause a page split. In that case, the data is rearranged on disk.