If you do not need to do this more then once then I would do a data compare from SSIS.

If you could provide some more information that would be helpful. Is this in a package? What are you loding froma and what transform or destination is giving the...

In an execute SQL task do something like Select 'C:\Myfolder\Myfile'+ year(Getdate()) +'.txt'

asign this result set to a variable.

select the file in the connection manager. Just a single click....

Here is what I would do. Create a variable and store the minnimum value in that variable by doing a select Min(distinct(year)... something like that and store the result...

This one had me curious so I did some digging and unfortunatley cam up empty handed. You can get the spid from the SQL SERVER log if you look...

The following Quote was taken from an article that can be found here

http://www.builderau.com.au/program/sqlserver/soa/SQL-Server-Grant-access-but-maintain-security/0,339028455,320277786,00.htm

Assigning REFERENCES permission allows the owner of another table to use columns in the table to which they've...

I ran into a similiar problem once and while all the data to the eye appeared to me exactly the same I discovred through much hair pulling and then dumb...

Sweet I will keep toying with it then.

I don't mean to be dense but I have looked at every page on the control panel and I do not see an option to change a password anywhere. ...

I actually tried that first and I managed to add an entry and give it a title but I have tried it on several different machines and I can not...

I thought I would throw my two cents in on this one since I beleive I have likely asked a question in the past that seemed obvious to many. ...

While I am new to SSIS and SQL Server I came from a sybase world and did alot of such silly requests. In all cases the sillier the request...