Viewing 12 posts - 616 through 628 (of 628 total)
If you do not need to do this more then once then I would do a data compare from SSIS.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 15, 2010 at 7:16 am
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 15, 2010 at 7:14 am
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....
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 15, 2010 at 7:10 am
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 12, 2010 at 2:47 pm
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 12, 2010 at 2:21 pm
The following Quote was taken from an article that can be found here
Assigning REFERENCES permission allows the owner of another table to use columns in the table to which they've...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 12, 2010 at 1:58 pm
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 12, 2010 at 12:59 pm
Sweet I will keep toying with it then.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 10, 2010 at 8:55 am
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. ...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 10, 2010 at 8:49 am
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 10, 2010 at 7:26 am
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. ...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 9, 2010 at 3:19 pm
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
January 21, 2009 at 7:55 am
Viewing 12 posts - 616 through 628 (of 628 total)